Re: pg_stat_statements: calls under-estimation propagation

From: samthakur74 <samthakur74(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: pg_stat_statements: calls under-estimation propagation
Date: 2013-09-19 05:25:02
Message-ID: CABzZFEvkzMuhd2qyuEvp49m-bs+R8r-VCtGPma54LZyP5tVzDw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

>I got the segmentation fault when I tested the case where the
least-executed
>query statistics is discarded, i.e., when I executed different queries
more than
>pg_stat_statements.max times. I guess that the patch might have a bug.
Thanks, will try to fix it.

>pg_stat_statements--1.1.sql should be removed.
> Yes will do that
>

> >+ <entry><structfield>queryid</structfield></entry>
> >+ <entry><type>bigint</type></entry>
> >+ <entry></entry>
> >+ <entry>Unique value of each representative statement for the
> >current statistics session.
> >+ This value will change for each new statistics session.</entry>
>
> >What does "statistics session" mean?
> The time period when statistics are gathered by statistics collector
> without being reset. So the statistics session continues across normal
> shutdowns, but in case of abnormal situations like crashes, format upgrades
> or statistics being reset for any other reason, a new time period of
> statistics collection starts i.e. a new statistics session. The queryid
> value generation is linked to statistics session so emphasize the fact that
> in case of crashes,format upgrades or any situation of statistics reset,
> the queryid for the same queries will also change. Will update
> documentation clearly explain the term statistics session in this context
>
> regards
Sameer

>
>

--
View this message in context: http://postgresql.1045698.n5.nabble.com/pg-stat-statements-calls-under-estimation-propagation-tp5738128p5771562.html
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jeevan Chalke 2013-09-19 06:00:18 Re: proposal: simple date constructor from numeric values
Previous Message Fujii Masao 2013-09-19 05:08:36 Re: logical changeset generation v6