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 | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
aeropuerto | Vuelo_Tripulante | 972.13 us | 0 | 0 ps | 20 | 972.13 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 8 | 224.00 KiB | 269.76 us | 7 | 109.38 ms | |
aeropuerto | Aerolineas | 592.89 us | 0 | 0 ps | 20 | 592.89 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 7 | 208.00 KiB | 349.66 us | 6 | 77.09 ms | |
rishabh | LOCATION | 548.23 us | 75 | 442.09 us | 5 | 106.14 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 7 | 208.00 KiB | 93.33 us | 6 | 51.31 ms | |
rishabh | ARTIST | 523.04 us | 100 | 345.25 us | 10 | 177.79 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 11 | 272.00 KiB | 168.07 us | 8 | 88.47 ms | |
rishabh | GALLERY | 460.46 us | 16 | 95.34 us | 10 | 365.12 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 8 | 224.00 KiB | 5.54 ms | 7 | 72.91 ms | |
rishabh | DRAWING | 383.20 us | 3 | 37.37 us | 50 | 345.83 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 8 | 224.00 KiB | 128.48 us | 7 | 86.67 ms | |
aeropuerto | Vuelo_Aerolinea | 275.67 us | 0 | 0 ps | 20 | 275.67 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 8 | 224.00 KiB | 187.35 us | 7 | 69.82 ms | |
aeropuerto | Reservas | 251.74 us | 0 | 0 ps | 20 | 251.74 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 9 | 240.00 KiB | 164.51 us | 9 | 109.35 ms | |
rishabh | GALLERY_DRAWING | 183.57 us | 0 | 0 ps | 10 | 183.57 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 8 | 224.00 KiB | 130.58 us | 7 | 82.49 ms | |
aeropuerto | Aviones | 176.58 us | 0 | 0 ps | 20 | 176.58 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 7 | 208.00 KiB | 173.45 us | 6 | 46.15 ms | |
aeropuerto | Vuelos | 150.26 us | 0 | 0 ps | 20 | 150.26 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 8 | 224.00 KiB | 145.64 us | 7 | 75.02 ms | |
aeropuerto | Pasajeros | 147.18 us | 0 | 0 ps | 20 | 147.18 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 8 | 224.00 KiB | 179.37 us | 7 | 51.81 ms | |
aeropuerto | Tripulantes | 89.77 us | 0 | 0 ps | 20 | 89.77 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 7 | 208.00 KiB | 105.84 us | 6 | 58.74 ms | |
loja | migrations | 21.00 us | 0 | 0 ps | 1 | 21.00 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 bytes | 0 ps | 7 | 208.00 KiB | 128.26 us | 6 | 65.65 ms | |
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 | |
mysql | index_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 | index_partitions | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |
|