ANALYZE;
WITH ranking_by_number_of_rows AS (SELECT n.nspname AS schema_name, c.relname AS table_name, c.reltuples AS number_of_rows, Dense_rank() OVER (ORDER BY reltuples DESC) AS rank
FROM pg_catalog.pg_class c
INNER JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
INNER JOIN pg_catalog.pg_authid u ON u.oid = c.relowner
WHERE c.relkind IN ('r')AND n.nspname NOT IN ('pg_catalog', 'pg_toast')
AND (n.nspname = 'public' OR u.rolname <> 'postgres'))
SELECT schema_name, table_name, number_of_rows, rank
FROM ranking_by_number_of_rows 
WHERE rank<=5
ORDER BY number_of_rows DESC, schema_name, table_name;