Postgres Pro
Downloads
Home   >   mailing lists

Thread: Table size

Table size

From
"Benjamin Krajmalnik"
Date:
<div class="Section1"><p class="MsoNormal">In pgAdmin, one can view the total disk size occupied by a table in the
statisticsview when in the “Tables” context.<p class="MsoNormal">What query is being used to calculate this?<p
class="MsoNormal">Ihave found pg_relation_size() but it has to be called for multiple entities in order to arrive at
thetotal utilization.<p class="MsoNormal"> <p class="MsoNormal">Thanks in advance.<p class="MsoNormal"> </div>

Re: Table size

From
Greg Smith
Date:
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
greg@2ndQuadrant.com  www.2ndQuadrant.com

Re: Table size

From
Guillaume Lelarge
Date:
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
forthe  "Indexes Size" row,* and a sum of the pg_relation_size of the TOAST table size and of the  pg_relation_size of
theTOAST indexes for the "Toast Table Size" row.
 


-- 
Guillaume.http://www.postgresqlfr.orghttp://dalibo.com