Neo4j Aura Troubleshoot (and Kill) Long Running Transactions / Queries

When using Neo4j Aura, you may need to troubleshoot some long running queries, or transactions.  Due to some deprecated procedures in Neo4j, you may have done this differently in the past.  

Deprecated procedures:

dbms.listQueries()

dbms.listTransactions()

dbms.killQuery()

dbms.killQueries()

dbms.killTransaction()

dbms.killTransactions()

Today using Neo4j Aura 4 and later versions:

You can show a list of transactions using cypher by executing:

SHOW TRANSACTIONS

You can terminate a transaction using cypher by executing:

TERMINATE TRANSACTION[S] transaction_id[, ...]

You can see more about all procedures using cypher by executing:

SHOW PROCEDURES

Lastly,  the latest operations manual documentation on procedures is located at
https://neo4j.com/docs/operations-manual/current/reference/procedures/