Skip site navigation (1) Skip section navigation (2)

Re: select actual data size for a relation?

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Kevin Kempter <kevink(at)consistentstate(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: select actual data size for a relation?
Date: 2009-10-22 23:56:52
Message-ID: 1256255812.2821.12.camel@jd-desktop.unknown.charter.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Thu, 2009-10-22 at 17:41 -0600, Kevin Kempter wrote:
> Hi all;
> 
> Anyone know how to select / calculate the actual data size for a table or 
> index?  

select pg_total_relation_size('relation')

> 
> NOT the disk usage as in:
>  pg_class.relpages -- shows disk usage including bloat
> pg_relation_size() -- same as pg_class.relpages but in bytes
> or pg_total_relation_size()  -- total disk usage inclusive of bloat and 
> indexes
> 
> I want only the data size. I tried grabbing the sum of all the avg_width cols 
> from pg_stats and multiplying times the pg_class.reltuples but this seems way 
> too big.
> 
> Thoughts?
> 
> 
> 
> Thanks in advance
> 


-- 
PostgreSQL.org Major Contributor
Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564
Consulting, Training, Support, Custom Development, Engineering
If the world pushes look it in the eye and GRR. Then push back harder. - Salamander


In response to

pgsql-admin by date

Next:From: Marc MaminDate: 2009-10-23 12:48:58
Subject: pg_dump custom format and pigz
Previous:From: Kevin KempterDate: 2009-10-22 23:41:38
Subject: select actual data size for a relation?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group