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.
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