Get the Size of a Postgres Table’s Indexes

Here’s how to get the size of any PostgreSQL table’s indexes, as┬ástored on disk. We show how to get the size of a table’s indexes in an human-readable form like “2 MB”. We also show to easily get a table’s … Continue reading

Filed in | 2 Comments

Get the Size of a Postgres Table

Here’s how to get the size of any PostgreSQL table, as┬ástored on disk. We show how to get the table’s size in an human-readable form like “5 MB”. We also show to get a table’s size as just a raw … Continue reading

Filed in | Leave a comment

psql

psql is PostgreSQL’s command-line tool for working with Postgres databases. psql is always included with PostgreSQL database software installations, so if you’re working with Postgres, it’s very handy to know how to use it. These commands were tested with Postgres … Continue reading

Filed in | Leave a comment

Postgres SQL Tools

Common tools for working in SQL with Postgres are: psql – A command-line tool for access to PostgreSQL. psql is always installed with Postgres. pgAdmin – A graphical administration tool for Postgres, with versions for Mac, Linux and Windows. phpPgAdmin … Continue reading

Filed in | Leave a comment