Re: pg_stat_statements: calls under-estimation propagation - Mailing list pgsql-hackers

From samthakur74
Subject Re: pg_stat_statements: calls under-estimation propagation
Date
Msg-id CABzZFEvkzMuhd2qyuEvp49m-bs+R8r-VCtGPma54LZyP5tVzDw@mail.gmail.com
Whole thread Raw
In response to Re: pg_stat_statements: calls under-estimation propagation  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: pg_stat_statements: calls under-estimation propagation
List 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: Re: pg_stat_statements: calls under-estimation propagation
Sent from the PostgreSQL - hackers mailing list archive at Nabble.com.

pgsql-hackers by date:

Previous
From: Fujii Masao
Date:
Subject: Re: logical changeset generation v6
Next
From: Jeevan Chalke
Date:
Subject: Re: proposal: simple date constructor from numeric values