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 | 291.95 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | PRIMARY | 309152 | 153.50 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film_actor | PRIMARY | 330400 | 56.94 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | payment | fk_payment_rental | 16044 | 52.83 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | rental | idx_fk_inventory_id | 20625 | 16.57 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Table_insertion | pilote | PRIMARY | 14 | 8.86 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | category | PRIMARY | 10270 | 4.88 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | inventory | idx_fk_film_id | 5581 | 4.42 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Stefano | vulcano | PRIMARY | 4 | 4.38 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
test19 | ecurie | PRIMARY | 6 | 4.13 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | country | PRIMARY | 29 | 2.91 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Table_insertion | voiture | Id_ecurie | 8 | 2.38 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
test19 | voiture | Id_ecurie | 4 | 2.00 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film_category | fk_film_category_category | 1016 | 1.77 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | PRIMARY | 76 | 1.49 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sku | Attore | PRIMARY | 2 | 1.15 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
Table_insertion | ecurie | PRIMARY | 28 | 1.06 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sys | sys_config | PRIMARY | 1 | 861.53 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
test19 | pilote | PRIMARY | 2 | 798.62 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | PRIMARY | 28 | 188.46 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | idx_fk_city_id | 4 | 96.39 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | idx_fk_store_id | 1 | 65.40 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | customer | idx_fk_address_id | 1 | 38.47 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
world | City | PRIMARY | 1 | 32.85 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
world | Country | PRIMARY | 2 | 27.90 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps |
|