pg_terminate_backend(pid)

pg_stat_activity

-- don't kill yourself

pid <> pg_backend_pid()

-- AND

-- don't kill your admin tools

--application_name !~ '(?:psql)|(?:pgAdmin.+)'

-- AND

--usename not in ('postgres')

AND

query in ('')

AND

state in ('idle', 'idle in transaction', 'idle in transaction (aborted)', 'disabled')

AND

--state_change < current_timestamp - INTERVAL '15' MINUTE;

(

(current_timestamp - query_start) > interval '15 minutes'

OR

(query_start IS NULL AND (current_timestamp - backend_start) > interval '15 minutes')

)

;