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 | 48132 | 141.23 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | rental | idx_fk_inventory_id | 61875 | 26.83 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | inventory | idx_fk_film_id | 16743 | 8.98 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film_actor | idx_fk_film_id | 2 | 4.62 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | PRIMARY | 3000 | 3.18 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
vedettfak | megye | PRIMARY | 50 | 2.28 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | language | PRIMARY | 126 | 1.76 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | PRIMARY | 26 | 1.38 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film_category | fk_film_category_category | 3048 | 1.05 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | idx_fk_address_id | 1 | 967.91 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
test19 | ecurie | PRIMARY | 20 | 923.48 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | country | PRIMARY | 26 | 872.85 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | actor | idx_actor_last_name | 3 | 803.60 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sys | sys_config | PRIMARY | 10 | 770.65 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | idx_fk_city_id | 1 | 416.57 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | rental | idx_fk_staff_id | 1 | 407.37 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film_text | PRIMARY | 1 | 359.25 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | PRIMARY | 26 | 197.48 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
vedettfak | fa | megyeid | 7 | 195.71 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | idx_fk_language_id | 5 | 95.92 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | idx_fk_country_id | 1 | 67.52 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | customer | idx_fk_store_id | 1 | 64.25 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
test19 | voiture | Id_ecurie | 1 | 40.32 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
test19 | pilote | PRIMARY | 4 | 36.67 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
world | CountryLanguage | PRIMARY | 1 | 34.53 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
|