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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CREATE SCHEMA `gallery_db` | NULL | 1 | 0 | 0 | 45762620000 | 45762620000 | 45762620000 | 0 | 0 | 0 | 0 | 2024-06-27 20:31:01.136264 | 2024-06-27 20:31:01.136264 | a2da743fcdde3c1af24b08cb07427b173c0320d1336a7b1e35... | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | 8 | 0 | 0 | 105921211000 | 46152121000 | 13240151000 | 16 | 2 | 394 | 49 | 2024-06-27 20:30:55.425200 | 2024-06-27 20:31:01.499350 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | * | 6 | 0 | 0 | 71262002000 | 55599491000 | 11877000000 | 6 | 1 | 607 | 101 | 2024-06-27 20:30:55.447824 | 2024-06-27 20:31:01.598561 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | NULL | 1 | 0 | 0 | 3359499000 | 3359499000 | 3359499000 | 131 | 131 | 448 | 448 | 2024-06-27 20:30:56.498319 | 2024-06-27 20:30:56.498319 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... | ||
SELECT @@`skip_networking` , @@`skip_name_resolve`... | NULL | 1 | 0 | 0 | 3097637000 | 3097637000 | 3097637000 | 1 | 1 | 1 | 1 | 2024-06-27 20:30:47.617515 | 2024-06-27 20:30:47.617515 | 1ebda414995104bec2d678a2f3a337c8cc504cafa93982ba39... |
|