Link Search Menu Expand Document

Information schema for engine metrics history

You can use the information_schema.engine_metrics_history view to return information about the resource consumption of your engine. As engines can have 1 or more engine units that are transient, this provides visibilty into the utilization of each engine unit. Each rows represents the aggregate resource metrics for a single engine unit at the given event time. You can use a SELECT query to return the metrics for each engine unit at a given point in time as shown in the example below.

SELECT
  *
FROM
  information_schema.engine_metrics_history
LIMIT
  where event_time > now() - INTERVAL '2 hours'

Columns in information_schema.engine_metrics_history

Each row has the following columns with information about each query in query history.

Column Name Data Type Description
engine_cluster TEXT engine cluster identifier
event_time TIMESTAMPTZ timestamp at which the metrics where collected
cpu_used DECIMAL current utilization (percentage)
memory_used DECIMAL current memory used (percentage)
disk_used DECIMAL currently used disk space which encompasses space used for cache and spilling (percentage)
cache_hit_ratio DECIMAL current SSD cache hit ratio
spilled_bytes BIGINT amount of spilled data to disk in bytes