bmallred

jump to main content
Dark Mode

undefined

1 postgresql

1.1 view running SQL

select pid, state, query from pgstatactivity where state='active' and usename='<username>';

1.2 cancel query

select pgcancelbackend(<pid>);

1.3 terminate query (if hung)

select pgterminatebackend(<pid>)