I need to filter out logging for some tables. We have an application which often query for a settings table and for pg_proc. This pollutes postgresql.log with numerous useless queries and we are looking for a way to skip logging entirely for those. Any suggestion?
Don't know for sure if this will work but I'd probably wrap the relevant query in a function and add "SET log_statements = none" at the top. You'll need to make the function "security definer" and make it owned by a superuser.