How to Find and Stop Running Queries on PostgreSQL

This process has saved me from an outage more than once.<p>I keep a dashboard of running pids, and get alerts when any of them take more than N minutes (excepting autovacuum). Once every few months I have to psql into prod and cancel one.

Quote: &quot;Windows does not have a kill command...&quot;<p>Yes, she does. It&#x27;s called &quot;taskkill&quot;

<a href="https:&#x2F;&#x2F;github.com&#x2F;dalibo&#x2F;pg_activity" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;dalibo&#x2F;pg_activity</a> (&#x27;a top-like application for PostgreSQL server activity monitoring&#x27;) is quite useful.

This is really nice, are there any preventative measures one could take as well? For example setting a max query run time or something like that?

Ooohh. That pg_blocking_pids(blockedpid) function is a nice one to add to the arsenal.

How can you find and stop users which are accessing a certain table?

There’s always “sudo reboot”, too :)