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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
