Query Service Metrics
A list of the metrics provided by the Query Service.
The following Query Service metrics can be queried by means of the REST APIs described in Statistics.
As a brief introduction however, this is how you would go about building a REST command for the n1ql_active_requests metric.
Run the following command from your shell console to get the total number of active requests.
curl -X GET --location "http://localhost:8091/pools/default/stats/range/n1ql_active_requests" \
--basic --user Administrator:passwordSee Query Service Metrics Cross Reference if you are looking for a metric name you know from an alternative supported or legacy tool.
|
Tip
|
Total number of active requests. |
The total number of values allocated in the query engine. |
The number of APPROX_VECTOR_DISTANCE() calls made by statements. |
Total number of N1QL requests with at_plus index consistency. |
The total number of audit records sent to the server. Some requests cause more than one audit record to be emitted. Records in the output queue that have not yet been sent to the server are not counted. |
The total number of audit records sent to the server that failed. |
The number of potentially auditable requests that cause no audit action to be taken. |
The total number of potentially auditable requests sent to the query engine. |
The time the service booted in fractional seconds since Unix epoch. |
The total number of reads on the bucket. |
The total number of retries on the bucket. |
The total number of writes on the bucket. |
Count of errors due to bulk get operations |
Total number of cancelled requests. |
Count of CAS mismatch errors |
The number of distinct operations recording Compute Units (CUs) with Regulator. |
The number of Compute Units (CUs) refunded. |
The number of Read Units (RUs) refunded. |
The number of Write Units (WUs) refunded. |
The number of CURL() calls made by statements that failed (returned an error). |
The number of CURL() calls made by statements. |
The 15m.rate latency of SQL++ Composite VECTOR requests. |
The 1m.rate latency of SQL++ Composite VECTOR requests. |
The 5m.rate latency of SQL++ Composite VECTOR requests. |
The number of SQL++ Composite VECTOR requests. |
The MAX latency of SQL++ Composite VECTOR requests. |
The MEAN latency of SQL++ Composite VECTOR requests. |
The mean.rate latency of SQL++ Composite VECTOR requests. |
The MEDIAN latency of SQL++ Composite VECTOR requests. |
The MIN latency of SQL++ Composite VECTOR requests. |
The 75% latency of SQL++ Composite VECTOR requests. |
The 95% latency of SQL++ Composite VECTOR requests. |
The 99% latency of SQL++ Composite VECTOR requests. |
The 99.9% latency of SQL++ Composite VECTOR requests. |
The STDDEV latency of SQL++ Composite VECTOR requests. |
Total number of DELETE operations. |
Total number of system-caused errors. |
The total number of N1QL errors returned so far. |
The total number of ffdc captures triggered due to manual invocation of ffdc admin api |
The total number of ffdc captures triggered due to free memory dropping below 10% |
The total number of ffdc captures triggered due to memory usage rate increasing by 20% of the average memory usage over the past 2 hours |
The total number of ffdc captures triggered due to memory usage exceeding the 80% threshold |
The total number of ffdc captures triggered due to the plus-request queue being full |
The total number of ffdc captures triggered due to the unbounded-request queue being full |
The total number of ffdc captures triggered due to shutdown processing exceeding 30 minutes |
The total number of ffdc captures triggered by a SIGTERM signal |
The total number of ffdc captures triggered due to no requests being processed when the queued requests exceed three times the number of servicers within the last 30 seconds |
The total number of ffdc occurrences |
Total number of SQL++ FTS Searches. |
Total number of SQL++ FTS Vetcor Searches. |
The 15m.rate latency of SQL++ Hyperscale VECTOR requests. |
The 1m.rate latency of SQL++ Hyperscale VECTOR requests. |
The 5m.rate latency of SQL++ Hyperscale VECTOR requests. |
The number of SQL++ Hyperscale VECTOR requests. |
The MAX latency of SQL++ Hyperscale VECTOR requests. |
The MEAN latency of SQL++ Hyperscale VECTOR requests. |
The mean.rate latency of SQL++ Hyperscale VECTOR requests. |
The MEDIAN latency of SQL++ Hyperscale VECTOR requests. |
The MIN latency of SQL++ Hyperscale VECTOR requests. |
The 75% latency of SQL++ Hyperscale VECTOR requests. |
The 95% latency of SQL++ Hyperscale VECTOR requests. |
The 99% latency of SQL++ Hyperscale VECTOR requests. |
The 99.9% latency of SQL++ Hyperscale VECTOR requests. |
The STDDEV latency of SQL++ Hyperscale VECTOR requests. |
Total number of secondary index scans. |
Total number of Composite VECTOR index scans. |
Total number of index scans performed by FTS. |
Total number of index scans performed by GSI. |
Total number of Hyperscale VECTOR index scans. |
Total number of sequential scans. |
Total number of INSERT operations. |
Total number of requests for unsupported endpoints. |
The current utilization factor of the servicers on the query node. |
The total load factor of the query node. |
Count of memory quota exceeded errrors |
The number of Compute Units (CUs) recorded. |
Total number of document mutations. |
The total size of document memory in use, allocated from the node-wide document memory quota. This quota is defined only when node-quota and node-quota-val-percent settings are set. |
The resident set size (RSS) of the query node process. |
The number of distinct operations recorded with Regulator. |
Total number of prepared statements executed. |
Total number of primary index scans. |
Total number of primary scans performed by FTS. |
Total number of primary scans performed by GSI. |
Total number of primary sequential scans. |
Total number of queued requests. |
The number of times Regulator instructed an operation to be rejected. |
Total end-to-end time to process all queries. |
The 15m.rate latency of SQL++ requests. |
The 1m.rate latency of SQL++ requests. |
The 5m.rate latency of SQL++ requests. |
The number of SQL++ requests. |
The MAX latency of SQL++ requests. |
The MEAN latency of SQL++ requests. |
The mean.rate latency of SQL++ requests. |
The MEDIAN latency of SQL++ requests. |
The MIN latency of SQL++ requests. |
The 75% latency of SQL++ requests. |
The 95% latency of SQL++ requests. |
The 99% latency of SQL++ requests. |
The 99.9% latency of SQL++ requests. |
The STDDEV latency of SQL++ requests. |
Total number of N1QL requests. |
Number of queries that take longer than 1000ms. |
Number of queries that take longer than 250ms. |
Number of queries that take longer than 5000ms. |
Number of queries that take longer than 500ms. |
Total number of SQL++ GSI Composite VECTOR requests. |
Total number of SQL++ GSI requests. |
Total number of SQL++ GSI Hyperscale VECTOR requests. |
Total number of SQL++ Natural Language FTSSQL requests. |
Total number of SQL++ Natural Language JSUDF requests. |
Total number of SQL++ Natural Language SQL requests. |
Total number of SQL++ Natural Language requests. |
Total number of SQL++ FTS requests. |
Total number of SQL++ FTS VECTOR requests. |
Total number of SQL++ VECTOR requests. |
Total number of results (documents) returned by the query engine. |
Total size of data returned by the query engine. |
Total number of N1QL requests with request_plus index consistency. |
Total number of SELECT requests. |
Time to execute all queries. |
Number of order by operations that have spilled to disk. |
The 15m.rate latency of SQL++ FTS VECTOR requests. |
The 1m.rate latency of SQL++ FTS VECTOR requests. |
The 5m.rate latency of SQL++ FTS VECTOR requests. |
The number of SQL++ FTS VECTOR requests. |
The MAX latency of SQL++ FTS VECTOR requests. |
The MEAN latency of SQL++ FTS VECTOR requests. |
The mean.rate latency of SQL++ FTS VECTOR requests. |
The MEDIAN latency of SQL++ FTS VECTOR requests. |
The MIN latency of SQL++ FTS VECTOR requests. |
The 75% latency of SQL++ FTS VECTOR requests. |
The 95% latency of SQL++ FTS VECTOR requests. |
The 99% latency of SQL++ FTS VECTOR requests. |
The 99.9% latency of SQL++ FTS VECTOR requests. |
The STDDEV latency of SQL++ FTS VECTOR requests. |
High water mark for temp space use. |
Count of temp space related errors |
Current temp space use. |
The total number of times KV has been throttled for queries on this tenant. |
The total amount of time KV has been throttled for queries on this tenant. |
The total size of document memory in use, allocated from the tenant-wide document memory quota. |
The total number of reads on the tenant. |
The total number of retries on the tenant. |
The total number of writes on the tenant. |
The number of times Regulator instructed an operation to throttle. |
The total time spent throttling (in seconds). |
Count of request timeout errors |
Total elapsed time of transactions so far. |
Total number of transactions. |
Count of unauthorized access errors |
Total number of N1QL requests with not_bounded index consistency. |
Total number of UPDATE requests. |
Total number of user-caused errors. |
The number of VECTOR_DISTANCE() calls made by statements. |
The total number of N1QL warnings returned so far. |