Skip to content

Instantly share code, notes, and snippets.

@anozimada

anozimada/pg-tablesize.sql

Last active September 26, 2017 03:04
Show Gist options
  • Save anozimada/51d0a11de452bef53acda5a98385c595 to your computer and use it in GitHub Desktop.
Save anozimada/51d0a11de452bef53acda5a98385c595 to your computer and use it in GitHub Desktop.
Download ZIP
Get table sizes from specific schema in Postgresql
Raw
pg-tablesize.sql
select table_name, pg_relation_size(quote_ident(table_name))
from information_schema.tables
where table_schema = 'adempiere'
order by 2 desc
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment