Skip to content

Instantly share code, notes, and snippets.

@chocobn69

chocobn69/gist:2317758cfc05218c82e59b3149978ada

Created March 2, 2017 15:40
Show Gist options
  • Save chocobn69/2317758cfc05218c82e59b3149978ada to your computer and use it in GitHub Desktop.
Save chocobn69/2317758cfc05218c82e59b3149978ada to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
select reltuples, relpages, pg_relation_size(oid),oid::regclass
from pg_class
where reltuples=0 and relpages > 0 and relkind = 'r'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment