Implement 'SHOW QUERIES' for InfluxDB v2

[NielsH]

Proposal:
Implement the 'SHOW QUERIES' and 'KILL QUERY' present in InfluxDB 1.x into InfluxDB 2.x

Current behavior:
Currently this feature does not exist in InfluxDB 2.x

Desired behavior:
For this feature to exist as it did in InfluxDB 1.x

Alternatives considered:
I did not find an alternative or workaround

Use case:
On InfluxDB 1.x we could run SHOW QUERIES to see what queries we had running. We used this sometimes to troubleshoot a high load and see a hanging query.

Now with InfluxDB 2 something happened that caused all cores to go to 100% however I cannot see what queries are currently running.It seems InfluxDB v2 does not support this.

I asked this on the community forum and @Jayclifford345 responded to me that he believes this is currently not possible, and requested I submitted a feature request.

In my initial post I asked about the SHOW QUERIES option, but of course once we have identified a bad query we'd like to kill it as well, so having the KILL QUERY option available as well in InfluxDB 2.x would be great.

[bionicthumb]

We've recently been having the same issue. The SHOW QUERIES and KILL QUERY functions would be very useful for general management of the InfluxDB instance.