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 | |
---|---|---|---|---|---|---|---|---|---|---|---|
Table_insertion | pilote | PRIMARY | 2 | 3.96 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sys | sys_config | PRIMARY | 2 | 3.69 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Table_insertion | ecurie | PRIMARY | 2 | 3.04 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
vedettfak | megye | PRIMARY | 4 | 821.38 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | actor | idx_actor_last_name | 2 | 673.85 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | country | PRIMARY | 26 | 217.14 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | idx_fk_country_id | 1 | 60.37 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Stefano | vulcano | PRIMARY | 1 | 7.13 us | 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 | 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 | foreign_keys | schema_id | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | foreign_keys | PRIMARY | 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 | foreign_key_column_usage | foreign_key_id | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | columns | collation_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 | |
mysql | check_constraints | schema_id | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
mysql | check_constraints | 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 | |
mysql | schemata | default_collation_id | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
|