Re: Tupple statistics function

> Hi,
> 
> I have written a small function that show how many tuples are dead
> etc. in a specified table. Example output is:
> 
> test=# select pgstattuple('tellers');
> NOTICE:  physical length: 0.02MB live tuples: 200 (0.01MB, 58.59%) dead tuples: 100 (0.00MB, 29.30%) overhead:
12.11%
>  pgstattuple 
> -------------
>    29.296875
> (1 row)
> 
> Shall I add this function into contrib directory?

I have been wanting this for a long time.  In fact, I wanted it linked
to VACUUM so you could vacuum a table only if it had >X% dead tuples. 
Seems we can find a place for this in the existing commands.  Not sure
where, though.  Ideas?

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026