Wintus
4/7/2017 - 1:47 AM

PostgreSQL Table Size Query

PostgreSQL Table Size Query

SELECT relname, reltuples, (relpages / 128) as mbytes, (relpages * 8192.0 / (reltuples + 1e-10)) as average_row_size FROM pg_class ORDER BY mbytes DESC;