Jan-Lukas Else

Software Developer & Blogger

PostgreSQL

Upgrades

Useful commands

  • Size of database:
SELECT pg_size_pretty(pg_database_size('dbname'));
  • Size of table in current database:
SELECT pg_size_pretty(pg_total_relation_size('tablename'));
Jan-Lukas Else