Re: pg_stat_activity

From: Payal Singh <payal(at)omniti(dot)com>
To: Ron <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_stat_activity
Date: 2018-06-11 13:46:16
Message-ID: CANUg7LAmsjvD1q4yMPkQnkL++DAC1E+mfouciyi514gpMvCWjA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

>
> 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(at)gmail(dot)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.
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2018-06-11 13:47:05 Re: pg_stat_activity
Previous Message Thomas Poty 2018-06-11 13:45:39 Re: pg_stat_activity