@@ -84,6 +84,8 @@ const char *PROGRAM_VERSION = "unknown";
84
84
" AND l.pid NOT IN (pg_backend_pid(), $1) " \
85
85
" AND (l.virtualxid, l.virtualtransaction) <> ('1/1', '-1/0') " \
86
86
" AND (a.application_name IS NULL OR a.application_name <> $2)" \
87
+ " AND a.query !~* E'^\\\\s*vacuum\\\\s+' " \
88
+ " AND a.query !~ E'^autovacuum: ' " \
87
89
" AND ((d.datname IS NULL OR d.datname = current_database()) OR l.database = 0)"
88
90
89
91
#define SQL_XID_SNAPSHOT_90000 \
@@ -97,6 +99,8 @@ const char *PROGRAM_VERSION = "unknown";
97
99
" AND l.pid NOT IN (pg_backend_pid(), $1) " \
98
100
" AND (l.virtualxid, l.virtualtransaction) <> ('1/1', '-1/0') " \
99
101
" AND (a.application_name IS NULL OR a.application_name <> $2)" \
102
+ " AND a.query !~* E'^\\\\s*vacuum\\\\s+' " \
103
+ " AND a.query !~ E'^autovacuum: ' " \
100
104
" AND ((d.datname IS NULL OR d.datname = current_database()) OR l.database = 0)"
101
105
102
106
/* application_name is not available before 9.0. The last clause of
@@ -111,6 +115,8 @@ const char *PROGRAM_VERSION = "unknown";
111
115
" ON a.datid = d.oid " \
112
116
" WHERE l.locktype = 'virtualxid' AND l.pid NOT IN (pg_backend_pid(), $1)" \
113
117
" AND (l.virtualxid, l.virtualtransaction) <> ('1/1', '-1/0') " \
118
+ " AND a.query !~* E'^\\\\s*vacuum\\\\s+' " \
119
+ " AND a.query !~ E'^autovacuum: ' " \
114
120
" AND ((d.datname IS NULL OR d.datname = current_database()) OR l.database = 0)" \
115
121
" AND ($2::text IS NOT NULL)"
116
122
0 commit comments