pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: pg_stat_activity
Date: Mon, 11 Jun 2018 11:12:28 -0500
Message-ID: <6ef6f956-595e-d0c4-36bd-dd9d10772b11@gmail.com> (raw)
In-Reply-To: <CAKFQuwZnt_CjE+xipRpS95vWWAmuaOVDm2A=4UuO+1kZGnXhkA@mail.gmail.com>
References: <4405957b-2e0f-bfc5-eaf6-5e2864da2796@gmail.com>
	<CAGDYbUM0Lv-fcFp_Mh4jyBtSrW24Z1psvey6FBi5q=LQx=7CMQ@mail.gmail.com>
	<9884a24a-c129-a1a9-1901-2a9c8987331e@gmail.com>
	<CAGDYbUPbY7MFcntGwTdxikxXahccKQTASApYGz=wPPksGMWJVg@mail.gmail.com>
	<211b19ea-18dc-6897-3c53-8d994550cd15@gmail.com>
	<CAKFQuwZnt_CjE+xipRpS95vWWAmuaOVDm2A=4UuO+1kZGnXhkA@mail.gmail.com>

On 06/11/2018 10:21 AM, David G. Johnston wrote:
> On Mon, Jun 11, 2018 at 8:07 AM, Ron <ronljohnsonjr@gmail.com 
> <mailto:ronljohnsonjr@gmail.com>>wrote:
>
>     That won't work, because that would catch any query on a table which
>     happens to have the string "select" in a table, index or column name.
>
>
> ​I don't believe what you are asking is possible using only 
> pg_stat_activity.  One thought that comes to mind is to identify, via 
> pg_locks, sessions that hold non-read-only locks and then exclude the rows 
> in pg_stat_activity that match up with those sessions.
>
> David J.
> ​

Thanks.  I'll try that.

-- 
Angular momentum makes the world go 'round.

view thread (23+ messages)  latest in thread

Message-ID: <6ef6f956-595e-d0c4-36bd-dd9d10772b11@gmail.com>
Permalink:  ../6ef6f956-595e-d0c4-36bd-dd9d10772b11@gmail.com/
Also on:    postgresql.org/message-id/6ef6f956-595e-d0c4-36bd-dd9d10772b11@gmail.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ronljohnsonjr@gmail.com
  Subject: Re: pg_stat_activity
  In-Reply-To: <6ef6f956-595e-d0c4-36bd-dd9d10772b11@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox