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 | language | PRIMARY | 856 | 3.43 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | address | PRIMARY | 56 | 1.76 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | country | PRIMARY | 102 | 1.68 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film | idx_fk_language_id | 58 | 1.56 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | rental | idx_fk_staff_id | 1 | 1.27 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | PRIMARY | 25 | 1.05 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
pia_2024_v1 | korisnici | PRIMARY | 195 | 1.05 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
pia_2024_v1 | sale | PRIMARY | 101 | 1.03 ms | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
pia_2024_v1 | prijave | aktivnost | 41 | 621.12 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
pia_2024_v1 | aktivnosti | fk-korisnici | 52 | 484.76 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | actor | idx_actor_last_name | 211 | 400.57 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | customer | PRIMARY | 25 | 266.57 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
pia_2024_v1 | aktivnosti | PRIMARY | 28 | 232.27 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | city | idx_fk_country_id | 4 | 107.61 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
pia_2024_v1 | prijave | sala | 30 | 97.55 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | customer | idx_fk_store_id | 2 | 80.18 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | payment | idx_fk_staff_id | 1 | 73.15 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | film_actor | idx_fk_film_id | 2 | 71.87 us | 0 | 0 ps | 0 | 0 ps | 0 | 0 ps | |
sakila | staff | idx_fk_store_id | 3 | 71.86 us | 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 | foreign_keys | referenced_table_catalog | 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 |
|