SELECT * FROM `schema_tables_with_full_table_scans`
|
object_schema | object_name | rows_full_scanned | latency | |
---|---|---|---|---|
sakila | payment | 16049 | 17.47 ms | |
sakila | rental | 16044 | 11.96 ms | |
sakila | film_actor | 5462 | 1.68 ms | |
sakila | inventory | 4581 | 1.25 ms | |
world | City | 4079 | 6.13 ms | |
vedettfak | fa | 1258 | 3.31 ms | |
sakila | film | 1125 | 6.78 ms | |
sakila | film_text | 1000 | 2.15 ms | |
sakila | film_category | 1000 | 302.81 us | |
world | CountryLanguage | 984 | 936.07 us | |
sakila | city | 675 | 343.04 us | |
sakila | address | 653 | 4.99 ms | |
sakila | customer | 649 | 1.77 ms | |
sakila | actor | 275 | 951.97 us | |
world | Country | 239 | 855.79 us | |
sakila | country | 185 | 876.70 us | |
ОБЛІК ТЕЛЕФОННИХ ПЕРЕГОВОРІВ | Кількість дзвінків кожного абонента | 54 | 2.57 ms | |
test19 | pilote | 30 | 655.52 us | |
Table_insertion | pilote | 30 | 18.34 us | |
vedettfak | megye | 26 | 75.97 us | |
sakila | category | 16 | 24.76 us | |
Table_insertion | voiture | 14 | 20.50 us | |
test19 | voiture | 14 | 635.82 us | |
sakila | language | 12 | 34.40 us | |
Stefano | vulcano | 4 | 970.10 us |
|