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 | film_category | PRIMARY | 330000 | 295.96 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | PRIMARY | 308177 | 157.06 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film_actor | PRIMARY | 330400 | 56.75 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | idx_fk_language_id | 255 | 5.82 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | category | PRIMARY | 10298 | 5.57 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
vedettfak | fa | megyeid | 2 | 4.38 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Table_insertion | ecurie | PRIMARY | 20 | 4.31 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | language | PRIMARY | 777 | 3.17 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
vedettfak | megye | PRIMARY | 82 | 3.11 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | PRIMARY | 25 | 3.11 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Table_insertion | voiture | Id_ecurie | 2 | 2.47 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | PRIMARY | 2 | 2.16 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | actor | idx_actor_last_name | 200 | 1.48 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film_actor | idx_fk_film_id | 5 | 1.19 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film_text | PRIMARY | 1 | 329.28 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | actor | PRIMARY | 25 | 254.84 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Stefano | vulcano | PRIMARY | 13 | 226.36 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | idx_fk_city_id | 1 | 55.04 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | idx_fk_store_id | 1 | 43.34 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | country | PRIMARY | 1 | 14.43 us | 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 | 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 | |
performance_schema | events_statements_summary_by_user_by_event_name | USER | 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 |
|