Cheat Sheet logoCheat Sheet Today
PostgreSQL Administration Cheat Sheet/Show database size

Measure one database's size.

Back to sheetBrowse commands
Sign in to save
Section: Monitoring and Statistics

Show database size

sql
sql
SELECT pg_size_pretty(pg_database_size('appdb'));
Explanation

See summary for usage details.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Monitoring and Statistics
Show table and indexes size
Measure one relation including indexes and TOAST.
OpenIn sheetsqlsame section
Show active sessions
Inspect current sessions and queries.
OpenIn sheetsqlsame section
Cancel a query
Cancel a running query without terminating the session.
OpenIn sheetsqlsame section
Terminate session
Force a backend to disconnect.
OpenIn sheetsqlsame section
Inspect locks
Inspect lock acquisition and contention.
OpenIn sheetsqlsame section
Inspect bgwriter stats
Review checkpoint and buffer write statistics.
OpenIn sheetsqlsame section