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 | |
sakila | city | 75 | 1.02 ms | |
DBMS | Sales | 70 | 439.53 us | |
ventas | ventas | 64 | 77.90 us | |
sakila | film_text | 50 | 331.91 us | |
sakila | film | 50 | 205.70 us | |
sqlpractice | Sales | 40 | 614.62 us | |
Libro | books | 40 | 587.02 us | |
sql | Sales | 35 | 552.95 us | |
sqlpractice | Products | 30 | 183.01 us | |
sakila | film_category | 27 | 73.14 us | |
sakila | rental | 25 | 4.35 ms | |
sakila | customer | 25 | 1.13 ms | |
sakila | address | 25 | 53.45 us | |
test19 | pilote | 25 | 18.79 us | |
sakila | actor | 25 | 2.33 ms | |
Yeshwanth | Sales | 25 | 270.10 us | |
Libro | author | 21 | 127.34 us | |
sql | Products | 15 | 357.95 us | |
Yeshwanth | Products | 10 | 462.73 us | |
Libro | book_review | 6 | 331.24 us | |
DBMS | Products | 5 | 95.23 us | |
midad1 | employees | 2 | 64.83 us | |
sakila | store | 2 | 3.89 ms |
|