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 | 169290944064 | 165004 | 169290944064 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 180224 | 2722413936 | 0 | 0 | 0 | 5 | 23896224 | |
sakila | film | 91257925968 | 154617 | 91257925968 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 1605058224 | 0 | 0 | 0 | 5 | 45052128 | |
sakila | film_actor | 40006972368 | 165226 | 40006972368 | 0 | 0 | 0 | 0 | 0 | 0 | 17 | 327680 | 5878761504 | 0 | 0 | 0 | 5 | 44617056 | |
sakila | address | 3718494912 | 155 | 3718494912 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 3795668448 | 0 | 0 | 0 | 5 | 38633760 | |
sakila | actor | 3690961296 | 225 | 3690961296 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 3600706560 | 0 | 0 | 0 | 5 | 55087824 | |
sakila | category | 3550985328 | 5135 | 3550985328 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 641869008 | 0 | 0 | 0 | 5 | 22348656 | |
sakila | customer | 3463014720 | 78 | 3463014720 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 212992 | 3600935184 | 0 | 0 | 0 | 5 | 44052096 | |
sakila | language | 3034435536 | 282 | 3034435536 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 940879104 | 0 | 0 | 0 | 5 | 80280816 | |
INFS1200_RELEASE | Policy | 2528253552 | 262 | 1910918064 | 48 | 617335488 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 588037824 | 10 | 115350323088 | |
products,sql | products | 2327158944 | 1331 | 2327158944 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
products,sql | suppliers | 1962130896 | 657 | 1962130896 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
products,sql | customers | 1952648544 | 1512 | 1952648544 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | city | 1691752128 | 137 | 1691752128 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1130088432 | 0 | 0 | 0 | 5 | 67163712 | |
INFS1200_RELEASE | Vehicle | 1658586864 | 306 | 1362184560 | 33 | 296402304 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 663204960 | 9 | 62359062480 | |
sys | sys_config | 1622016000 | 19 | 1622016000 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 802476048 | 0 | 0 | 0 | 5 | 721403760 | |
products,sql | shippers | 1573281600 | 225 | 1573281600 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
INFS1200_RELEASE | Customer | 1521610464 | 176 | 1242906192 | 14 | 278704272 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 5608119792 | 9 | 86798985504 | |
products | suppliers | 1432813008 | 414 | 1432813008 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 265047024 | 6 | 41525411136 | |
products,sql | employees | 1355971584 | 304 | 1355971584 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
products,sql | categories | 1279546224 | 268 | 1279546224 | 0 | 0 | 0 | 0 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
products | customers | 1191123120 | 767 | 1191123120 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 145296096 | 7 | 58733998224 | |
sakila | country | 1165773312 | 112 | 1165773312 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 833771664 | 0 | 0 | 0 | 5 | 41806512 | |
sakila | inventory | 1145789568 | 29 | 1145789568 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 2850387408 | 0 | 0 | 0 | 5 | 60572688 | |
products | categories | 1128794304 | 220 | 1128794304 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 243911184 | 6 | 40433255808 | |
products | shippers | 1076717136 | 164 | 1076717136 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 202952112 | 6 | 46783660176 |
|