Skip to content

Instantly share code, notes, and snippets.

@bdelespierre

bdelespierre/postgresql_table_rowcount.sql

Created August 29, 2018 14:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bdelespierre/a6d592482134248fbf9aef19a1ae4866 to your computer and use it in GitHub Desktop.
Save bdelespierre/a6d592482134248fbf9aef19a1ae4866 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgresql_table_rowcount.sql
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