Tupple statistics function - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Tupple statistics function
Date
Msg-id 20010922133647T.t-ishii@sra.co.jp
Whole thread Raw
Responses Re: Tupple statistics function  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: Tupple statistics function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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?
--
Tatsuo Ishii


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: Re: cvsup trouble - ODBC blown away !?!?
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL funding/organization