List tables by the number of rows in Redshift

This query returns list of tables in a database with their number of rows.


select tab.table_schema,
       tinf.tbl_rows as rows
from svv_tables tab
join svv_table_info tinf
          on tab.table_schema = tinf.schema
          and tab.table_name = tinf.table
where tab.table_type = 'BASE TABLE'
      and tab.table_schema not in('pg_catalog','information_schema')
      and tinf.tbl_rows > 1
order by tinf.tbl_rows desc;


  • table_schema - schema name
  • table_name - table name
  • rows - number of rows in a table


  • One row represents one table
  • Scope of rows: all tables in a database having more than one row
  • Ordered by number of rows descending, from largest to smallest (in terms of number of rows)

Sample results

There are no comments. Click here to write the first comment.