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 | language | 2453075856 | 685 | 2453075856 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 435707184 | 0 | 0 | 0 | 5 | 40367184 | |
sakila | film | 2330445216 | 589 | 2330445216 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 311296 | 5484530304 | 0 | 0 | 0 | 5 | 65778240 | |
sakila | film_actor | 2105411088 | 8 | 2105411088 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 163840 | 1734507984 | 0 | 0 | 0 | 5 | 44413248 | |
UniversityDB | assignment | 1600330512 | 0 | 0 | 22 | 1600330512 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 290242128 | 6 | 56635060944 | |
UniversityDB | enrolment | 1454189616 | 0 | 0 | 17 | 1454189616 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 6068278656 | 8 | 109404236304 | |
UniversityDB | tutors | 1444519296 | 0 | 0 | 17 | 1444519296 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 226701024 | 7 | 92102024256 | |
vedettfak | megye | 1370086080 | 12 | 1370086080 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 373679328 | 0 | 0 | 0 | 5 | 832082064 | |
sakila | actor | 1353849552 | 400 | 1353849552 | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 114688 | 734971776 | 0 | 0 | 0 | 5 | 34283568 | |
HospitalDB | treatment | 1215060000 | 0 | 0 | 15 | 1215060000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 124744752 | 8 | 97243218864 | |
UniversityDB | student | 1081690896 | 0 | 0 | 11 | 1081690896 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 11 | 278528 | 290197776 | 9 | 78511076160 | |
sakila | city | 1030756848 | 25 | 1030756848 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 147456 | 745741920 | 0 | 0 | 0 | 5 | 43661904 | |
HospitalDB | patient | 941681664 | 0 | 0 | 18 | 941681664 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 12 | 294912 | 249403440 | 9 | 83197895088 | |
sakila | address | 935240592 | 26 | 935240592 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 196608 | 1091377584 | 0 | 0 | 0 | 5 | 40492320 | |
UniversityDB | examination | 892042800 | 0 | 0 | 6 | 892042800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 5900543616 | 6 | 56856336240 | |
HospitalDB | nurse | 731034480 | 0 | 0 | 12 | 731034480 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 262144 | 296551728 | 8 | 76944376080 | |
HospitalDB | prescription | 724408080 | 0 | 0 | 13 | 724408080 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 245760 | 240602736 | 9 | 90470045424 | |
UniversityDB | quota | 693050160 | 0 | 0 | 3 | 693050160 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 158323440 | 6 | 47373778320 | |
HospitalDB | drug | 661882848 | 0 | 0 | 12 | 661882848 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 212992 | 263890176 | 7 | 72800878656 | |
UniversityDB | assignment_includes | 591119760 | 0 | 0 | 2 | 591119760 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 374834064 | 7 | 82872127008 | |
HospitalDB | ward | 441364176 | 0 | 0 | 5 | 441364176 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 302096784 | 7 | 53239278048 | |
HospitalDB | consists_of | 380035920 | 0 | 0 | 8 | 380035920 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 114739152 | 7 | 63990624720 | |
UniversityDB | staff | 368089392 | 0 | 0 | 8 | 368089392 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 283801056 | 7 | 74612166288 | |
HospitalDB | doctor | 362081280 | 0 | 0 | 11 | 362081280 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 362807808 | 7 | 45281517072 | |
UniversityDB | telephone_tutored_by | 346305696 | 0 | 0 | 5 | 346305696 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 222588960 | 7 | 57515872656 | |
HospitalDB | supervises | 326833056 | 0 | 0 | 7 | 326833056 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 229376 | 115369056 | 7 | 89845525440 |
|