Postgres Pro
Downloads
Home   >   mailing lists

Re: Statistics mismatch between n_live_tup and actual row count - Mailing list pgsql-general

From tim_wilson
Subject Re: Statistics mismatch between n_live_tup and actual row count
Date
Msg-id 1354848303362-5735593.post@n5.nabble.com
Whole thread Raw
In response to Re: Statistics mismatch between n_live_tup and actual row count  (Adrian Klaver <adrian.klaver@gmail.com>)
Responses Re: Statistics mismatch between n_live_tup and actual row count  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view 
<http://postgresql.1045698.n5.nabble.com/file/n5735593/pg_drift.png>



86% of the updates are HOT updates!

The difference between the first and second line of this image above is that
366 updates happened of which 299 where HOT. And a vacuum on the table was
run.
Look at the retuples number change after the vacuum!

Open transactions... how does this impact those numbers?



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Statistics-mismatch-between-n-live-tup-and-actual-row-count-tp5059317p5735593.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Statistics mismatch between n_live_tup and actual row count
Next
From: Adrian Klaver
Date:
Subject: Re: Statistics mismatch between n_live_tup and actual row count