Rethinkdb: Cancelling queries that were too stressful

[jared-mackey]

How can I cancel a query that is running that is causing issues?

Sometimes during testing it is possible to write queries that weren't the best and cause super high loads killing our other applications. It would be nice to see a list of these along with their run time, predicted time remaining, and some sort of load calculation to see how much stress they are really imposing. Is something like this possible?

[chrisvariety]

RethinkDB has a variety of system tables which can be used to "peek under the hood"

One of these tables is the jobs table, which will list active queries and their run time (amongst other things)

You can stop a query by simply deleting it from the jobs table.

More info about the jobs table here: https://rethinkdb.com/docs/system-jobs/

And system tables in general: https://rethinkdb.com/docs/system-tables/

[jared-mackey]

Those docs are a great resource, thanks @chrisvariety

It would still be nice if the web interface included these with an easy kill.