Re: [GENERAL] tuple statistics update

Hi, 2017-04-19 16:37 GMT+02:00 Tom Lane : > Tom DalPozzo writes: > > 2017-04-18 22:06 GMT+02:00 Tom Lane : > >> If your session is just sitting, that's not surprising. I think stats > >> updates are only transmitted to the collector

Re: [GENERAL] tuple statistics update

Hi, 2017-04-19 15:49 GMT+02:00 Adrian Klaver : > On 04/19/2017 12:28 AM, Tom DalPozzo wrote: > >> 2017-04-18 21:42 GMT+02:00 Adrian Klaver > >: >> >> On 04/17/2017 09:18 AM, Tom DalPozzo wrote: >> >>

Re: [GENERAL] tuple statistics update

Tom DalPozzo writes: > 2017-04-18 22:06 GMT+02:00 Tom Lane : >> 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

Re: [GENERAL] tuple statistics update

On 04/19/2017 12:28 AM, Tom DalPozzo wrote: 2017-04-18 21:42 GMT+02:00 Adrian Klaver >: On 04/17/2017 09:18 AM, Tom DalPozzo wrote: Hi, I'm using libpq to insert tuples in my table and keep looking at statistics

Re: [GENERAL] tuple statistics update

2017-04-18 22:06 GMT+02:00 Tom Lane : > Tom DalPozzo 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 > >

Re: [GENERAL] tuple statistics update

2017-04-18 21:42 GMT+02:00 Adrian Klaver : > On 04/17/2017 09:18 AM, Tom DalPozzo wrote: > >> 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

Re: [GENERAL] tuple statistics update

Tom DalPozzo 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

Re: [GENERAL] tuple statistics update

On 04/17/2017 09:18 AM, Tom DalPozzo wrote: 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. My libpq connection is kept alive. If I close the

[GENERAL] tuple statistics update

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. My libpq connection is kept alive. If I close the connection then the stats get updated. I know