On Mon, Jun 11, 2018 at 8:07 AM, Ron <ronljohnsonjr(at)gmail(dot)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.