Hi,
I’ve got a situation where a user was seeing their database pegged at 100% CPU usage. We tracked it down to a parameterized query, and when we removed the process that was launching the query, it solved the problem. I still don’t understand what caused the problem, though. I’ve searched around in the old messages and FAQ and google and didn’t find anything that helped.
The one thing that stands out at this point is that the parameters aren’t written to the log file.
For other parameterized queries, the logs will look like this:
2011-12-02 13:33:58 MSTLOG: duration: 0.028 ms execute <unnamed>: SELECT COUNT(*) FROM table_name WHERE field = $1
2011-12-02 13:33:58 MSTDETAIL: parameters: $1 = 'value'
But for the query that was causing a problem, there is never an “MSTDETAIL” line showing the parameters.
We’re using PostgreSQL 9.0 and accessing via JDBC.
Thanks for any help/insight you can provide.
msd