Guest User

Untitled

a guest
Jan 21st, 2018
74
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.36 KB | None | 0 0
  1. SELECT nspname || '.' || C.relname AS "relation",
  2. pg_size_pretty(pg_relation_size(C.oid)) AS "size",
  3. T.relname AS "toastrel"
  4. FROM pg_class C
  5. LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace)
  6. LEFT JOIN pg_class T ON (T.reltoastrelid=C.oid)
  7. WHERE nspname NOT IN ('pg_catalog', 'information_schema')
  8. ORDER BY pg_relation_size(C.oid) DESC
  9. LIMIT 20;
Add Comment
Please, Sign In to add comment