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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sakila | film_category | 169253390592 | 165002 | 169253390592 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2722413936 | 0 | 0 | 0 | 5 | 23896224 | |
sakila | film | 90675730992 | 154313 | 90675730992 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1605058224 | 0 | 0 | 0 | 5 | 45052128 | |
sakila | film_actor | 38955375888 | 165200 | 38955375888 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 294912 | 4918855920 | 0 | 0 | 0 | 5 | 44617056 | |
sakila | category | 3550985328 | 5135 | 3550985328 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 641869008 | 0 | 0 | 0 | 5 | 22348656 | |
sakila | actor | 3519756768 | 200 | 3519756768 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3600706560 | 0 | 0 | 0 | 5 | 55087824 | |
sakila | address | 2961903120 | 25 | 2961903120 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 131072 | 2867614992 | 0 | 0 | 0 | 5 | 38633760 | |
sakila | customer | 2850307152 | 26 | 2850307152 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3205784208 | 0 | 0 | 0 | 5 | 44052096 | |
sakila | language | 2551539408 | 207 | 2551539408 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 940879104 | 0 | 0 | 0 | 5 | 80280816 | |
INFS1200_RELEASE | Policy | 2441657328 | 247 | 1824321840 | 48 | 617335488 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 588037824 | 10 | 115350323088 | |
INFS1200_RELEASE | Vehicle | 1645837776 | 272 | 1349435472 | 33 | 296402304 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 663204960 | 9 | 62359062480 | |
sys | sys_config | 1536912432 | 14 | 1536912432 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 802476048 | 0 | 0 | 0 | 5 | 721403760 | |
INFS1200_RELEASE | Customer | 1491145392 | 154 | 1212441120 | 14 | 278704272 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 5608119792 | 9 | 86798985504 | |
products,sql | customers | 1326431568 | 736 | 1326431568 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
products | suppliers | 1278490752 | 389 | 1278490752 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 265047024 | 6 | 41525411136 | |
products | customers | 1191123120 | 767 | 1191123120 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 145296096 | 7 | 58733998224 | |
sakila | country | 1140974736 | 102 | 1140974736 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 833771664 | 0 | 0 | 0 | 5 | 41806512 | |
sakila | inventory | 1111976448 | 26 | 1111976448 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2850387408 | 0 | 0 | 0 | 5 | 60572688 | |
sakila | city | 1091440416 | 52 | 1091440416 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1130088432 | 0 | 0 | 0 | 5 | 67163712 | |
products | shippers | 1076717136 | 164 | 1076717136 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 202952112 | 6 | 46783660176 | |
products,sql | employees | 1031833968 | 199 | 1031833968 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
products | employees | 1018765968 | 215 | 1018765968 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 213202176 | 6 | 53925095664 | |
products | categories | 1001042064 | 195 | 1001042064 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 243911184 | 6 | 40433255808 | |
products | products | 849273744 | 174 | 849273744 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 4834476768 | 10 | 78298646448 | |
products,sql | shippers | 785104320 | 143 | 785104320 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
products,sql | categories | 759568128 | 112 | 759568128 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|