Query Detail Action

Request

GET /api/query_detail

Description

Used to obtain information about all queries after a specified time point

Path parameters

None

Query parameters

  • event_time

    At the specified time point (Unix timestamp, in milliseconds), obtain query information after that time point.

Request body

无

Response

  1. {
  2.     "msg": "success",
  3.     "code": 0,
  4.     "data": {
  5.         "query_details": [{
  6.             "eventTime": 1596462699216,
  7.             "queryId": "f732084bc8e74f39-8313581c9c3c0b58",
  8.             "startTime": 1596462698969,
  9.             "endTime": 1596462699216,
  10.             "latency": 247,
  11.             "state": "FINISHED",
  12.             "database": "db1",
  13.             "sql": "select * from tbl1"
  14.         }, {
  15.             "eventTime": 1596463013929,
  16.             "queryId": "ed2d0d80855d47a5-8b518a0f1472f60c",
  17.             "startTime": 1596463013913,
  18.             "endTime": 1596463013929,
  19.             "latency": 16,
  20.             "state": "FINISHED",
  21.             "database": "db1",
  22.             "sql": "select k1 from tbl1"
  23.         }]
  24.     },
  25.     "count": 0
  26. }

Examples

  1. Get query details after the specified time point.

    1. GET /api/query_detail?event_time=1596462079958
    3. Response:
    4. {
    5.     "msg": "success",
    6.     "code": 0,
    7.     "data": {
    8.         "query_details": [{
    9.             "eventTime": 1596462699216,
    10.             "queryId": "f732084bc8e74f39-8313581c9c3c0b58",
    11.             "startTime": 1596462698969,
    12.             "endTime": 1596462699216,
    13.             "latency": 247,
    14.             "state": "FINISHED",
    15.             "database": "db1",
    16.             "sql": "select * from tbl1"
    17.         }, {
    18.             "eventTime": 1596463013929,
    19.             "queryId": "ed2d0d80855d47a5-8b518a0f1472f60c",
    20.             "startTime": 1596463013913,
    21.             "endTime": 1596463013929,
    22.             "latency": 16,
    23.             "state": "FINISHED",
    24.             "database": "db1",
    25.             "sql": "select k1 from tbl1"
    26.         }]
    27.     },
    28.     "count": 0
    29. }