Re: pg_dump

On Mon, Apr 4, 2011 at 8:02 PM, aaronenabs <aaronenabs(at)btconnect(dot)com> wrote:

> Hi all,
>
> I wanted to find out if i can use pg_dump to display dead tuples/rows.
>
>

pg_dump utility does not display dead/live tuples count in a particular
tables.

You can identify the dead/live tuples count in a table using below SQL
statement::

postgres=# select relname,schemaname,n_live_tup,n_dead_tup from
pg_stat_user_tables;
relname | schemaname | n_live_tup | n_dead_tup
---------+------------+------------+------------
test3 | public | 10 | 7

--Raghu Ram

> Cheers
> Aaron
>
> --
> View this message in context:
> http://postgresql.1045698.n5.nabble.com/pg-dump-tp4281853p4281853.html
> Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>