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 | language | PRIMARY | 186 | 1.74 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | customer | PRIMARY | 25 | 1.33 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
real_estate_db | users | PRIMARY | 82 | 1.15 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sku | Attore | PRIMARY | 1 | 1.12 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | country | PRIMARY | 328 | 1.07 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | PRIMARY | 25 | 876.18 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film_text | PRIMARY | 1 | 356.60 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | idx_fk_language_id | 14 | 264.30 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | payment | idx_fk_staff_id | 8 | 190.87 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | PRIMARY | 25 | 180.85 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | idx_fk_country_id | 7 | 139.47 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | idx_fk_city_id | 1 | 47.94 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | category | PRIMARY | 1 | 14.53 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Table_insertion | ecurie | PRIMARY | 1 | 9.98 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | index_column_usage | index_id_2 | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | index_column_usage | index_id | 0 | 0 ps | 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 | |
mysql | columns | table_id_2 | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | foreign_key_column_usage | column_id | 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 | |
performance_schema | table_io_waits_summary_by_index_usage | OBJECT | 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 |
|