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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026