Tupple statistics function

From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Tupple statistics function
Date: 2001-09-22 04:36:47
Message-ID: 20010922133647T.t-ishii@sra.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-09-22 04:58:41 Re: Tupple statistics function
Previous Message vitthal 2001-09-22 01:29:14 Reading the database in RAM

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2001-09-22 04:56:45 Re: PostgreSQL funding/organization
Previous Message Marc G. Fournier 2001-09-22 03:33:03 Re: cvsup trouble - ODBC blown away !?!?