Re: Monitor the ddl and dml activities in logs

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Nanda Kumar <Nanda(dot)Kumar(at)smartstream-stp(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Monitor the ddl and dml activities in logs
Date: 2019-03-06 19:12:38
Message-ID: 6EAD17FA-D8BD-4C15-89A5-B2ECFDE2E6B0@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-03-06 19:18:48 Re: Monitor the ddl and dml activities in logs
Previous Message Adrian Klaver 2019-03-06 18:29:18 Re: query has no destination for result data