I have been using the following to set up the log file:
log_statement='all', log_collector='on', log_destination='on', log_filename='filename'
After that, for testing I just executed a query then I have seen the log file in
tools>serverstatus. Unfortunately it has a lot of anonymous queries including the query which I ran.
How can I filter out the queries which were executed along with my query (anonymous queries)? Is there any possibility to log the affected table information like:
- which table got affected?
- at what time was the query executed?
- what fields got affected?
And how can I get these details using queries?