On Thu, Oct 10, 2013 at 3:11 AM, <pilum(dot)70(at)uni-muenster(dot)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