maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_kill_onlinereports()
Parameters
Name
Type
Mode
Definition
with q as (select pid,query_start,(now() - query_start)::interval duration from pg_stat_activity where query like 'select events2%') select pg_cancel_backend(pid) from q where duration > '1 minute'::interval;