Le 05/02/2010 11:57, Greg Smith a écrit : > 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. >
Nope. We are using: * pg_relation_size on the table OID for the "Table Size" row, * a sum of pg_relation_size for all indexes on this table for the "Indexes Size" row, * and a sum of the pg_relation_size of the TOAST table size and of the pg_relation_size of the TOAST indexes for the "Toast Table Size" row. -- Guillaume. http://www.postgresqlfr.org http://dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
