I need to explain an application generated SQL statement in PostgreSQL 8.3. I captured the SQL statement in the log but it has a lot of bind variables. Is their any way that I can explain this SQL statement?
When I tried it with the bind variables the parser didn't like it. If I change the bind variables to the actual values used in the statement won't that potentially change the access path to the data?