SQL and PPL monitoring

OpenSearch provides a stats endpoint that collects metrics for SQL and PPL query processing within a set interval. Statistics are collected at the node level, so you receive metrics only for the node you’re accessing.

Node statistics

The response contains the following fields.

Example

SQL query:

>> curl -H 'Content-Type: application/json' -X GET localhost:9200/_plugins/_sql/stats

The query returns the following results:

{
  "failed_request_count_cb": 0,
  "failed_request_count_cuserr": 0,
  "circuit_breaker": 0,
  "request_total": 0,
  "request_count": 0,
  "failed_request_count_syserr": 0
}