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 | 5.51 ms | 1793 | 5.51 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 16 | 304.00 KiB | 8.56 ms | 0 | 0 bytes | 0 ps | 5 | 29.72 us | |
sakila | payment | 4.83 ms | 35 | 4.83 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 50 | 848.00 KiB | 8.77 ms | 0 | 0 bytes | 0 ps | 5 | 47.52 us | |
TlapaleriaMalfoy | Registro | 4.40 ms | 2 | 4.40 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 4.26 ms | 0 | 0 bytes | 0 ps | 5 | 50.61 us | |
sakila | address | 4.19 ms | 26 | 4.19 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 5.33 ms | 0 | 0 bytes | 0 ps | 5 | 47.13 us | |
sakila | film_actor | 2.77 ms | 50 | 2.77 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 17 | 320.00 KiB | 4.82 ms | 0 | 0 bytes | 0 ps | 5 | 38.70 us | |
sakila | rental | 2.58 ms | 600 | 2.58 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 53 | 896.00 KiB | 7.95 ms | 0 | 0 bytes | 0 ps | 5 | 89.39 us | |
vedettfak | megye | 2.54 ms | 6 | 2.54 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 2.73 ms | 0 | 0 bytes | 0 ps | 5 | 35.26 us | |
sakila | customer | 2.26 ms | 625 | 2.26 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 9 | 192.00 KiB | 2.76 ms | 0 | 0 bytes | 0 ps | 5 | 52.75 us | |
sakila | language | 1.89 ms | 342 | 1.89 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 817.70 us | 0 | 0 bytes | 0 ps | 5 | 34.04 us | |
sakila | actor | 1.69 ms | 1711 | 1.69 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 944.06 us | 0 | 0 bytes | 0 ps | 5 | 32.69 us | |
sakila | city | 1.57 ms | 51 | 1.57 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 7 | 160.00 KiB | 1.48 ms | 0 | 0 bytes | 0 ps | 5 | 61.25 us | |
sakila | staff | 1.39 ms | 49 | 1.39 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 5 | 128.00 KiB | 1.20 ms | 0 | 0 bytes | 0 ps | 5 | 37.33 us | |
sakila | country | 1.22 ms | 25 | 1.22 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 4 | 112.00 KiB | 1.12 ms | 0 | 0 bytes | 0 ps | 5 | 61.28 us | |
sakila | film_text | 693.54 us | 26 | 693.54 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 52 | 3.33 KiB | 630.87 us | 0 | 0 bytes | 0 ps | 32 | 32.41 us | |
resume_Sanket | Admin | 141.56 us | 3 | 108.15 us | 1 | 33.41 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 10 | 256.00 KiB | 669.90 us | 8 | 106.90 ms | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 115.43 us | 31 | 115.43 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 | |
mysql | foreign_keys | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|