relid | relname | n_tup_ins | n_tup_upd | n_tup_hot_upd | n_dead_tup
-------+----------------+-----------+-----------+---------------+------------
16461 | table1 | 0 | 8352496 | 5389 | 8351242
On Wed, Apr 30, 2008 at 11:07 AM, Pavan Deolasee <
pavan.deolasee@gmail.com> wrote:
On Wed, Apr 30, 2008 at 10:59 AM, Gauri Kanekar
<
meetgaurikanekar@gmail.com> wrote:
> HOT doesn't seems to be working in our case.
>
SELECT relid, relname, n_tup_ins, n_tup_upd, n_tup_hot_upd, n_dead_tup
from pg_stat_user_tables WHERE relname = 'table1';
Thanks,
Pavan
--
Pavan Deolasee
--
Regards
Gauri
