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 | customer | idx_fk_store_id | 7 | 2.63 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | PRIMARY | 75 | 2.08 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | idx_fk_language_id | 8 | 1.94 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | PRIMARY | 100 | 1.76 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | language | PRIMARY | 125 | 1.70 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | country | PRIMARY | 61 | 1.70 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | PRIMARY | 50 | 1.46 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sys | sys_config | PRIMARY | 3 | 986.02 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | actor | idx_actor_last_name | 5 | 790.47 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | customer | PRIMARY | 100 | 764.45 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | idx_fk_city_id | 56 | 528.86 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | customer | idx_fk_address_id | 27 | 450.74 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | rental | idx_fk_staff_id | 5 | 443.13 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | idx_fk_country_id | 38 | 433.45 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
db_carrental_dini | tbl_mobil | PRIMARY | 8 | 129.31 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | payment | idx_fk_staff_id | 2 | 50.58 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
world | City | PRIMARY | 2 | 47.38 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
db_carrental_dini | tbl_pelanggan | PRIMARY | 2 | 28.64 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 |
|