​
Overview

Metrics play a crucial role in monitoring and analyzing the performance of Oxla, enabling users to gain valuable insights into their data processing and analytics workflows. The metrics are specific to a single node.

This documentation will guide you on how to access and leverage the metrics.

All metrics exposed by Oxla have a label_node_id with a node ID set. This is the same node_id that can be found in logs and on data storage.

​
Accessing Metrics

Once you have successfully deployed Oxla, you can access the comprehensive metrics that provide valuable insights into the performance and health of your database. To access the metrics, follow the steps below:

  1. Open your preferred web browser and enter the following URL: 
<ip>:8080/metrics
  1. Replace <ip> with the actual IP address of your Oxla deployment. For example, if your Oxla instance is hosted on IP address 128.128.1.1, the URL would be:
128.128.1.1:8080/metrics
  1. If you are running Oxla locally on your machine, you can use localhost as the IP address. In that case, the URL would be:
localhost:8080/metrics
  1. Upon accessing the URL, you will be presented with various metrics as shown below: 
# HELP exposer_transferred_bytes_total Transferred bytes to metrics services
# TYPE exposer_transferred_bytes_total counter
exposer_transferred_bytes_total 0
# HELP exposer_scrapes_total Number of times metrics were scraped
# TYPE exposer_scrapes_total counter
exposer_scrapes_total 0
# HELP exposer_request_latencies Latencies of serving scrape requests, in microseconds
# TYPE exposer_request_latencies summary
exposer_request_latencies_count 0
exposer_request_latencies_sum 0
exposer_request_latencies{quantile="0.5"} Nan
exposer_request_latencies{quantile="0.9"} Nan
exposer_request_latencies{quantile="0.99"} Nan
# HELP oxla_net_postgres_client_queries_count Number of queries received from clients
# TYPE oxla_net_postgres_client_queries_count counter
oxla_net_postgres_client_queries_count{_node_id="oxla_node_1",query_type="SELECT"} 0
oxla_net_postgres_client_queries_count{_node_id="oxla_node_1",query_type="COPY"} 0
oxla_net_postgres_client_queries_count{_node_id="oxla_node_1",query_type="INSERT"} 0
oxla_net_postgres_client_queries_count{_node_id="oxla_node_1"} 0
# HELP oxla_net_postgres_client_queries_successful_count Number of successful queries received from clients
# TYPE oxla_net_postgres_client_queries_successful_count counter
oxla_net_postgres_client_queries_successful_count{_node_id="oxla_node_1",query_type="SELECT"} 0
oxla_net_postgres_client_queries_successful_count{_node_id="oxla_node_1",query_type="COPY"} 0
oxla_net_postgres_client_queries_successful_count{_node_id="oxla_node_1",query_type="INSERT"} 0
oxla_net_postgres_client_queries_successful_count{_node_id="oxla_node_1"} 0
# HELP oxla_net_postgres_client_queries_failed_count Number of failed queries received from clients
# TYPE oxla_net_postgres_client_queries_failed_count counter
oxla_net_postgres_client_queries_failed_count{_node_id="oxla_node_1",error_type="OTHER"} 0
oxla_net_postgres_client_queries_failed_count{_node_id="oxla_node_1",error_type="CANCELED"} 0
oxla_net_postgres_client_queries_failed_count{_node_id="oxla_node_1",error_type="EXECUTION ERROR"} 0
oxla_net_postgres_client_queries_failed_count{_node_id="oxla_node_1"} 0
# HELP oxla_net_postgres_command_count Number of queries received from clients
# TYPE oxla_net_postgres_command_count counter
oxla_net_postgres_command_count{_node_id="oxla_node_1",query_type="TERMINATE"} 0
oxla_net_postgres_command_count{_node_id="oxla_node_1",query_type="EXECUTE"} 0
oxla_net_postgres_command_count{_node_id="oxla_node_1",query_type="DESCRIBE"} 0
oxla_net_postgres_command_count{_node_id="oxla_node_1",query_type="BIND"} 0
oxla_net_postgres_command_count{_node_id="oxla_node_1",query_type="SYNC"} 0
oxla_net_postgres_command_count{_node_id="oxla_node_1",query_type="PARSE"} 0
oxla_net_postgres_command_count{_node_id="oxla_node_1",query_type="QUERY"} 0
oxla_net_postgres_command_count{_node_id="oxla_node_1"} 0
# HELP oxla_net_postgres_nonlocalhost_connections_count Total number of non localhost cennections
# TYPE oxla_net_postgres_nonlocalhost_connections_count counter
oxla_net_postgres_nonlocalhost_connections_count{_node_id="oxla_node_1"} 0
# HELP receipts_received_total Number of data task receipts received being executed on the node
# TYPE receipts_received_total counter
receipts_received_total{_node_id="oxla_node_1",receipts_status="rejected",scheduler_role="leader"} 0
receipts_received_total{_node_id="oxla_node_1",receipts_status="accepted",scheduler_role="leader"} 0
receipts_received_total{_node_id="oxla_node_1",receipts_status="rejected",scheduler_role="inserter"} 0
receipts_received_total{_node_id="oxla_node_1",receipts_status="accepted",scheduler_role="inserter"} 0
# HELP file_flushed_total Number of files flushed when inserting rows
# TYPE file_flushed_total counter
file_flushed_total{_node_id="oxla_node_1"} 0
# HELP tasks_executed_total Number of tasks executed on a node
# TYPE tasks_executed_total counter
tasks_executed_total{_node_id="oxla_node_1",file_task_type="compact",scheduler_role="leader",task_status="failed"} 0
tasks_executed_total{_node_id="oxla_node_1",file_task_type="compact",scheduler_role="leader",task_status="succeeded"} 0
tasks_executed_total{_node_id="oxla_node_1",file_task_type="merge",scheduler_role="inserter",task_status="succeeded"} 0
tasks_executed_total{_node_id="oxla_node_1",file_task_type="compact",scheduler_role="inserter",task_status="succeeded"} 0
tasks_executed_total{_node_id="oxla_node_1",file_task_type="merge",scheduler_role="leader",task_status="succeeded"} 0
tasks_executed_total{_node_id="oxla_node_1",file_task_type="merge",scheduler_role="leader",task_status="failed"} 0
tasks_executed_total{_node_id="oxla_node_1",file_task_type="merge",scheduler_role="inserter",task_status="failed"} 0
tasks_executed_total{_node_id="oxla_node_1",file_task_type="compact",scheduler_role="inserter",task_status="failed"} 0
# HELP tasks_result_received_total Number of tasks results received on a node
# TYPE tasks_result_received_total counter
tasks_result_received_total{_node_id="oxla_node_1",file_task_type="merge",receiver_role="leader",task_status="canceled"} 0
tasks_result_received_total{_node_id="oxla_node_1",file_task_type="compact",receiver_role="leader",task_status="canceled"} 0
tasks_result_received_total{_node_id="oxla_node_1",file_task_type="compact",receiver_role="leader",task_status="succeeded"} 0
tasks_result_received_total{_node_id="oxla_node_1",file_task_type="merge",receiver_role="leader",task_status="failed"} 0
tasks_result_received_total{_node_id="oxla_node_1",file_task_type="compact",receiver_role="leader",task_status="failed"} 0
tasks_result_received_total{_node_id="oxla_node_1",file_task_type="merge",receiver_role="inserter",task_status="succeeded"} 0
tasks_result_received_total{_node_id="oxla_node_1",file_task_type="merge",receiver_role="inserter",task_status="failed"} 0
tasks_result_received_total{_node_id="oxla_node_1",file_task_type="compact",receiver_role="inserter",task_status="canceled"} 0
tasks_result_received_total{_node_id="oxla_node_1",file_task_type="merge",receiver_role="leader",task_status="succeeded"} 0
tasks_result_received_total{_node_id="oxla_node_1",file_task_type="merge",receiver_role="inserter",task_status="canceled"} 0
tasks_result_received_total{_node_id="oxla_node_1",file_task_type="compact",receiver_role="inserter",task_status="succeeded"} 0
tasks_result_received_total{_node_id="oxla_node_1",file_task_type="compact",receiver_role="inserter",task_status="failed"} 0
# HELP tasks_received_total Number of task a node has received to be executed
# TYPE tasks_received_total counter
tasks_received_total{_node_id="oxla_node_1",file_task_type="compact",scheduler_role="leader",was_accepted="rejected"} 0
tasks_received_total{_node_id="oxla_node_1",file_task_type="merge",scheduler_role="leader",was_accepted="rejected"} 0
tasks_received_total{_node_id="oxla_node_1",file_task_type="merge",scheduler_role="leader",was_accepted="accepted"} 0
tasks_received_total{_node_id="oxla_node_1",file_task_type="compact",scheduler_role="inserter",was_accepted="rejected"} 0
tasks_received_total{_node_id="oxla_node_1",file_task_type="compact",scheduler_role="leader",was_accepted="accepted"} 0
tasks_received_total{_node_id="oxla_node_1",file_task_type="merge",scheduler_role="inserter",was_accepted="rejected"} 0
tasks_received_total{_node_id="oxla_node_1",file_task_type="compact",scheduler_role="inserter",was_accepted="accepted"} 0
tasks_received_total{_node_id="oxla_node_1",file_task_type="merge",scheduler_role="inserter",was_accepted="accepted"} 0
# HELP tasks_scheduled_total Number of task the leader has send to nodes and are being executed
# TYPE tasks_scheduled_total counter
tasks_scheduled_total{_node_id="oxla_node_1",file_task_type="compact"} 0
tasks_scheduled_total{_node_id="oxla_node_1",file_task_type="merge"} 0
# HELP thread_pool_tasks_finished_total Number of tasks finished by the thread pool
# TYPE thread_pool_tasks_finished_total counter
thread_pool_tasks_finished_total{_node_id="oxla_node_1"} 0
# HELP thread_pool_tasks_started_total Number of tasks started by the thread pool
# TYPE thread_pool_tasks_started_total counter
thread_pool_tasks_started_total{_node_id="oxla_node_1"} 33
# HELP readers_closed_total Total number of readers closed since Oxla process creation
# TYPE readers_closed_total counter
readers_closed_total{_node_id="oxla_node_1"} 0
# HELP readers_opened_total Total number of readers opened since Oxla process creation
# TYPE readers_opened_total counter
readers_opened_total{_node_id="oxla_node_1"} 0
# HELP writers_closed_total Total number of writers closed since Oxla process creation
# TYPE writers_closed_total counter
writers_closed_total{_node_id="oxla_node_1"} 4
# HELP writers_opened_total Total number of writers opened since Oxla process creation
# TYPE writers_opened_total counter
writers_opened_total{_node_id="oxla_node_1"} 4
# HELP aws_requests Type and state of requests sent to the aws s3
# TYPE aws_requests counter
aws_requests{_node_id="oxla_node_1",state="succeeded",type="LIST"} 0
aws_requests{_node_id="oxla_node_1",state="retry",type="POST"} 0
aws_requests{_node_id="oxla_node_1",state="failed",type="POST"} 0
aws_requests{_node_id="oxla_node_1",state="started",type="POST"} 0
aws_requests{_node_id="oxla_node_1",state="started",type="GET"} 0
aws_requests{_node_id="oxla_node_1",state="finished",type="GET"} 0
aws_requests{_node_id="oxla_node_1",state="started",type="LIST"} 0
aws_requests{_node_id="oxla_node_1",state="failed",type="DELETE"} 0
aws_requests{_node_id="oxla_node_1",state="succeeded",type="POST"} 0
aws_requests{_node_id="oxla_node_1",state="retry",type="PUT"} 0
aws_requests{_node_id="oxla_node_1",state="failed",type="LIST"} 0
aws_requests{_node_id="oxla_node_1",state="retry",type="HEAD"} 0
aws_requests{_node_id="oxla_node_1",state="succeeded",type="PUT"} 0
aws_requests{_node_id="oxla_node_1",state="finished",type="DELETE"} 0
aws_requests{_node_id="oxla_node_1",state="started",type="PUT"} 0
aws_requests{_node_id="oxla_node_1",state="finished",type="HEAD"} 0
aws_requests{_node_id="oxla_node_1",state="retry",type="LIST"} 0
aws_requests{_node_id="oxla_node_1",state="finished",type="LIST"} 0
aws_requests{_node_id="oxla_node_1",state="succeeded",type="GET"} 0
aws_requests{_node_id="oxla_node_1",state="failed",type="PUT"} 0
aws_requests{_node_id="oxla_node_1",state="failed",type="GET"} 0
aws_requests{_node_id="oxla_node_1",state="succeeded",type="HEAD"} 0
aws_requests{_node_id="oxla_node_1",state="retry",type="GET"} 0
aws_requests{_node_id="oxla_node_1",state="started",type="DELETE"} 0
aws_requests{_node_id="oxla_node_1",state="finished",type="PUT"} 0
aws_requests{_node_id="oxla_node_1",state="retry",type="DELETE"} 0
aws_requests{_node_id="oxla_node_1",state="finished",type="POST"} 0
aws_requests{_node_id="oxla_node_1",state="failed",type="HEAD"} 0
aws_requests{_node_id="oxla_node_1",state="succeeded",type="DELETE"} 0
aws_requests{_node_id="oxla_node_1",state="started",type="HEAD"} 0
# HELP s3_connections_finished_total Number of s3 connections finished
# TYPE s3_connections_finished_total counter
s3_connections_finished_total{_node_id="oxla_node_1"} 0
# HELP s3_connections_started_total Number of s3 connections started
# TYPE s3_connections_started_total counter
s3_connections_started_total{_node_id="oxla_node_1"} 0
# HELP file_cache_use_total Number of hits and misses on our file cache
# TYPE file_cache_use_total counter
file_cache_use_total{_node_id="oxla_node_1",use_type="cant_get_descriptor"} 0
file_cache_use_total{_node_id="oxla_node_1",use_type="miss"} 4
file_cache_use_total{_node_id="oxla_node_1",use_type="hit_on_retry"} 0
file_cache_use_total{_node_id="oxla_node_1",use_type="hit"} 0
# HELP oxla_net_postgres_connections Number of clients connected using the postgres protocol
# TYPE oxla_net_postgres_connections gauge
oxla_net_postgres_connections{_node_id="oxla_node_1"} 0
# HELP oxla_net_postgres_last_nonlocalhost_connection Last non local host connection
# TYPE oxla_net_postgres_last_nonlocalhost_connection gauge
oxla_net_postgres_last_nonlocalhost_connection{_node_id="oxla_node_1"} 0
# HELP oxla_net_postgres_last_nonlocalhost_disconnection Last non local host disconnection
# TYPE oxla_net_postgres_last_nonlocalhost_disconnection gauge
oxla_net_postgres_last_nonlocalhost_disconnection{_node_id="oxla_node_1"} 0
# HELP oxla_net_postgres_last_query_finished Last query finished
# TYPE oxla_net_postgres_last_query_finished gauge
oxla_net_postgres_last_query_finished{_node_id="oxla_node_1"} 0
# HELP oxla_net_postgres_last_query_started Last query started
# TYPE oxla_net_postgres_last_query_started gauge
oxla_net_postgres_last_query_started{_node_id="oxla_node_1"} 0
# HELP oxla_net_postgres_queries_ongoing Number of currently running queries
# TYPE oxla_net_postgres_queries_ongoing gauge
oxla_net_postgres_queries_ongoing{_node_id="oxla_node_1"} 0
# HELP cluster_has_leader_bool Is true iff cluster has a leader.
# TYPE cluster_has_leader_bool gauge
cluster_has_leader_bool{_node_id="oxla_node_1"} 1
# HELP current_max_capacity Current max capacity per node
# TYPE current_max_capacity gauge
current_max_capacity{_node_id="oxla_node_1"} 32
# HELP num_nodes_connected Number of nodes connected
# TYPE num_nodes_connected gauge
num_nodes_connected{_node_id="oxla_node_1"} 1
# HELP node_is_degraded_bool Is true if node is degraded
# TYPE node_is_degraded_bool gauge
node_is_degraded_bool{_node_id="oxla_node_1"} 0
# HELP node_is_leader_bool Is true iff node is a leader.
# TYPE node_is_leader_bool gauge
node_is_leader_bool{_node_id="oxla_node_1"} 1
# HELP num_open_connections Number of open connections (StateHandler instances)
# TYPE num_open_connections gauge
num_open_connections{_node_id="oxla_node_1"} 2
# HELP tasks_ongoing_total Number of task currently being executed on the node
# TYPE tasks_ongoing_total gauge
tasks_ongoing_total{_node_id="oxla_node_1",file_task_type="merge",scheduler_role="leader"} 0
tasks_ongoing_total{_node_id="oxla_node_1",file_task_type="compact",scheduler_role="leader"} 0
tasks_ongoing_total{_node_id="oxla_node_1",file_task_type="merge",scheduler_role="inserter"} 0
tasks_ongoing_total{_node_id="oxla_node_1",file_task_type="compact",scheduler_role="inserter"} 0
# HELP thread_pool_size_total Number of threads used by the thread pool
# TYPE thread_pool_size_total gauge
thread_pool_size_total{_node_id="oxla_node_1"} 33
# HELP file_flush_duration_ms how long does it take to flush a file
# TYPE file_flush_duration_ms histogram
file_flush_duration_ms_count{_node_id="oxla_node_1"} 0
file_flush_duration_ms_sum{_node_id="oxla_node_1"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="10"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="20"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="30"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="40"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="50"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="60"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="70"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="80"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="90"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="100"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="110"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="125"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="150"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="200"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="250"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="300"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="400"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="500"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="600"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="700"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="750"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="800"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="900"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="1000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="1500"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="2000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="2500"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="3000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="3500"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="4000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="5000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="6000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="7000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="8000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="9000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="10000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="15000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="20000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="30000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="40000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="50000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="60000"} 0
file_flush_duration_ms_bucket{_node_id="oxla_node_1",le="+Inf"} 0
# HELP oxla_jemalloc_mallctl_stats Information about jemalloc internal statistics via mallctl*
# TYPE oxla_jemalloc_mallctl_stats gauge
oxla_jemalloc_mallctl_stats{elem="stats.allocated",_node_id="oxla_node_1"} 10005776
oxla_jemalloc_mallctl_stats{elem="stats.active",_node_id="oxla_node_1"} 11104256
oxla_jemalloc_mallctl_stats{elem="stats.metadata",_node_id="oxla_node_1"} 12341008
oxla_jemalloc_mallctl_stats{elem="stats.metadata_thp",_node_id="oxla_node_1"} 0
oxla_jemalloc_mallctl_stats{elem="stats.resident",_node_id="oxla_node_1"} 23797760
oxla_jemalloc_mallctl_stats{elem="stats.mapped",_node_id="oxla_node_1"} 77090816
oxla_jemalloc_mallctl_stats{elem="stats.retained",_node_id="oxla_node_1"} 58699776
oxla_jemalloc_mallctl_stats{elem="stats.arenas.all.small.allocated",_node_id="oxla_node_1"} 5045520
oxla_jemalloc_mallctl_stats{elem="stats.arenas.all.small.nmalloc",_node_id="oxla_node_1"} 54779
oxla_jemalloc_mallctl_stats{elem="stats.arenas.all.small.ndalloc",_node_id="oxla_node_1"} 7901
oxla_jemalloc_mallctl_stats{elem="stats.arenas.all.large.allocated",_node_id="oxla_node_1"} 4960256
oxla_jemalloc_mallctl_stats{elem="stats.arenas.all.large.nmalloc",_node_id="oxla_node_1"} 76
oxla_jemalloc_mallctl_stats{elem="stats.arenas.all.large.ndalloc",_node_id="oxla_node_1"} 27
oxla_jemalloc_mallctl_stats{elem="stats.arenas.all.dead.small.allocated",_node_id="oxla_node_1"} 0
oxla_jemalloc_mallctl_stats{elem="stats.arenas.all.dead.small.nmalloc",_node_id="oxla_node_1"} 0
oxla_jemalloc_mallctl_stats{elem="stats.arenas.all.dead.small.ndalloc",_node_id="oxla_node_1"} 0
oxla_jemalloc_mallctl_stats{elem="stats.arenas.all.dead.large.allocated",_node_id="oxla_node_1"} 0
oxla_jemalloc_mallctl_stats{elem="stats.arenas.all.dead.large.nmalloc",_node_id="oxla_node_1"} 0
oxla_jemalloc_mallctl_stats{elem="stats.arenas.all.dead.large.ndalloc",_node_id="oxla_node_1"} 0
# HELP oxla_memory_usage_bytes Memory used by Oxla
# TYPE oxla_memory_usage_bytes gauge
oxla_memory_usage_bytes{value="memory_consumption_total",_node_id="oxla_node_1"} 33554432
oxla_memory_usage_bytes{value="orphaned_memory_consumption_total",_node_id="oxla_node_1"} 0
oxla_memory_usage_bytes{value="cache_memory_consumption_total",_node_id="oxla_node_1"} 33554432
oxla_memory_usage_bytes{value="cache_memory_total_evictions",_node_id="oxla_node_1"} 0
oxla_memory_usage_bytes{value="query_memory_consumption_total",_node_id="oxla_node_1"} 0
oxla_memory_usage_bytes{value="privileged_query_memory_consumption_total",_node_id="oxla_node_1"} 0
oxla_memory_usage_bytes{value="privileged_tag",_node_id="oxla_node_1"} 65535
oxla_memory_usage_bytes{value="tags_in_use",_node_id="oxla_node_1"} 0
oxla_memory_usage_bytes{value="memory_limit_total",_node_id="oxla_node_1"} 60381200384

The following is a list of parameters available in the Public Metrics:

ParametersDescription
exposer_prefixThe component responsible for exposing metrics.
exposer_transferred_bytes_totalTotal size of bytes transferred out by the endpoint.
exposer_scrapes_totalNumber of times metrics were scraped.
exposer_request_latenciesLatencies of serving scrape requests, in microseconds.
exposer_request_latencies_countCount of latencies.
exposer_request_latencies_sumSum of latencies.
client_sql_successful_queries_totalNumber of successful queries received from clients.
The available queries are:
- label="COPY", successful COPY queries.
- label="SELECT", successful SELECT queries.
- label="INSERT", successful INSERT queries.
The available label is query_type.
client_sql_queries_totalNumber of queries received from clients.
The available queries are:
- label="COPY", total COPY queries.
- label="SELECT", total SELECT queries.
- label="INSERT", total INSERT queries.
The available label is query_type.
file_flushed_totalNumber of files flushed when inserting rows.
tasks_executed_totalNumber of tasks executed on the cluster.
tasks_received_totalNumber of tasks a node has received to be executed.
The available task types are:
- file_task_type="compact", total compact tasks received.
- file_task_type="merge", total merge tasks received.
tasks_scheduled_totalNumber of tasks the leader has sent to nodes and are being executed.
The available task types are:
- file_task_type="compact", total compact tasks scheduled.
- file_task_type="merge", total merge tasks scheduled.
thread_pool_tasks_finished_totalNumber of tasks finished by the thread pool.
thread_pool_tasks_started_totalNumber of tasks started by the thread pool.
readers_closed_totalTotal number of readers closed since Oxla process creation.
readers_opened_totalTotal number of readers opened since Oxla process creation.
writers_closed_totalTotal number of writers closed since Oxla process creation.
writers_opened_totalTotal number of writers opened since Oxla process creation.
cluster_has_leader_boolIndicates if the cluster has a leader or not.
num_nodes_connectedNumber of nodes connected.
node_is_leader_boolIndicates if the node is a leader.
num_open_connectionsNumber of open connections.
postgres_connections_totalNumber of clients connected using the Postgres protocol.
tasks_capacity_totalNumber of task capacity on the cluster.
tasks_ongoing_totalNumber of tasks currently being executed on the node.
The available task types are:
- file_task_type="compact", total ongoing compact tasks.
- file_task_type="merge", total ongoing merge tasks.
thread_pool_size_totalNumber of threads used by the thread pool.
oxla_memory_usage_bytesMemory used by Oxla.
The available values are:
- value="system_memory_consumption_total", total system memory consumption.
- value="cache_memory_consumption_total", total cache memory consumption.
- value="query_memory_consumption_total", total query memory consumption.
oxla_mallinfoInformation about glibc’s malloc() internal state.
s3_connections_startedNumber of S3 connections started.
s3_connections_finishedNumber of S3 connections finished.
tasks_result_receivedNumber of task results received.
oxla_net_postgres_connections_countTotal number of network connections.
oxla_net_postgres_nonlocalhost_connections_countnumber of active non-localhost connections.
oxla_net_postgres_queries_ongoingNumber of currently running client queries.
oxla_net_postgres_command_countTotal number of commands.
oxla_net_postgres_last_nonlocalhost_connectionTimestamp of last non-localhost connection event [In seconds].
oxla_net_postgres_last_nonlocalhost_disconnectionTimestamp of last non-localhost disconnection event [In seconds]
oxla_net_postgres_last_query_finishedTimestamp of last client query finished event [In seconds].
oxla_net_postgres_last_query_startedTimestamp of last client query started event [In seconds].
By regularly monitoring these metrics, you can gain valuable insights into the efficiency of your database operations, identify potential bottlenecks, and make data-driven optimizations to enhance the overall performance and reliability of your analytical workflows.
Handling Oxla Degraded StateOxla Configuration File