> ## Documentation Index
> Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt
> Use this file to discover all available pages before exploring further.

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.firebolt.io/feedback

```json
{
  "path": "/reference-sql/information-schema/engine-metrics-history",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

> Use this reference to learn about the resource consumption of your engine

# 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 clusters that are transient, this provides visibility into the utilization of each engine cluster. Each row represents the aggregate resource metrics for a single engine cluster at the given event time. Per default, we collect 2 metric snapshots per minute for the last 30 days. You can use a `SELECT` query to return the metrics for each engine cluster at a given point in time as shown in the example below.

```sql theme={"theme":{"light":"github-light","dark":"github-dark"}}
SELECT
  *
FROM
  information_schema.engine_metrics_history
WHERE
  event_time > now() - INTERVAL '2 hours'
LIMIT 100;
```

## Columns in information\_schema.engine\_metrics\_history

Each row has the following columns with information about each engine cluster.

| Column Name        | Data Type   | Description                                                                                |
| :----------------- | :---------- | :----------------------------------------------------------------------------------------- |
| cluster\_ordinal   | BIGINT      | the cluster number                                                                         |
| event\_time        | TIMESTAMPTZ | timestamp at which the metrics where collected                                             |
| cpu\_used          | DECIMAL     | current CPU 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                                                    |
| running\_queries   | BIGINT      | number of currently running queries in the system                                          |
| suspended\_queries | BIGINT      | number of queries that have been suspended (not-running and awaiting to be executed)       |
| evicted\_bytes     | BIGINT      | amount of data evicted from the disk in bytes                                              |
| hot\_disk\_bytes   | BIGINT      | number of bytes on disk taken by recently used tablets                                     |