/* Count of sequential scans by table descending by order */

SELECT

relname AS name,
seq_scan as count

FROM

pg_stat_user_tables

ORDER BY

seq_scan DESC;