Re: pg_stat_activity - Mailing list pgsql-admin

From David G. Johnston
Subject Re: pg_stat_activity
Date
Msg-id CAKFQuwZGZzbVKjhznx6pY+NXGvNCD2Oytz0Fma53ZbCnZVQagg@mail.gmail.com
Whole thread Raw
In response to Re: pg_stat_activity  (pavan95 <pavan.postgresdba@gmail.com>)
Responses Re: pg_stat_activity  (pavan95 <pavan.postgresdba@gmail.com>)
List pgsql-admin
On Monday, June 11, 2018, pavan95 <pavan.postgresdba@gmail.com> wrote:
Hi David,

  >>You can also configure table level audit with the help of triggers to
capture DML's

​>How?

Please find below procedure to configure table level audit with the help of
triggers :
[...]

That's it and you are done. Just add the table you want to track the DML's
in the below way:

I'm missing the part where any of that has to do with pg_stat_activity and the question that this thread is about...in particular the part about select statements.

David J.
 

pgsql-admin by date:

Previous
From: pavan95
Date:
Subject: Re: pg_stat_activity
Next
From: pavan95
Date:
Subject: Re: PostgreSQL 'Corruption & Fragmentation' detection andresolution/fix