Skip to content

Instantly share code, notes, and snippets.

@alt-odoo

alt-odoo/query.sql

Created April 23, 2021 07:58
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save alt-odoo/b019db08b9dfff37c426a5745b76a847 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save alt-odoo/b019db08b9dfff37c426a5745b76a847 to your computer and use it in GitHub Desktop.
Download ZIP
Find big tables in Postgres
Raw
query.sql
SELECT schemaname||'.'||tablename as table,
pg_size_pretty (pg_total_relation_size(schemaname||'.'||tablename)) as size
from pg_tables
order by pg_total_relation_size(schemaname||'.'||tablename) desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment