Skip to content

Instantly share code, notes, and snippets.

@rdeavila

rdeavila/pgsql-size.sql

Last active February 7, 2024 09:26
Show Gist options
  • Star 13 You must be signed in to star a gist
  • Fork 3 You must be signed in to fork a gist
  • Save rdeavila/b4e35d3376820b992313 to your computer and use it in GitHub Desktop.
Save rdeavila/b4e35d3376820b992313 to your computer and use it in GitHub Desktop.
Download ZIP
PostgreSQL: Como ver o tamanho das bases de dados de um servidor
Raw
pgsql-size.sql
-- Para saber o tamanho de todas as bases de dados:
SELECT pg_database.datname, pg_size_pretty(pg_database_size(pg_database.datname)) AS size FROM pg_database;
@ffelixneto
Copy link

Tem também esse script que peguei aqui , que mostra os bancos excluindo os bancos padrão do sistema e a soma do tamanho das bases no servidor.

(SELECT
	datname                                   AS banco,
	pg_database_size(datname)                 AS tamanho,
	pg_size_pretty(pg_database_size(datname)) AS tamanho_pretty
FROM pg_database
WHERE datname NOT IN ('template0', 'template1', 'postgres')
ORDER BY tamanho DESC, banco ASC)

UNION ALL

(SELECT
	'TOTAL'                                        AS banco,
	sum(pg_database_size(datname))                 AS tamanho,
	pg_size_pretty(sum(pg_database_size(datname))) AS tamanho_pretty
FROM pg_database
WHERE datname NOT IN ('template0', 'template1', 'postgres'));

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment