Postgres Pro
Downloads
Home   >   mailing lists

Re: Monitor the ddl and dml activities in logs - Mailing list pgsql-general

From Ben Chobot
Subject Re: Monitor the ddl and dml activities in logs
Date
Msg-id 6EAD17FA-D8BD-4C15-89A5-B2ECFDE2E6B0@silentmedia.com
Whole thread Raw
In response to Monitor the ddl and dml activities in logs  (Nanda Kumar <Nanda.Kumar@smartstream-stp.com>)
List pgsql-general
Tree view

On Mar 6, 2019, at 5:58 AM, Nanda Kumar <Nanda.Kumar@smartstream-stp.com> 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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: query has no destination for result data
Next
From: Adrian Klaver
Date:
Subject: Re: Monitor the ddl and dml activities in logs