top of page
Волнистый абстрактный фон
CerebroSQL

PostgreSQL: table and index size

The OBJECT SIZE node will show the size of the selected table and all its indexes in sum

​

PostgreSQL table size

select pg_size_pretty(pg_indexes_size($$TABLEOID::oid)) "IndexSize",
      pg_size_pretty(pg_table_size($$TABLEOID::oid)) "TableSize"

bottom of page