Re: pg_stat_activity

[Payal Singh <payal@xxxxxxxxxx>]

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@xxxxxxxxx> 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.