Stat estiamtes off - why?

From: "Nicholson, Brad (Toronto, ON, CA)" <bnicholson(at)hp(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Stat estiamtes off - why?
Date: 2013-08-29 16:24:10
Message-ID: EC55DC235432104F8255702A8D7344D941970C9C@G4W3302.americas.hpqcorp.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm seeing something odd in my DB stats. This is PG 9.2.4 on CentOS. I know the stats collector can be off at times, but I am curious as to why it would be off in such a case. I know that under heavy load the stats collector can be off sometimes, but this system was barely doing anything (CPU ~ 90% idle). PG didn't shutdown at all either.

I'm curious how it ended up with 191 live tuples, but only did 17 inserts to the table. In actuality, the table is empty at the time I ran this query, manually analyzing it updated the live_tuples back down to 0. I

select n_tup_ins, n_tup_upd, n_tup_del, n_tup_hot_upd, n_live_tup, n_dead_tup from pg_stat_user_tables where relname = 'foo';
-[ RECORD 1 ]-----+------------------------------
n_tup_ins | 17
n_tup_upd | 305
n_tup_del | 17
n_tup_hot_upd | 297
n_live_tup | 191
n_dead_tup | 11

Thanks,
Brad.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2013-08-29 17:14:59 Re: Stat estiamtes off - why?
Previous Message Gianni Ceccarelli 2013-08-29 16:20:08 SSI and predicate locks - a non-trivial use case