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 | film_category | 416.99 ms | 495000 | 416.99 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 820.91 us | 0 | 0 bytes | 0 ps | 5 | 20.40 us | |
sakila | film | 234.86 ms | 462254 | 234.86 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 14.24 ms | 0 | 0 bytes | 0 ps | 5 | 35.64 us | |
sakila | payment | 148.10 ms | 32105 | 148.10 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 67 | 1.09 MiB | 41.52 ms | 0 | 0 bytes | 0 ps | 5 | 36.60 us | |
sakila | film_actor | 80.70 ms | 495607 | 80.70 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 17 | 320.00 KiB | 1.83 ms | 0 | 0 bytes | 0 ps | 5 | 33.58 us | |
sakila | rental | 34.40 ms | 41291 | 34.40 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 70 | 1.14 MiB | 18.20 ms | 0 | 0 bytes | 0 ps | 5 | 173.30 us | |
sakila | inventory | 10.14 ms | 9175 | 10.14 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 14 | 272.00 KiB | 7.80 ms | 0 | 0 bytes | 0 ps | 5 | 120.39 us | |
sakila | category | 8.01 ms | 15410 | 8.01 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 729.43 us | 0 | 0 bytes | 0 ps | 5 | 18.08 us | |
sakila | customer | 5.24 ms | 1276 | 5.24 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 10 | 208.00 KiB | 3.89 ms | 0 | 0 bytes | 0 ps | 5 | 38.65 us | |
sakila | address | 4.09 ms | 2665 | 4.09 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 3.29 ms | 0 | 0 bytes | 0 ps | 5 | 58.29 us | |
sakila | staff | 3.59 ms | 55 | 3.59 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 2.01 ms | 0 | 0 bytes | 0 ps | 5 | 47.61 us | |
sakila | city | 2.56 ms | 1487 | 2.56 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.68 ms | 0 | 0 bytes | 0 ps | 5 | 181.86 us | |
sakila | store | 1.98 ms | 23 | 1.98 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.74 ms | 0 | 0 bytes | 0 ps | 5 | 97.25 us | |
test19 | voiture | 1.69 ms | 7 | 1.69 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.55 ms | 0 | 0 bytes | 0 ps | 5 | 105.18 us | |
vedettfak | fa | 1.54 ms | 12 | 1.54 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.53 ms | 0 | 0 bytes | 0 ps | 5 | 41.59 us | |
sakila | country | 1.38 ms | 340 | 1.38 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.06 ms | 0 | 0 bytes | 0 ps | 5 | 55.55 us | |
sakila | actor | 1.16 ms | 603 | 1.16 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 982.36 us | 0 | 0 bytes | 0 ps | 5 | 30.82 us | |
world | Country | 1.14 ms | 30 | 1.14 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 17 | 4.27 KiB | 1.20 ms | 0 | 0 bytes | 0 ps | 12 | 14.88 ms | |
sakila | language | 920.00 us | 30 | 920.00 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 818.64 us | 0 | 0 bytes | 0 ps | 5 | 41.54 us | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 907.73 us | 54 | 907.73 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sku | Attore | 863.80 us | 14 | 863.80 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 731.45 us | 0 | 0 bytes | 0 ps | 5 | 42.75 us | |
world | City | 693.96 us | 9 | 693.96 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 6 | 660 bytes | 824.50 us | 0 | 0 bytes | 0 ps | 8 | 63.41 us | |
world | CountryLanguage | 689.50 us | 2 | 689.50 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 3 | 446 bytes | 2.98 ms | 0 | 0 bytes | 0 ps | 6 | 43.97 us | |
sakila | film_text | 648.35 us | 6 | 648.35 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 811 bytes | 1.18 ms | 0 | 0 bytes | 0 ps | 12 | 77.31 us | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 18.78 us | 1 | 18.78 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
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 |
|