Re: [GENERAL] tuple statistics update - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] tuple statistics update
Date
Msg-id 22480.1492545978@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] tuple statistics update  (Tom DalPozzo <t.dalpozzo@gmail.com>)
Responses Re: [GENERAL] tuple statistics update  (Tom DalPozzo <t.dalpozzo@gmail.com>)
List pgsql-general
Tom DalPozzo <t.dalpozzo@gmail.com> 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


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] tuple statistics update
Next
From: Rj Ewing
Date:
Subject: [GENERAL] full text search on hstore or json with materialized view?