Question:
I want to monitor all queries to my postgresql instance. Following these steps, I created a custom db parameter group, set log_statement
to all
and log_min_duration_statement
to 1
, applied the parameter group to my instance, and rebooted it. Then I fired a POST
request to the instance but a record of query wasn’t to be found in the Recent Events & Logs
tab of my instance. Doing a SELECT * FROM table
query in psql
however shows that the resource was created and the post request worked. What am I missing in order to see the logs?
Answer:
Setting log_min_duration_statement
to 1
tells Postgres to only log queries that take longer than 1 ms. If you set it to 0
instead, all queries will be logged (the default, no logging, is -1
).