Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_stat_activity - Mailing list pgsql-admin

From Payal Singh
Subject Re: pg_stat_activity
Date
Msg-id CANUg7LAmsjvD1q4yMPkQnkL++DAC1E+mfouciyi514gpMvCWjA@mail.gmail.com
Whole thread Raw
In response to pg_stat_activity  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-admin
Tree view
Does pg_stat_activity only list SELECT statements, or does it also list INSERT, DELETE and UPDATE statements?
 
It lists all statements - read, DDL, DML as well as vacuums 

Payal Singh,
Database Administrator,
OmniTI Computer Consulting Inc.
Phone: 240.646.0770 x 253

On Mon, Jun 11, 2018 at 9:37 AM, Ron <ronljohnsonjr@gmail.com> wrote:
Hi,

Does pg_stat_activity only list SELECT statements, or does it also list INSERT, DELETE and UPDATE statements?


--
Angular momentum makes the world go 'round.


pgsql-admin by date:

Previous
From: Thomas Poty
Date:
Subject: Re: pg_stat_activity
Next
From: Shreeyansh Dba
Date:
Subject: Re: pg_stat_activity