Thanks.
How, then, do I get only long-running SELECT statements?
I've tried this (since I don't want to inadvertently get other DML & DDL statements which might have "select" in a field name), but CTEs and queries that start with a comment slip by this filter.
FROM pg_stat_activity
WHERE state <> 'idle'
AND SUBSTRING(UPPER(query) FROM 1 FOR 6) = 'SELECT';
Thanks
On 06/11/2018 08:47 AM, Shreeyansh Dba wrote:
Ron,
Yes, It can list the insert,delete and update statement as well..
--
Angular momentum makes the world go 'round.