These are my settings:
According to the documentation, as far as I can tell, this combination of settings along with a
statement_timeout value of 3600000 should mean that hour-long queries time out, and well before then, they and anything else longer than ~214ms should be producing EXPLAIN output in the logs. But they're not.
auto_explainby default when I checked.
- The parameters above are applied to the server.
- I've restarted the instance after applying the parameters.
- My back end has reported an incidence of
canceling statement due to statement timeout(which only started happening after I set
statement_timeout) but there is nothing in the logs (at all, let alone in the vicinity of the time reported) showing anything other than xlog starting and stopping.
What else could be missing?