Postgres Pro
Downloads
Home   >   mailing lists

Re: Planning counters in pg_stat_statements (using pgss_store) - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Planning counters in pg_stat_statements (using pgss_store)
Date
Msg-id 84f3a8f0-2041-d4a4-4f46-ec1f99b90fb1@dunslane.net
Whole thread Raw
In response to Re: Planning counters in pg_stat_statements (using pgss_store)  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Planning counters in pg_stat_statements (using pgss_store)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On 7/25/21 12:03 PM, Tom Lane wrote:
>
> So AFAICS this test is inherently unstable and there is no code bug
> to be fixed.  We could drop the "plans" column from this query, or
> print something approximate like "plans > 0 AND plans <= calls".
> Thoughts?
>

Is that likely to tell us anything very useful? I suppose it's really
just a check against insane values. Since the test is unstable it's hard
to do more than that.


cheers


andrew

--
Andrew Dunstan
EDB: https://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Ranier Vilela
Date:
Subject: Re: Removing "long int"-related limit on hash table sizes
Next
From: Tom Lane
Date:
Subject: Re: Planning counters in pg_stat_statements (using pgss_store)