I want to monitor all queries to my postgresql instance. Following these steps, I created a custom db parameter group, set
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?
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