---
title: "Check every materialized view was refreshed recently"
method: GET
path: "/v4/materialized-views/health"
tags: ["Health"]
---

# Check every materialized view was refreshed recently

`GET /v4/materialized-views/health`

## Request

- Base URL: `https://api.merkl.xyz` (the document declares no server; this is the origin it was published from)
- URL: `https://api.merkl.xyz/v4/materialized-views/health`
- Auth: `apiKey` (a scheme the document does not define)

Always returns HTTP 200. `status` is `STALE` when any materialized view refreshed by the `refresh-materialized-views` job has no refresh in the last 45 minutes (the job runs every 20 minutes), or has never recorded one. `OK` otherwise. Configure a keyword monitor to alert when `STALE` is present.

## Response `200`

Response for status 200

- object
  - `status` union, required
    - string
    - string
  - `success` boolean, required
  - `viewsChecked` number, required
  - `staleViews` number, required
  - `detail` string
  - `runbook` object
    - `impact` string, required
    - `remediation` string, required
    - `escalation` string

## Changes

- **2026-10-13** `4207c9b739f0`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/merkl/apis/merkl-api/changes/v4/materialized-views/health/get.md)

---

[API](https://skmtc.dev/merkl/apis/merkl-api.md) - [All operations](https://skmtc.dev/merkl/apis/merkl-api/llms.txt) - [OpenAPI document](https://skmtc.dev/merkl/apis/merkl-api/revisions/60ffe2c7d887?raw)