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 | payment | 70.94 ms | 32090 | 70.94 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 67 | 1.09 MiB | 13.58 ms | 0 | 0 bytes | 0 ps | 5 | 42.75 us | |
sakila | rental | 18.58 ms | 41250 | 18.58 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 20 | 368.00 KiB | 5.55 ms | 0 | 0 bytes | 0 ps | 5 | 23.75 us | |
sakila | country | 5.23 ms | 81 | 5.23 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 5.04 ms | 0 | 0 bytes | 0 ps | 5 | 97.19 us | |
sakila | city | 4.12 ms | 55 | 4.12 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 3.97 ms | 0 | 0 bytes | 0 ps | 5 | 42.10 us | |
test19 | ecurie | 3.81 ms | 5 | 3.81 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 4.01 ms | 0 | 0 bytes | 0 ps | 5 | 45.31 us | |
sakila | language | 3.24 ms | 132 | 3.24 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.56 ms | 0 | 0 bytes | 0 ps | 5 | 43.06 us | |
sakila | inventory | 2.94 ms | 9192 | 2.94 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 23 | 416.00 KiB | 2.44 ms | 0 | 0 bytes | 0 ps | 5 | 62.83 us | |
sys | sys_config | 2.54 ms | 56 | 2.54 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.76 ms | 0 | 0 bytes | 0 ps | 5 | 45.86 us | |
sakila | film | 1.80 ms | 155 | 1.80 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 1.93 ms | 0 | 0 bytes | 0 ps | 5 | 37.57 us | |
vedettfak | fa | 1.28 ms | 3 | 1.28 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.37 ms | 0 | 0 bytes | 0 ps | 5 | 39.29 us | |
TlapaleriaMalfoy | Registro | 1.14 ms | 3 | 1.14 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.04 ms | 0 | 0 bytes | 0 ps | 5 | 40.29 us | |
vedettfak | megye | 1.13 ms | 85 | 1.13 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 846.31 us | 0 | 0 bytes | 0 ps | 5 | 350.23 us | |
sakila | address | 985.04 us | 30 | 985.04 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 1.47 ms | 0 | 0 bytes | 0 ps | 5 | 33.30 us | |
BUBBLE_LAUNDRY | CUSTOMER | 639.40 us | 31 | 448.88 us | 3 | 190.53 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 10 | 256.00 KiB | 301.99 us | 9 | 85.26 ms | |
sakila | staff | 614.26 us | 4 | 614.26 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 784.83 us | 0 | 0 bytes | 0 ps | 5 | 26.16 us | |
sakila | store | 589.50 us | 6 | 589.50 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 706.38 us | 0 | 0 bytes | 0 ps | 5 | 45.40 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 | |
mysql | columns | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_key_column_usage | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_keys | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|