SELECT * FROM `x$statements_with_runtimes_in_95th_percentile`
|
query | db | full_scan | exec_count | err_count | warn_count | total_latency | max_latency | avg_latency | rows_sent | rows_sent_avg | rows_examined | rows_examined_avg | first_seen | last_seen | digest | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | information_schema | * | 3 | 0 | 0 | 345273968000 | 344310939000 | 115091322000 | 26 | 9 | 128 | 43 | 2024-06-28 04:00:52.870159 | 2024-06-28 04:00:53.029052 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `t` . `THREAD_ID` AS `thread_id` , IF ( ( `... | sys | * | 3 | 0 | 0 | 83526887000 | 56397118000 | 27842295000 | 26 | 9 | 26 | 9 | 2024-06-28 04:01:02.092325 | 2024-06-28 04:01:03.785479 | 2a5e41c03bf35093f51e81fb81b13e07005f0c742759ae7a75... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | sakila | 6 | 0 | 0 | 123666959000 | 72730103000 | 20611159000 | 11 | 2 | 130 | 22 | 2024-06-28 04:00:56.647590 | 2024-06-28 04:01:06.512481 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | sakila | * | 2 | 0 | 0 | 34818917000 | 20587950000 | 17409458000 | 2 | 1 | 116 | 58 | 2024-06-28 04:00:56.762109 | 2024-06-28 04:01:06.533940 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT ? FROM `sakila` . `film` LIMIT ? | sakila | 2 | 0 | 0 | 15726979000 | 15542316000 | 7863489000 | 2 | 1 | 2 | 1 | 2024-06-28 04:00:56.572596 | 2024-06-28 04:00:56.782134 | 3aee09d8f6b4d1def813ef0417f3f977f1c24ac96b55120e63... | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 21 | 0 | 0 | 148377739000 | 57777348000 | 7065606000 | 38 | 2 | 1080 | 51 | 2024-06-28 04:00:52.244645 | 2024-06-28 04:01:08.178672 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | ||
SELECT * FROM `store` LIMIT ?, ... | sakila | * | 1 | 0 | 0 | 5584079000 | 5584079000 | 5584079000 | 2 | 2 | 2 | 2 | 2024-06-28 04:01:06.473479 | 2024-06-28 04:01:06.473479 | af55fc36bef9a3a86009bf6d6e199b24bc355ec92538784068... |
|