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

From Peter Geoghegan
Subject Re: pg_stat_statements: calls under-estimation propagation
Date
Msg-id CAM3SWZTB_Puh+ir_3t4L9Vz61qkhp=G9SpAgGBtsyYkPA0pP8Q@mail.gmail.com
Whole thread Raw
In response to Re: pg_stat_statements: calls under-estimation propagation  (pilum.70@uni-muenster.de)
Responses Re: pg_stat_statements: calls under-estimation propagation
List pgsql-hackers
On Thu, Oct 10, 2013 at 3:11 AM,  <pilum.70@uni-muenster.de> wrote:
> But the drawback of this approach is impossibility to use
> explain analyze without further substitutions.

You can fairly easily disable the swapping of constants with '?'
symbols, so that the query text stored would match the full originally
executed query. Why would you want to, though? There could be many
actual plans whose costs are aggregated as one query. Seeing one of
them is not necessarily useful at all, and could be misleading.


-- 
Peter Geoghegan



pgsql-hackers by date:

Previous
From: Sameer Thakur
Date:
Subject: Re: pg_stat_statements: calls under-estimation propagation
Next
From: Robert Haas
Date:
Subject: Re: CommitFest progress