Skip to main content

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.

Get object size / Web UI