SELECT * FROM `x$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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
INFS1200_RELEASE | Policy | 11594369424 | 105 | 11594369424 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 1423029168 | 0 | 0 | 0 | 5 | 9858320736 | |
sakila | language | 4755068208 | 1147 | 4755068208 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 488009280 | 0 | 0 | 0 | 5 | 88539264 | |
sakila | film | 4084087920 | 491 | 4084087920 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2226037440 | 0 | 0 | 0 | 5 | 70663824 | |
INFS1200_RELEASE | Address | 2578684416 | 336 | 2578684416 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 440514096 | 0 | 0 | 0 | 5 | 362607168 | |
sakila | film_category | 2241745440 | 3 | 2241745440 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 2077876416 | 0 | 0 | 0 | 5 | 54098352 | |
sys | sys_config | 1852383984 | 5 | 1852383984 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 407570064 | 0 | 0 | 0 | 5 | 93103824 | |
INFS1200_RELEASE | Customer | 1837113696 | 133 | 1837113696 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 386807520 | 0 | 0 | 0 | 5 | 275542608 | |
INFS1200_RELEASE | Vehicle | 1719219744 | 70 | 1719219744 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 1084374192 | 0 | 0 | 0 | 5 | 184919856 | |
sakila | category | 1238110896 | 81 | 1238110896 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 473283360 | 0 | 0 | 0 | 5 | 338807040 | |
sakila | customer | 1173144720 | 26 | 1173144720 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 922061712 | 0 | 0 | 0 | 5 | 19692816 | |
vedettfak | megye | 1130261616 | 3 | 1130261616 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 553008192 | 0 | 0 | 0 | 5 | 524291328 | |
sakila | address | 896561952 | 53 | 896561952 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 742748688 | 0 | 0 | 0 | 5 | 19643712 | |
sakila | city | 807879072 | 37 | 807879072 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 620766960 | 0 | 0 | 0 | 5 | 22836528 | |
sakila | country | 430827936 | 10 | 430827936 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 342223200 | 0 | 0 | 0 | 5 | 40724640 | |
mysql | dd_properties | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | schemata | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespace_files | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_type_elements | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_key_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_keys | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_column_usage | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | index_partitions | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|