Re: [HACKERS] tuple statistics function

2001-09-26 Thread Jan Wieck
Tatsuo Ishii wrote: > Here is a revised version of pg_stattuple, which shows how many tuples > are "dead" etc. Per Tom's suggestion, a statistic of free/resuable > space is now printed. > > test=# select pgstattuple('accounts'); > NOTICE: physical length: 39.06MB live tuples: 10 (12.59MB, 32.

[HACKERS] tuple statistics function

2001-09-25 Thread Tatsuo Ishii
Here is a revised version of pg_stattuple, which shows how many tuples are "dead" etc. Per Tom's suggestion, a statistic of free/resuable space is now printed. test=# select pgstattuple('accounts'); NOTICE: physical length: 39.06MB live tuples: 10 (12.59MB, 32.23%) dead tuples: 20 (25.1