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 | |
---|---|---|---|---|---|---|---|---|---|---|---|
test19 | voiture | Id_ecurie | 2 | 2.38 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | country | PRIMARY | 105 | 2.11 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | customer | idx_fk_store_id | 1 | 1.88 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | language | PRIMARY | 226 | 1.69 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
vedettfak | fa | megyeid | 1 | 1.16 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | rental | idx_fk_staff_id | 2 | 865.29 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
vedettfak | megye | PRIMARY | 2 | 756.50 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
world | Country | PRIMARY | 2 | 671.45 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | inventory | idx_fk_film_id | 1 | 668.96 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | PRIMARY | 32 | 331.11 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | PRIMARY | 108 | 326.51 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | actor | idx_actor_last_name | 13 | 210.54 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | idx_fk_language_id | 12 | 179.80 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | idx_fk_country_id | 8 | 140.51 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film_category | fk_film_category_category | 84 | 130.48 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | idx_fk_address_id | 2 | 68.94 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | store | idx_unique_manager | 1 | 68.53 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
world | City | PRIMARY | 6 | 65.47 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | idx_fk_store_id | 1 | 61.75 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | PRIMARY | 2 | 16.41 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | PRIMARY | 3 | 10.26 us | 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 | tablespaces | 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 |
|