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 | film | idx_fk_language_id | 404 | 3895874928 | 0 | 0 | 0 | 0 | 0 | 0 | |
vedettfak | megye | PRIMARY | 2 | 3793222752 | 0 | 0 | 0 | 0 | 0 | 0 | |
test19 | pilote | PRIMARY | 2 | 1429624944 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | PRIMARY | 29 | 1379979744 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | staff | PRIMARY | 27 | 1259100480 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | language | PRIMARY | 50 | 1234804560 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_category | fk_film_category_category | 93 | 1013285856 | 0 | 0 | 0 | 0 | 0 | 0 | |
sys | sys_config | PRIMARY | 14 | 983701488 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | country | PRIMARY | 80 | 604485552 | 0 | 0 | 0 | 0 | 0 | 0 | |
DBMS | Sales | PRIMARY | 37 | 553926384 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | category | PRIMARY | 104 | 446950416 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | address | idx_fk_city_id | 1 | 423722112 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | rental | idx_fk_staff_id | 1 | 419781120 | 0 | 0 | 0 | 0 | 0 | 0 | |
sqlpractice | Sales | PRIMARY | 22 | 391322976 | 0 | 0 | 0 | 0 | 0 | 0 | |
sql | Sales | PRIMARY | 17 | 252477984 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film_text | PRIMARY | 6 | 219127920 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | customer | PRIMARY | 25 | 204556176 | 0 | 0 | 0 | 0 | 0 | 0 | |
Yeshwanth | Sales | PRIMARY | 15 | 196061712 | 0 | 0 | 0 | 0 | 0 | 0 | |
sqlpractice | Products | PRIMARY | 14 | 192971328 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | PRIMARY | 25 | 191298624 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | film | PRIMARY | 25 | 156241008 | 0 | 0 | 0 | 0 | 0 | 0 | |
midad1 | employees | PRIMARY | 6 | 124305984 | 0 | 0 | 0 | 0 | 0 | 0 | |
Libro | author | PRIMARY | 7 | 105285312 | 0 | 0 | 0 | 0 | 0 | 0 | |
sakila | city | idx_fk_country_id | 3 | 101336928 | 0 | 0 | 0 | 0 | 0 | 0 | |
Libro | books | PRIMARY | 6 | 89889888 | 0 | 0 | 0 | 0 | 0 | 0 |
|