Skip to content

Instantly share code, notes, and snippets.

@narendranathjoshi

narendranathjoshi/count_rows_in_all_tables.sql

Created April 9, 2020 02:19
Show Gist options
  • Save narendranathjoshi/a63bd456f991e52ea51c674b6d0adac4 to your computer and use it in GitHub Desktop.
Save narendranathjoshi/a63bd456f991e52ea51c674b6d0adac4 to your computer and use it in GitHub Desktop.
Download ZIP
Count Rows in All Tables in PostgreSQL
Raw
count_rows_in_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