Add a button in the console to cancel the currently running query

[hlcianfagna]

While it is possible to open a separate browser tab, query sys.jobs and issue a kill command, it would be really handy to have a button directly in the console to cancel the currently running query.

Related with #675

[surister]

Any tip on how to easily reproduce a long timed query to develop/test this?

[amotl]

Dear @surister,

It looks like CrateDB does not implement pg_sleep. However, @proddata referenced a sleep function over at crate/crate#14511.

SELECT sleep(6000);

On the other hand, I can't find a corresponding definition anywhere. It is probably defined per user defined function ¹, i.e. written in JavaScript?

With kind regards,
Andreas.

Footnotes

1. https://cratedb.com/docs/crate/reference/en/5.4/general/user-defined-functions.html ↩

[hlcianfagna]

Hi,
UDFs are a particular case when it comes to terminating queries I think, but you can simply run a large INSERT INTO like:

CREATE TABLE tbl1 (a text);

INSERT INTO tbl1 
SELECT a.b::text 
FROM generate_series(1,100000000) a(b);