Re: pg_dump
| От | raghu ram |
|---|---|
| Тема | Re: pg_dump |
| Дата | |
| Msg-id | BANLkTik+2Kf+4CEBVHY+OZ7_ckv-4+vR=A@mail.gmail.com обсуждение исходный текст |
| Ответ на | pg_dump (aaronenabs <aaronenabs@btconnect.com>) |
| Список | pgsql-novice |
On Mon, Apr 4, 2011 at 8:02 PM, aaronenabs <aaronenabs@btconnect.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice
В списке pgsql-novice по дате отправления: