Skip to content

Instantly share code, notes, and snippets.

@bdelespierre
Created August 29, 2018 14:01
Show Gist options
  • Save bdelespierre/a6d592482134248fbf9aef19a1ae4866 to your computer and use it in GitHub Desktop.
Save bdelespierre/a6d592482134248fbf9aef19a1ae4866 to your computer and use it in GitHub Desktop.
SELECT
nspname AS schemaname,relname,reltuples
FROM pg_class C
LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
WHERE
nspname NOT IN ('pg_catalog', 'information_schema') AND
relkind='r'
ORDER BY reltuples DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment