SELECT * FROM `schema_tables_with_full_table_scans`
|
object_schema | object_name | rows_full_scanned | latency | |
---|---|---|---|---|
sakila | category | 118 | 931.23 us | |
sakila | country | 75 | 1.08 ms | |
DBMS | Sales | 70 | 439.53 us | |
ventas | ventas | 64 | 77.90 us | |
sakila | city | 50 | 993.04 us | |
sakila | film_text | 50 | 331.91 us | |
sqlpractice | Sales | 30 | 551.41 us | |
Libro | books | 30 | 575.85 us | |
sakila | film_category | 27 | 73.14 us | |
sqlpractice | Products | 25 | 152.89 us | |
sakila | customer | 25 | 1.13 ms | |
sakila | address | 25 | 53.45 us | |
sakila | film | 25 | 105.69 us | |
test19 | pilote | 25 | 18.79 us | |
sql | Sales | 25 | 515.94 us | |
sakila | actor | 25 | 2.33 ms | |
Yeshwanth | Sales | 25 | 270.10 us | |
Libro | author | 15 | 113.92 us | |
sql | Products | 15 | 357.95 us | |
Yeshwanth | Products | 5 | 440.23 us | |
DBMS | Products | 5 | 95.23 us | |
midad1 | employees | 2 | 64.83 us | |
sakila | store | 2 | 3.89 ms | |
sakila | staff | 2 | 2.42 ms | |
world | City | 1 | 361.33 us |
|