On Thu, Oct 10, 2013 at 3:11 AM, <pilum...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers