Skip to content

Instantly share code, notes, and snippets.

@jdecode

jdecode/postgres-estimated-row-count-of-all-tables.sql

Created April 25, 2021 13:48
Show Gist options
  • Save jdecode/ab0c84b402a8bdf58b4a739645c4b263 to your computer and use it in GitHub Desktop.
Save jdecode/ab0c84b402a8bdf58b4a739645c4b263 to your computer and use it in GitHub Desktop.
Download ZIP
Show estimated row count of all tables in Postgres
Raw
postgres-estimated-row-count-of-all-tables.sql
SELECT schemaname,relname,n_live_tup
FROM pg_stat_user_tables
ORDER BY n_live_tup DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment