SELECT * FROM `x$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 | language | PRIMARY | 151 | 1965738192 | 0 | 0 | 0 | 0 | 0 | 0 | |
vedettfak | megye | PRIMARY | 38 | 1961898048 | 0 | 0 | 0 | 0 | 0 | 0 | |
vedettfak | fa | megyeid | 2 | 1408928400 | 0 | 0 | 0 | 0 | 0 | 0 | |
sys | sys_config | PRIMARY | 1 | 1176647472 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | PRIMARY | 724 | 1085986704 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 4 | 984178800 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 77 | 516746208 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 50 | 332342208 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | idx_fk_language_id | 6 | 112573824 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_address_id | 600 | 83516928 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 3 | 81515808 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | idx_fk_store_id | 3 | 62628720 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | index_column_usage | index_id_2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | index_column_usage | index_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | foreign_keys | referenced_table_catalog | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | foreign_keys | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | foreign_key_column_usage | column_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | columns | table_id_2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | columns | table_id | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | columns | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | column_type_elements | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
obaidlab8 | Employee | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | check_constraints | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | tablespaces | PRIMARY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
mysql | tablespace_files | file_name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
|