SELECT * FROM `schema_table_statistics`
|
table_schema | table_name | total_latency | rows_fetched | fetch_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency | io_read_requests | io_read | io_read_latency | io_write_requests | io_write | io_write_latency | io_misc_requests | io_misc_latency | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | rental | 57.05 ms | 190 | 57.05 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 53 | 896.00 KiB | 63.61 ms | 0 | 0 bytes | 0 ps | 5 | 66.50 us | |
sakila | inventory | 5.52 ms | 2272 | 5.52 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 5.32 ms | 0 | 0 bytes | 0 ps | 5 | 38.73 us | |
sakila | film | 5.28 ms | 1325 | 5.28 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 2.95 ms | 0 | 0 bytes | 0 ps | 5 | 38.26 us | |
sakila | language | 4.50 ms | 1574 | 4.50 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 734.67 us | 0 | 0 bytes | 0 ps | 5 | 58.08 us | |
sakila | customer | 4.35 ms | 2444 | 4.35 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 1.61 ms | 0 | 0 bytes | 0 ps | 5 | 56.75 us | |
sakila | address | 4.09 ms | 907 | 4.09 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 2.05 ms | 0 | 0 bytes | 0 ps | 5 | 47.27 us | |
test19 | ecurie | 4.00 ms | 2 | 4.00 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.47 ms | 0 | 0 bytes | 0 ps | 5 | 1.74 ms | |
sakila | country | 3.85 ms | 29 | 3.85 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 3.89 ms | 0 | 0 bytes | 0 ps | 5 | 48.74 us | |
sakila | staff | 3.55 ms | 246 | 3.55 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 1.88 ms | 0 | 0 bytes | 0 ps | 5 | 55.72 us | |
vedettfak | megye | 2.84 ms | 41 | 2.84 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 699.44 us | 0 | 0 bytes | 0 ps | 5 | 197.05 us | |
test19 | voiture | 2.18 ms | 3 | 2.18 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.38 ms | 0 | 0 bytes | 0 ps | 5 | 59.36 us | |
vedettfak | fa | 1.53 ms | 4 | 1.53 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.36 ms | 0 | 0 bytes | 0 ps | 5 | 303.00 us | |
sakila | actor | 1.32 ms | 112 | 1.32 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.02 ms | 0 | 0 bytes | 0 ps | 5 | 77.62 us | |
sakila | film_actor | 1.19 ms | 2 | 1.19 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.29 ms | 0 | 0 bytes | 0 ps | 5 | 43.23 us | |
sakila | city | 1.18 ms | 25 | 1.18 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 6 | 144.00 KiB | 951.53 us | 0 | 0 bytes | 0 ps | 5 | 64.57 us | |
sakila | store | 1.00 ms | 61 | 1.00 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 697.00 us | 0 | 0 bytes | 0 ps | 5 | 35.82 us | |
world | City | 793.55 us | 27 | 793.55 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 27 | 2.02 KiB | 906.53 us | 0 | 0 bytes | 0 ps | 6 | 41.92 us | |
test19 | pilote | 708.96 us | 2 | 708.96 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 881.22 us | 0 | 0 bytes | 0 ps | 5 | 50.02 us | |
world | Country | 47.66 us | 2 | 47.66 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 2 | 462 bytes | 172.30 us | 0 | 0 bytes | 0 ps | 5 | 31.34 us | |
mysql | dd_properties | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | schemata | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespace_files | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_type_elements | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|