Benjamin Krajmalnik wrote:
In pgAdmin, one can view the total disk size occupied by a table in
the statistics view when in the “Tables” context.
What query is being used to calculate this?
I have found pg_relation_size() but it has to be called for multiple
entities in order to arrive at the total utilization.
I believe it's using pg_total_relation_size() there:
http://www.postgresql.org/docs/current/interactive/functions-admin.html
There are some sample queries to compute disk use information in a
couple of different forms at http://wiki.postgresql.org/wiki/Disk_Usage
you might find handy too.
--
Greg Smith 2ndQuadrant Baltimore, MD
PostgreSQL Training, Services and Support
g...@2ndquadrant.com www.2ndQuadrant.com
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
