CTE 2014-02-02 code postgresqlsql WITH busytables AS ( SELECT relname, (seq_scan + idx_scan) AS scans FROM pg_stat_user_tables ) SELECT relname, scans FROM busytables WHERE scans > 100 ORDER BY scans DESC;