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_activityWHERE state <> 'idle' AND SUBSTRING(UPPER(query) FROM 1 FOR 6) = 'SELECT'; ThanksOn 06/11/2018 08:47 AM, Shreeyansh Dba wrote:Ron, Yes, It can list the insert,delete and update statement as well..On Mon, Jun 11, 2018 at 7:07 PM, Ron <ronljohnsonjr@gmail.com> 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.
Ron, Yes, It can list the insert,delete and update statement as well..On Mon, Jun 11, 2018 at 7:07 PM, Ron <ronljohnsonjr@gmail.com> wrote:Hi, Does pg_stat_activity only list SELECT statements, or does it also list INSERT, DELETE and UPDATE statements?
Hi, Does pg_stat_activity only list SELECT statements, or does it also list INSERT, DELETE and UPDATE statements?
pgsql-admin by date:
Соглашаюсь с условиями обработки персональных данных