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` .... | mysql | 7 | 0 | 0 | 74044881000 | 69919060000 | 10577840000 | 14 | 2 | 460 | 66 | 2024-07-02 10:00:55.922792 | 2024-07-02 10:01:11.538278 | e3754fc046bb107bbb10877d2fe790492ee1d9ae1cb44cfe2c... | ||
SELECT `rtn` . `name` AS `SPECIFIC_NAME` , `cat` .... | NULL | * | 2 | 0 | 0 | 17904366000 | 17314260000 | 8952183000 | 0 | 0 | 164 | 82 | 2024-07-02 10:00:56.273041 | 2024-07-02 10:00:56.273994 | 7631a5a7c833f09d7cda4f7029a221c376e319d404c83e678f... | |
SELECT * FROM `events_statements_current` LIMIT ?,... | performance_schema | * | 1 | 0 | 0 | 4242638000 | 4242638000 | 4242638000 | 11 | 11 | 11 | 11 | 2024-07-02 10:01:11.463752 | 2024-07-02 10:01:11.463752 | 48a66f51b70d4dbcfae28baea5e7e549cd3303a632540a0923... | |
SELECT `PLUGIN_NAME` , `PLUGIN_DESCRIPTION` FROM `... | mysql | * | 1 | 0 | 0 | 3648441000 | 3648441000 | 3648441000 | 4 | 4 | 45 | 45 | 2024-07-02 10:01:11.311650 | 2024-07-02 10:01:11.311650 | da64fef78148590bc22ae2f4a50212e867078d1a1ab3eb530a... | |
SELECT `cat` . `name` AS `TABLE_CATALOG` , `sch` .... | mysql | * | 7 | 0 | 0 | 19333327000 | 13490047000 | 2761903000 | 7 | 1 | 707 | 101 | 2024-07-02 10:00:55.947011 | 2024-07-02 10:01:11.555717 | ba13537dd94689c4264c4c28d0ef4ccb35dd60734589f76d58... | |
SHOW MASTER STATUS | mysql | 1 | 0 | 0 | 1937333000 | 1937333000 | 1937333000 | 0 | 0 | 0 | 0 | 2024-07-02 10:01:07.579259 | 2024-07-02 10:01:07.579259 | fe219218c4249a2b7359e16fe5d3b48ae7c93e3e412600bedb... |
|