Hannu Krosing <ha...@krosing.net> writes: >> Hm, you mean reverse-engineering the parameterization of the query? > > Yes, basically re-generate the query after (or while) parsing, replacing > constants and arguments with another set of generated arguments and > printing the list of these arguments at the end. It may be easiest to do > This in parallel with parsing. > >> Interesting thought, but I really don't see a way to make it practical. > > Another place where this could be really useful is logging & monitoring
Another big use case is full support for materialized views: we could then optimize a query to automatically use a matview even when written against the “usual” schema. Now matviews are another kind of indexes. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers