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` .... | NULL | 23 | 0 | 0 | 859739222000 | 129146392000 | 37379966000 | 47 | 2 | 484 | 21 | 2024-07-01 02:30:59.948715 | 2024-07-01 02:31:00.862229 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | sakila | * | 5 | 0 | 0 | 71409813000 | 56628087000 | 14281962000 | 11 | 2 | 501 | 100 | 2024-07-01 02:31:07.353506 | 2024-07-01 02:31:20.338870 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SELECT DESCRIPTION , `c` . `name` FROM `film` `f` ... | sakila | * | 1 | 0 | 0 | 14120403000 | 14120403000 | 14120403000 | 25 | 25 | 55 | 55 | 2024-07-01 02:31:07.346220 | 2024-07-01 02:31:07.346220 | f89dc860b7bd4d2ae418b4a3689385f580c316cdc307744885... | |
SELECT ? FROM `mysql` . `help_topic` LIMIT ? | mysql | 2 | 0 | 0 | 20664615000 | 20577057000 | 10332307000 | 2 | 1 | 2 | 1 | 2024-07-01 02:31:20.812725 | 2024-07-01 02:31:20.994891 | 388a47c21e57ff94b264c6499629cd2cb3f420247ed7507029... | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | information_schema | * | 3 | 0 | 0 | 29255639000 | 27399596000 | 9751879000 | 26 | 9 | 1185 | 395 | 2024-07-01 02:31:06.115125 | 2024-07-01 02:31:06.335694 | 251552b68e8f44795ca803316d221e604ec58591e3d9d3654e... | |
SELECT COUNT ( * ) FROM `sakila` . `actor` | sakila | 1 | 0 | 0 | 8607914000 | 8607914000 | 8607914000 | 1 | 1 | 0 | 0 | 2024-07-01 02:31:20.347779 | 2024-07-01 02:31:20.347779 | 9fd7a41096f271a04d0c0933ea6f851bf2ccb44eda613d4b82... | ||
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | performance_schema | 218 | 0 | 0 | 860987195000 | 611779697000 | 3949482000 | 13452 | 62 | 67914 | 312 | 2024-07-01 02:30:54.589259 | 2024-07-01 02:31:32.258423 | 52130efcc005f1f55d730c79ca046d88d1ea2be12c692ae778... |
|