How to get sizes of PostgreSQL databases, tables, and indexes with psql commands

Joe supports a number of psql meta-commands (slash or backslash commands, e.g. \d). Such commands could be used to get the size of database objects (tables, indexes, etc.).

You can use meta-commands to get the size:

• \dt+ – list tables;
• \l+ - list databases;
• \di+ – list indexes;
• \dv+ – list views;
• \dm+ – list materialized views;
• other supported psql meta-commands are listed here.

Web UI

Slack