Kill a running query about pgweb HOT 8 CLOSED

This seems to be interesting, however i'm not planning on getting this implemented in the next releases.

from pgweb.

It'd also be useful to know how long an ongoing query has been running. A simple javascript timer on the page would suffice for this purpose.

from pgweb.

@kespindler javascript timer would be irrelevant in case if you run a query on non-local servers. Results
table also takes some time. So if we want to have query execution time, it has to be done via backend.

from pgweb.

Stopping a running query is currently in works.

from pgweb.

Is it possible to use pgweb as a service? Or what should be the proper way to deploy it?

from pgweb.

+1

from pgweb.

I think this should be pretty easy to make.

You already made the Activity tab, it has which one is active and what's the pid.
I imagine active queries having a "kill" button that executes this:

SELECT pg_cancel_backend(pid);

And Activity tab is refreshed. That should do no?

from pgweb.

Implemented in master

from pgweb.