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