List Queries

The LIST QUERIES command is used to obtain a list of existing queries in RioDB.

Access Rule

Requires any role.

Syntax

LIST QUERIES;

RioDB replies a JSON formatted response containing an array of query objects. Each query object contains:
id – queries don’t have name. They have an ID number.
stream – the stream that the query tracks.
output_type – The plugin invoked when the query conditions are met.
status – status of the query, in case the OUTPUT plugin has an error or warning.
remaining – some queries are set to expire after n triggers. This shows how many triggers remaining before the query expires.
statement – the original query statement, to help identify this query object.

Sample Response

{
  "status": 200,
  "statements": 1,
  "milliseconds": 2,
  "details": [
    {
      "statement": 1,
      "response": [
        {
          "id": 2,
          "stream": "my_bench_stream",
          "output_type": "STDOUT",
          "status": "OK",
          "remaining": 29,
          "statement": "select max, min from last_10_bids_on_tsla output stdout sleep 1m;"
        }
      ]
    }
  ]
}