Re: Monitor the ddl and dml activities in logs

[Ben Chobot <bench@xxxxxxxxxxxxxxx>]

On Mar 6, 2019, at 5:58 AM, Nanda Kumar <Nanda.Kumar@xxxxxxxxxxxxxxxxxxx> wrote:

Hello Team,

 

I would like to know where I can monitor the ddl and dml operations happens in the production environment .

The documentation is your friend, particularly https://www.postgresql.org/docs/9.6/runtime-config-logging.html. By setting log_statement appropriately, you can see ddl and dml in your server logs.