Re: pg_stat_activity - Mailing list pgsql-admin

From Rui DeSousa
Subject Re: pg_stat_activity
Date
Msg-id BC0EBD96-110B-4CC7-A5B3-3088C40EEDA7@icloud.com
Whole thread Raw
In response to Re: pg_stat_activity  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: pg_stat_activity  (Pavan Teja <pavan.postgresdba@gmail.com>)
List pgsql-admin
> On Jun 11, 2018, at 9:56 AM, Ron <ronljohnsonjr@gmail.com> wrote:
>
> How, then, do I get only long-running SELECT statements?
>

Why only select statements? What about select statements that are really updates?

i.e.

select …. for update;
select do_some_work();   —In this case you will not see the actual executing SQL in the function which could be update,
delete,select, etc. 

Or what about delete or update with returning?

pgsql-admin by date:

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