Query Service Metrics

  • Capella Operational
    A list of the metrics provided by the Query Service.
    Tip
    • The x.y.z badge shows the Couchbase Server version the metric was added in.

    • The type / unit badge shows shows the Prometheus type and unit (if present).

    n1ql_active_requests     7.0.0gauge

    Total number of active requests.

    n1ql_allocated_values     7.6.0counter

    The total number of values allocated in the query engine.

    n1ql_approx_vector_distance_func     8.0.0counter

    The number of APPROX_VECTOR_DISTANCE() calls made by statements.

    n1ql_at_plus     7.0.0counter

    Total number of N1QL requests with at_plus index consistency.

    n1ql_audit_actions     7.0.0counter

    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.

    n1ql_audit_actions_failed     7.0.0counter

    The total number of audit records sent to the server that failed.

    n1ql_audit_requests_filtered     7.0.0counter

    The number of potentially auditable requests that cause no audit action to be taken.

    n1ql_audit_requests_total     7.0.0counter

    The total number of potentially auditable requests sent to the query engine.

    n1ql_boot_timestamp_seconds     7.6.0gauge / seconds

    The time the service booted in fractional seconds since Unix epoch.

    n1ql_bucket_reads     7.6.0gauge

    The total number of reads on the bucket.

    n1ql_bucket_retries     7.6.0gauge

    The total number of retries on the bucket.

    n1ql_bucket_writes     7.6.0gauge

    The total number of writes on the bucket.

    n1ql_bulk_get_errors     7.2.4counter

    Count of errors due to bulk get operations

    n1ql_cancelled     7.0.0counter

    Total number of cancelled requests.

    n1ql_cas_mismatch_errors     7.2.4counter

    Count of CAS mismatch errors

    n1ql_counter_cu_total     7.6.0counter / seconds

    The number of distinct operations recording Compute Units (CUs) with Regulator.

    n1ql_credit_cu_total     7.6.0counter / seconds

    The number of Compute Units (CUs) refunded.

    n1ql_credit_ru_total     7.6.0counter / seconds

    The number of Read Units (RUs) refunded.

    n1ql_credit_wu_total     7.6.0counter / seconds

    The number of Write Units (WUs) refunded.

    n1ql_curl_call_errors     7.6.2counter

    The number of CURL() calls made by statements that failed (returned an error).

    n1ql_curl_calls     7.6.2counter

    The number of CURL() calls made by statements.

    n1ql_cvi_request_timer_15m_rate     8.0.0gauge

    The 15m.rate latency of SQL++ Composite VECTOR requests.

    n1ql_cvi_request_timer_1m_rate     8.0.0gauge

    The 1m.rate latency of SQL++ Composite VECTOR requests.

    n1ql_cvi_request_timer_5m_rate     8.0.0gauge

    The 5m.rate latency of SQL++ Composite VECTOR requests.

    n1ql_cvi_request_timer_count     8.0.0gauge

    The number of SQL++ Composite VECTOR requests.

    n1ql_cvi_request_timer_max     8.0.0gauge

    The MAX latency of SQL++ Composite VECTOR requests.

    n1ql_cvi_request_timer_mean     8.0.0gauge

    The MEAN latency of SQL++ Composite VECTOR requests.

    n1ql_cvi_request_timer_mean_rate     8.0.0gauge

    The mean.rate latency of SQL++ Composite VECTOR requests.

    n1ql_cvi_request_timer_median     8.0.0gauge

    The MEDIAN latency of SQL++ Composite VECTOR requests.

    n1ql_cvi_request_timer_min     8.0.0gauge

    The MIN latency of SQL++ Composite VECTOR requests.

    n1ql_cvi_request_timer_p75     8.0.0gauge

    The 75% latency of SQL++ Composite VECTOR requests.

    n1ql_cvi_request_timer_p95     8.0.0gauge

    The 95% latency of SQL++ Composite VECTOR requests.

    n1ql_cvi_request_timer_p99     8.0.0gauge

    The 99% latency of SQL++ Composite VECTOR requests.

    n1ql_cvi_request_timer_p99point9     8.0.0gauge

    The 99.9% latency of SQL++ Composite VECTOR requests.

    n1ql_cvi_request_timer_stddev     8.0.0gauge

    The STDDEV latency of SQL++ Composite VECTOR requests.

    n1ql_deletes     7.0.0counter

    Total number of DELETE operations.

    n1ql_engine_error_count     8.0.0counter

    Total number of system-caused errors.

    n1ql_errors     7.0.0counter

    The total number of N1QL errors returned so far.

    n1ql_ffdc_manual     7.6.6counter

    The total number of ffdc captures triggered due to manual invocation of ffdc admin api

    n1ql_ffdc_memory_limit     7.6.6counter

    The total number of ffdc captures triggered due to free memory dropping below 10%

    n1ql_ffdc_memory_rate     7.6.6counter

    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

    n1ql_ffdc_memory_threshold     7.6.6counter

    The total number of ffdc captures triggered due to memory usage exceeding the 80% threshold

    n1ql_ffdc_plus_queue_full     7.6.6counter

    The total number of ffdc captures triggered due to the plus-request queue being full

    n1ql_ffdc_request_queue_full     7.6.6counter

    The total number of ffdc captures triggered due to the unbounded-request queue being full

    n1ql_ffdc_shutdown     7.6.6counter

    The total number of ffdc captures triggered due to shutdown processing exceeding 30 minutes

    n1ql_ffdc_sigterm     7.6.6counter

    The total number of ffdc captures triggered by a SIGTERM signal

    n1ql_ffdc_stalled_queue     7.6.6counter

    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

    n1ql_ffdc_total     7.6.6counter

    The total number of ffdc occurrences

    n1ql_fts_searches     8.0.0counter

    Total number of SQL++ FTS Searches.

    n1ql_fts_searches_svi     8.0.0counter

    Total number of SQL++ FTS Vetcor Searches.

    n1ql_hvi_request_timer_15m_rate     8.0.0gauge

    The 15m.rate latency of SQL++ Hyperscale VECTOR requests.

    n1ql_hvi_request_timer_1m_rate     8.0.0gauge

    The 1m.rate latency of SQL++ Hyperscale VECTOR requests.

    n1ql_hvi_request_timer_5m_rate     8.0.0gauge

    The 5m.rate latency of SQL++ Hyperscale VECTOR requests.

    n1ql_hvi_request_timer_count     8.0.0gauge

    The number of SQL++ Hyperscale VECTOR requests.

    n1ql_hvi_request_timer_max     8.0.0gauge

    The MAX latency of SQL++ Hyperscale VECTOR requests.

    n1ql_hvi_request_timer_mean     8.0.0gauge

    The MEAN latency of SQL++ Hyperscale VECTOR requests.

    n1ql_hvi_request_timer_mean_rate     8.0.0gauge

    The mean.rate latency of SQL++ Hyperscale VECTOR requests.

    n1ql_hvi_request_timer_median     8.0.0gauge

    The MEDIAN latency of SQL++ Hyperscale VECTOR requests.

    n1ql_hvi_request_timer_min     8.0.0gauge

    The MIN latency of SQL++ Hyperscale VECTOR requests.

    n1ql_hvi_request_timer_p75     8.0.0gauge

    The 75% latency of SQL++ Hyperscale VECTOR requests.

    n1ql_hvi_request_timer_p95     8.0.0gauge

    The 95% latency of SQL++ Hyperscale VECTOR requests.

    n1ql_hvi_request_timer_p99     8.0.0gauge

    The 99% latency of SQL++ Hyperscale VECTOR requests.

    n1ql_hvi_request_timer_p99point9     8.0.0gauge

    The 99.9% latency of SQL++ Hyperscale VECTOR requests.

    n1ql_hvi_request_timer_stddev     8.0.0gauge

    The STDDEV latency of SQL++ Hyperscale VECTOR requests.

    n1ql_index_scans     7.0.0counter

    Total number of secondary index scans.

    n1ql_index_scans_cvi     8.0.0counter

    Total number of Composite VECTOR index scans.

    n1ql_index_scans_fts     7.2.4counter

    Total number of index scans performed by FTS.

    n1ql_index_scans_gsi     7.2.4counter

    Total number of index scans performed by GSI.

    n1ql_index_scans_hvi     8.0.0counter

    Total number of Hyperscale VECTOR index scans.

    n1ql_index_scans_seq     7.6.0counter

    Total number of sequential scans.

    n1ql_inserts     7.0.0counter

    Total number of INSERT operations.

    n1ql_invalid_requests     7.0.0counter

    Total number of requests for unsupported endpoints.

    n1ql_load     7.0.0gauge

    The current utilization factor of the servicers on the query node.

    n1ql_load_factor     7.6.0gauge

    The total load factor of the query node.

    n1ql_mem_quota_exceeded_errors     7.2.4counter

    Count of memory quota exceeded errrors

    n1ql_meter_cu_total     7.6.0counter / seconds

    The number of Compute Units (CUs) recorded.

    n1ql_mutations     7.0.0counter

    Total number of document mutations.

    n1ql_node_memory     7.6.0gauge / bytes

    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.

    n1ql_node_rss     7.6.1gauge / bytes

    The resident set size (RSS) of the query node process.

    n1ql_op_count_total     7.6.0counter / seconds

    The number of distinct operations recorded with Regulator.

    n1ql_prepared     7.0.0counter

    Total number of prepared statements executed.

    n1ql_primary_scans     7.0.0counter

    Total number of primary index scans.

    n1ql_primary_scans_fts     7.2.4counter

    Total number of primary scans performed by FTS.

    n1ql_primary_scans_gsi     7.2.4counter

    Total number of primary scans performed by GSI.

    n1ql_primary_scans_seq     7.6.0counter

    Total number of primary sequential scans.

    n1ql_queued_requests     7.0.0gauge

    Total number of queued requests.

    n1ql_reject_count_total     7.6.0counter / seconds

    The number of times Regulator instructed an operation to be rejected.

    n1ql_request_time     7.0.0counter / nanoseconds

    Total end-to-end time to process all queries.

    n1ql_request_timer_15m_rate     8.0.0gauge

    The 15m.rate latency of SQL++ requests.

    n1ql_request_timer_1m_rate     8.0.0gauge

    The 1m.rate latency of SQL++ requests.

    n1ql_request_timer_5m_rate     8.0.0gauge

    The 5m.rate latency of SQL++ requests.

    n1ql_request_timer_count     8.0.0gauge

    The number of SQL++ requests.

    n1ql_request_timer_max     8.0.0gauge

    The MAX latency of SQL++ requests.

    n1ql_request_timer_mean     8.0.0gauge

    The MEAN latency of SQL++ requests.

    n1ql_request_timer_mean_rate     8.0.0gauge

    The mean.rate latency of SQL++ requests.

    n1ql_request_timer_median     8.0.0gauge

    The MEDIAN latency of SQL++ requests.

    n1ql_request_timer_min     8.0.0gauge

    The MIN latency of SQL++ requests.

    n1ql_request_timer_p75     8.0.0gauge

    The 75% latency of SQL++ requests.

    n1ql_request_timer_p95     8.0.0gauge

    The 95% latency of SQL++ requests.

    n1ql_request_timer_p99     8.0.0gauge

    The 99% latency of SQL++ requests.

    n1ql_request_timer_p99point9     8.0.0gauge

    The 99.9% latency of SQL++ requests.

    n1ql_request_timer_stddev     8.0.0gauge

    The STDDEV latency of SQL++ requests.

    n1ql_requests     7.0.0counter

    Total number of N1QL requests.

    n1ql_requests_1000ms     7.0.0counter

    Number of queries that take longer than 1000ms.

    n1ql_requests_250ms     7.0.0counter

    Number of queries that take longer than 250ms.

    n1ql_requests_5000ms     7.0.0counter

    Number of queries that take longer than 5000ms.

    n1ql_requests_500ms     7.0.0counter

    Number of queries that take longer than 500ms.

    n1ql_requests_cvi     8.0.0counter

    Total number of SQL++ GSI Composite VECTOR requests.

    n1ql_requests_gsi     8.0.0counter

    Total number of SQL++ GSI requests.

    n1ql_requests_hvi     8.0.0counter

    Total number of SQL++ GSI Hyperscale VECTOR requests.

    n1ql_requests_natural_ftssql     8.0.0counter

    Total number of SQL++ Natural Language FTSSQL requests.

    n1ql_requests_natural_jsudf     8.0.0counter

    Total number of SQL++ Natural Language JSUDF requests.

    n1ql_requests_natural_sql     8.0.0counter

    Total number of SQL++ Natural Language SQL requests.

    n1ql_requests_natural_total     8.0.0counter

    Total number of SQL++ Natural Language requests.

    n1ql_requests_search     8.0.0counter

    Total number of SQL++ FTS requests.

    n1ql_requests_svi     8.0.0counter

    Total number of SQL++ FTS VECTOR requests.

    n1ql_requests_vector     8.0.0counter

    Total number of SQL++ VECTOR requests.

    n1ql_result_count     7.0.0counter

    Total number of results (documents) returned by the query engine.

    n1ql_result_size     7.0.0counter / bytes

    Total size of data returned by the query engine.

    n1ql_scan_plus     7.0.0counter

    Total number of N1QL requests with request_plus index consistency.

    n1ql_selects     7.0.0counter

    Total number of SELECT requests.

    n1ql_service_time     7.0.0counter / nanoseconds

    Time to execute all queries.

    n1ql_spills_order     8.0.0counter

    Number of order by operations that have spilled to disk.

    n1ql_svi_request_timer_15m_rate     8.0.0gauge

    The 15m.rate latency of SQL++ FTS VECTOR requests.

    n1ql_svi_request_timer_1m_rate     8.0.0gauge

    The 1m.rate latency of SQL++ FTS VECTOR requests.

    n1ql_svi_request_timer_5m_rate     8.0.0gauge

    The 5m.rate latency of SQL++ FTS VECTOR requests.

    n1ql_svi_request_timer_count     8.0.0gauge

    The number of SQL++ FTS VECTOR requests.

    n1ql_svi_request_timer_max     8.0.0gauge

    The MAX latency of SQL++ FTS VECTOR requests.

    n1ql_svi_request_timer_mean     8.0.0gauge

    The MEAN latency of SQL++ FTS VECTOR requests.

    n1ql_svi_request_timer_mean_rate     8.0.0gauge

    The mean.rate latency of SQL++ FTS VECTOR requests.

    n1ql_svi_request_timer_median     8.0.0gauge

    The MEDIAN latency of SQL++ FTS VECTOR requests.

    n1ql_svi_request_timer_min     8.0.0gauge

    The MIN latency of SQL++ FTS VECTOR requests.

    n1ql_svi_request_timer_p75     8.0.0gauge

    The 75% latency of SQL++ FTS VECTOR requests.

    n1ql_svi_request_timer_p95     8.0.0gauge

    The 95% latency of SQL++ FTS VECTOR requests.

    n1ql_svi_request_timer_p99     8.0.0gauge

    The 99% latency of SQL++ FTS VECTOR requests.

    n1ql_svi_request_timer_p99point9     8.0.0gauge

    The 99.9% latency of SQL++ FTS VECTOR requests.

    n1ql_svi_request_timer_stddev     8.0.0gauge

    The STDDEV latency of SQL++ FTS VECTOR requests.

    n1ql_temp_hwm     8.0.0counter

    High water mark for temp space use.

    n1ql_temp_space_errors     7.6.0counter

    Count of temp space related errors

    n1ql_temp_usage     8.0.0gauge

    Current temp space use.

    n1ql_tenant_kv_throttle_count     7.6.0gauge

    The total number of times KV has been throttled for queries on this tenant.

    n1ql_tenant_kv_throttle_seconds_total     7.6.0gauge / seconds

    The total amount of time KV has been throttled for queries on this tenant.

    n1ql_tenant_memory     7.6.0gauge / bytes

    The total size of document memory in use, allocated from the tenant-wide document memory quota.

    n1ql_tenant_reads     7.6.0gauge

    The total number of reads on the tenant.

    n1ql_tenant_retries     7.6.0gauge

    The total number of retries on the tenant.

    n1ql_tenant_writes     7.6.0gauge

    The total number of writes on the tenant.

    n1ql_throttle_count_total     7.6.0counter / seconds

    The number of times Regulator instructed an operation to throttle.

    n1ql_throttle_seconds_total     7.6.0counter / seconds

    The total time spent throttling (in seconds).

    n1ql_timeouts     7.2.4counter

    Count of request timeout errors

    n1ql_transaction_time     7.0.0counter / nanoseconds

    Total elapsed time of transactions so far.

    n1ql_transactions     7.0.0counter

    Total number of transactions.

    n1ql_unauthorized_users     7.2.4counter

    Count of unauthorized access errors

    n1ql_unbounded     7.0.0counter

    Total number of N1QL requests with not_bounded index consistency.

    n1ql_updates     7.0.0counter

    Total number of UPDATE requests.

    n1ql_user_error_count     8.0.0counter

    Total number of user-caused errors.

    n1ql_vector_distance_func     8.0.0counter

    The number of VECTOR_DISTANCE() calls made by statements.

    n1ql_warnings     7.0.0counter

    The total number of N1QL warnings returned so far.