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? Any suggestions would be appreciated.