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 | payment | 62.10 ms | 32114 | 62.10 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 67 | 1.09 MiB | 30.94 ms | 0 | 0 bytes | 0 ps | 5 | 54.21 us | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 19.41 ms | 54 | 19.41 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
sakila | rental | 18.66 ms | 41250 | 18.66 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 68 | 1.11 MiB | 28.32 ms | 0 | 0 bytes | 0 ps | 5 | 55.09 us | |
sakila | film | 7.19 ms | 8402 | 7.19 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 1.99 ms | 0 | 0 bytes | 0 ps | 5 | 34.91 us | |
sakila | inventory | 5.69 ms | 9168 | 5.69 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 23 | 416.00 KiB | 12.62 ms | 0 | 0 bytes | 0 ps | 5 | 51.11 us | |
TlapaleriaMalfoy | Registro | 4.71 ms | 2 | 4.71 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 4.41 ms | 0 | 0 bytes | 0 ps | 5 | 51.22 us | |
sakila | city | 1.78 ms | 135 | 1.78 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.17 ms | 0 | 0 bytes | 0 ps | 5 | 47.33 us | |
sakila | language | 1.77 ms | 175 | 1.77 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 807.19 us | 0 | 0 bytes | 0 ps | 5 | 45.29 us | |
sakila | country | 1.17 ms | 333 | 1.17 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 707.83 us | 0 | 0 bytes | 0 ps | 5 | 32.17 us | |
sakila | store | 1.13 ms | 13 | 1.13 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 2.74 ms | 0 | 0 bytes | 0 ps | 5 | 83.46 us | |
sakila | actor | 941.04 us | 404 | 941.04 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.46 ms | 0 | 0 bytes | 0 ps | 5 | 45.06 us | |
sakila | address | 577.70 us | 58 | 577.70 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 2.39 ms | 0 | 0 bytes | 0 ps | 5 | 36.76 us | |
sakila | film_category | 545.94 us | 5 | 545.94 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 156.98 ms | 0 | 0 bytes | 0 ps | 5 | 65.76 us | |
sakila | staff | 296.32 us | 31 | 296.32 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 3.22 ms | 0 | 0 bytes | 0 ps | 5 | 94.55 us | |
sakila | customer | 266.16 us | 25 | 266.16 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 8 | 176.00 KiB | 1.91 ms | 0 | 0 bytes | 0 ps | 5 | 27.90 us | |
sakila | category | 30.58 us | 32 | 30.58 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.01 ms | 0 | 0 bytes | 0 ps | 5 | 24.23 us | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Тарифна сітка | 19.37 us | 1 | 19.37 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 | |
mysql | schemata | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespace_files | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | tablespaces | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | check_constraints | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | column_type_elements | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | columns | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | |
mysql | foreign_key_column_usage | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|