Rubymine database explorer: How to stop a long running query after you lost connection

If you started a long running query that you want to abort, you can use the red "Cancel running queries"-stop button Show archive.org snapshot .

If you started a long running query and lost connection, the button may not be available any more. In this case (after reconnecting) you can use the SHOW PROCESSLIST; SQL-Statement get a list of the running processes you started.
If you identified your process, use the kill statement Show archive.org snapshot to abort it.