2017-04-18 22:06 GMT+02:00 Tom Lane <tgl@xxxxxxxxxxxxx>:
Tom DalPozzo <t.dalpozzo@xxxxxxxxx> writes:
> Hi, I'm using libpq to insert tuples in my table and keep looking at
> statistics through psql instead.
> I noticed that sometimes n_tuple_ins is not updated even after 1 min that
> my transaction committed.
If your session is just sitting, that's not surprising. I think stats
updates are only transmitted to the collector at transaction end (and
even then, only if it's been at least N msec since the last transmission
from the current session).
regards, tom lane
Hi, my transaction ended, that I waited 1 min and queried the stat.
I had to wait for session end in order to see the updeted stats.
Did you mean "...to the collector at SESSION end"?
Regards
Pupillo
