Skip to content

Instantly share code, notes, and snippets.

@dac73

dac73/postgres.sql

Last active March 14, 2019 10:35
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dac73/9f54dd1b075b30254c70e9a2f6ab8438 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dac73/9f54dd1b075b30254c70e9a2f6ab8438 to your computer and use it in GitHub Desktop.
Download ZIP
Postgres
Raw
postgres.sql
-- table sizes real/sys
SELECT
relname as "Table",
pg_size_pretty(pg_total_relation_size(relid)) As "Size",
pg_size_pretty(pg_total_relation_size(relid) - pg_relation_size(relid)) as "External Size"
FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;
-- more details on size
SELECT
relname as "Table",
pg_size_pretty(pg_total_relation_size(relid)) As "Table+Index",
pg_size_pretty(pg_total_relation_size(relid) - pg_table_size(relid)) as "IndexSize", pg_size_pretty(pg_table_size(relid)) as "Table size"
FROM pg_catalog.pg_statio_user_tables ORDER BY pg_total_relation_size(relid) DESC;
-- DB size
select pg_size_pretty( pg_database_size('DB-NAME'));
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment