SELECT * FROM `x$statement_analysis`
|
query | db | full_scan | exec_count | err_count | warn_count | total_latency | max_latency | avg_latency | lock_latency | rows_sent | rows_sent_avg | rows_examined | rows_examined_avg | rows_affected | rows_affected_avg | tmp_tables | tmp_disk_tables | rows_sorted | sort_merge_passes | digest | first_seen | last_seen | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | mysql | * | 1572 | 674 | 5 | 724444717000 | 4487931000 | 460842000 | 212009000000 | 7887 | 5 | 50795 | 32 | 0 | 0 | 2008 | 0 | 13830 | 0 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | 2024-07-30 15:46:23.042381 | 2024-07-30 15:48:04.411642 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 2701 | 1748 | 0 | 713099580000 | 2284287000 | 264013000 | 208817000000 | 0 | 0 | 2859 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | 2024-07-30 15:46:22.797175 | 2024-07-30 15:48:04.423732 | ||
SHOW SESSION VARIABLES LIKE ? | mysql | * | 678 | 0 | 0 | 607825330000 | 3277779000 | 896497000 | 58289000000 | 678 | 1 | 389172 | 574 | 0 | 0 | 678 | 0 | 0 | 0 | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | 2024-07-30 15:46:22.794602 | 2024-07-30 15:48:04.402265 | |
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | performance_schema | * | 1272 | 600 | 0 | 595316914000 | 43397788000 | 468016000 | 154558000000 | 5544 | 4 | 37128 | 29 | 0 | 0 | 1512 | 0 | 10080 | 0 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | 2024-07-30 15:46:22.856991 | 2024-07-30 15:48:04.257824 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 737 | 318 | 0 | 584144361000 | 4153629000 | 792597000 | 167563000000 | 20879 | 28 | 106940 | 145 | 0 | 0 | 409 | 0 | 20859 | 0 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | 2024-07-30 15:46:22.798478 | 2024-07-30 15:48:04.359255 | ||
SHOW SESSION VARIABLES LIKE ? | performance_schema | * | 636 | 0 | 0 | 568179126000 | 7142740000 | 893363000 | 56673000000 | 636 | 1 | 365064 | 574 | 0 | 0 | 636 | 0 | 0 | 0 | 6935f3922a42d8845977364d3d83d2ad4e11a53295dfeca9d0... | 2024-07-30 15:46:22.767319 | 2024-07-30 15:48:04.248443 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | * | 1051 | 882 | 0 | 566733411000 | 6051194000 | 539232000 | 78022000000 | 169 | 0 | 69290 | 66 | 0 | 0 | 169 | 0 | 169 | 0 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | 2024-07-30 15:46:22.780826 | 2024-07-30 15:48:04.269637 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 2429 | 2074 | 0 | 548421970000 | 2589589000 | 225780000 | 76879000000 | 0 | 0 | 1065 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4c1b79eed973bf098a4c2fad1e12545b1192162c6b05bc1650... | 2024-07-30 15:46:22.774360 | 2024-07-30 15:48:04.270028 | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 635 | 298 | 0 | 512174728000 | 5450163000 | 806574000 | 135120000000 | 21848 | 34 | 110251 | 174 | 0 | 0 | 337 | 0 | 21848 | 0 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | 2024-07-30 15:46:22.784214 | 2024-07-30 15:48:04.198235 | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | * | 812 | 606 | 0 | 507820143000 | 22004717000 | 625394000 | 96224000000 | 366 | 0 | 83998 | 103 | 0 | 0 | 201 | 0 | 366 | 0 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | 2024-07-30 15:46:22.928517 | 2024-07-30 15:48:04.423289 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 487 | 286 | 0 | 318394076000 | 88295518000 | 653786000 | 78384000000 | 402 | 1 | 13264 | 27 | 0 | 0 | 201 | 0 | 402 | 0 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | 2024-07-30 15:46:22.887076 | 2024-07-30 15:48:04.349156 | ||
SELECT `cat` . `name` AS `CATALOG_NAME` , `sch` . ... | NULL | * | 379 | 37 | 0 | 238072315000 | 2120368000 | 628159000 | 83746000000 | 3358 | 9 | 22026 | 58 | 0 | 0 | 788 | 0 | 6240 | 0 | db22765f86fdb091d2faced7479895f8497b40140b15fad577... | 2024-07-30 15:46:22.955636 | 2024-07-30 15:48:01.712636 | |
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | mysql | * | 406 | 0 | 0 | 223337845000 | 7830798000 | 550093000 | 77679000000 | 406 | 1 | 1341 | 3 | 0 | 0 | 2842 | 0 | 0 | 0 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | 2024-07-30 15:46:23.080399 | 2024-07-30 15:48:04.424374 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | NULL | * | 230 | 94 | 0 | 209267561000 | 3270359000 | 909858000 | 77161000000 | 3400 | 15 | 34119 | 148 | 0 | 0 | 40 | 0 | 3400 | 0 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | 2024-07-30 15:46:23.490633 | 2024-07-30 15:48:03.704351 | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 467 | 298 | 0 | 202478082000 | 1706942000 | 433571000 | 59938000000 | 501 | 1 | 2849 | 6 | 0 | 0 | 169 | 0 | 501 | 0 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | 2024-07-30 15:46:22.785969 | 2024-07-30 15:48:04.189240 | ||
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | performance_schema | * | 318 | 0 | 0 | 162976431000 | 2049472000 | 512504000 | 58326000000 | 318 | 1 | 991 | 3 | 0 | 0 | 2226 | 0 | 0 | 0 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | 2024-07-30 15:46:22.892705 | 2024-07-30 15:48:04.270648 | |
SHOW TABLES FROM `phpmyadmin` | NULL | 968 | 968 | 0 | 160619400000 | 931027000 | 165929000 | 64862000000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | f5bb748eacacd13477b0b560e396419adad288f4b8dabefd99... | 2024-07-30 15:46:22.742646 | 2024-07-30 15:48:04.484014 | ||
SELECT ? FROM `mysql` . `user` LIMIT ? | NULL | 881 | 0 | 0 | 137065829000 | 16921702000 | 155579000 | 75401000000 | 881 | 1 | 881 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | caa245231a373af9cc7a93fe5788b8f09816b409a4f960a049... | 2024-07-30 15:46:22.759702 | 2024-07-30 15:48:04.498700 | ||
GRANT USAGE ON * . * TO ? @? | mysql | 2 | 0 | 0 | 89657292000 | 56108769000 | 44828646000 | 773000000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | c68f69cefc067439bf3eeb4cb1f6c9bdaf2950202005c8a2fd... | 2024-07-30 15:46:42.768230 | 2024-07-30 15:47:20.095778 | ||
SELECT ? FROM ( SELECT `GRANTEE` , `IS_GRANTABLE` ... | NULL | * | 158 | 0 | 0 | 89044659000 | 1651709000 | 563573000 | 30439000000 | 158 | 1 | 567 | 4 | 0 | 0 | 1106 | 0 | 0 | 0 | 10fd6b82750e447978ae64a0f55479eb8f723a721d8f3be40c... | 2024-07-30 15:46:23.010450 | 2024-07-30 15:48:01.745847 | |
SELECT COUNT ( * ) FROM `performance_schema` . `ta... | performance_schema | * | 283 | 0 | 0 | 88989359000 | 9538470000 | 314450000 | 19744000000 | 283 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 00e2f0d84fa651f12d7029618430a48906da993321f506b59a... | 2024-07-30 15:46:22.781688 | 2024-07-30 15:48:03.755246 | |
SELECT * FROM `table_lock_waits_summary_by_table` ... | performance_schema | * | 283 | 0 | 0 | 88131315000 | 4050134000 | 311418000 | 19867000000 | 7075 | 25 | 7075 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 7a2c40da54f6eaa63f18600a655f716160a294ba03cafa0764... | 2024-07-30 15:46:22.771102 | 2024-07-30 15:48:03.750304 | |
SELECT @@`version` , @@`version_comment` | NULL | 968 | 0 | 0 | 82561394000 | 1070478000 | 85290000 | 0 | 968 | 1 | 968 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | a0fb6033a801ff3ccaad9bb0b05445638ab6c4d8fcb821afff... | 2024-07-30 15:46:22.741459 | 2024-07-30 15:48:04.483104 | ||
SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA` ... | mysql | * | 360 | 0 | 0 | 78430191000 | 1373461000 | 217861000 | 22634000000 | 360 | 1 | 48864 | 136 | 0 | 0 | 360 | 0 | 0 | 0 | cb739922a85d75e06037f1af1f5f9ee1f741e9af76ee5358cc... | 2024-07-30 15:46:23.085450 | 2024-07-30 15:48:04.424818 | |
REVOKE ALL PRIVILEGES ON * . * FROM ? @? | mysql | 2 | 0 | 0 | 75186691000 | 39413051000 | 37593345000 | 1858000000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 710e40ee98b6a9f7feb335f9f173c2fad284eb12b792072d9a... | 2024-07-30 15:46:42.711378 | 2024-07-30 15:47:19.987649 |
|
Warning in ./src/Table/Table.php#291
Undefined array key "Create_time"Backtrace
Warning in ./src/Table/Table.php#291
Undefined array key "TABLE_COMMENT"Backtrace