SELECT * FROM `schema_index_statistics`
|
table_schema | table_name | index_name | rows_selected | select_latency | rows_inserted | insert_latency | rows_updated | update_latency | rows_deleted | delete_latency | |
---|---|---|---|---|---|---|---|---|---|---|---|
sakila | payment | fk_payment_rental | 32088 | 88.04 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | rental | idx_fk_inventory_id | 41250 | 20.84 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | inventory | idx_fk_film_id | 11162 | 7.88 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | language | PRIMARY | 25 | 4.91 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | PRIMARY | 2000 | 3.62 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | country | PRIMARY | 52 | 2.64 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | PRIMARY | 4 | 1.43 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sys | sys_config | PRIMARY | 22 | 951.47 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film_category | fk_film_category_category | 2034 | 943.34 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | idx_fk_city_id | 1 | 447.30 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | PRIMARY | 25 | 141.93 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | idx_fk_country_id | 2 | 70.46 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
world | City | PRIMARY | 6 | 66.81 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | store | idx_unique_manager | 1 | 55.92 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | idx_fk_language_id | 1 | 55.55 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | PRIMARY | 2 | 45.71 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | idx_fk_store_id | 1 | 44.17 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sku | Attore | PRIMARY | 1 | 14.57 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | foreign_keys | referenced_table_catalog | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
performance_schema | table_io_waits_summary_by_index_usage | OBJECT | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | columns | table_id | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | columns | PRIMARY | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | column_type_elements | PRIMARY | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | tablespaces | PRIMARY | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | tablespace_files | file_name | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
|