Hi, I'm trying to log statements that are being fired from hibernate, so that i can benchmark them without hibernate itself. I want to fire the SQL at the database directly and see what difference i can make by tweaking things.
But when i set log_statement = 'all', the logging looks like this:
Now, how can i get these $1 etc values to be replaced with their values, so that i can produce valid SQL? Is there a postgresql.conf setting, or maybe some perl script that goes around? (of course, it's more than just 3 lines.... I can't do it by hand.)
thx!
WBL
-- "Patriotism is the conviction that your country is superior to all others because you were born in it." -- George Bernard Shaw