Skip to content

Instantly share code, notes, and snippets.

@WillCQ97

WillCQ97/tamanho-do-banco.sql

Created May 6, 2024 11:56
Show Gist options
  • Save WillCQ97/3053c72c426c0210d7d108a24735d39e to your computer and use it in GitHub Desktop.
Save WillCQ97/3053c72c426c0210d7d108a24735d39e to your computer and use it in GitHub Desktop.
Download ZIP
Visualizar o tamanho de um banco postgres
Raw
tamanho-do-banco.sql
SELECT
'TOTAL' AS banco,
sum(pg_database_size(datname)) AS tamanho,
pg_size_pretty(sum(pg_database_size(datname))) AS tamanho_bonito
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