Cheat Sheet logoCheat Sheet Today
PostgreSQL Administration Cheat Sheet/Show table and indexes size

Measure one relation including indexes and TOAST.

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

Show table and indexes size

sql
sql
SELECT pg_size_pretty(pg_total_relation_size('public.users'));
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 database size
Measure one database's size.
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