---
title: "List all cached EXPLAIN plans for a server"
method: GET
path: "/api/clusters/{clusterName}/servers/{serverName}/queries/explain-pfs-cached"
tags: ["DatabaseQueries"]
---

# List all cached EXPLAIN plans for a server

`GET /api/clusters/{clusterName}/servers/{serverName}/queries/explain-pfs-cached`

Returns every explain plan stored in the server's on-disk PFS explain cache.

## Path parameters

- `clusterName` string, required
- `serverName` string, required

## Headers

- `Authorization` string, required

## Response `200`

All cached explain plans

- ClusterPFSExplainRecord[]
  - `capturedAt` string — RFC3339 timestamp of first EXPLAIN
  - `digest` string — PFS digest hash
  - `digestText` string — normalised template e.g. SELECT * FROM t WHERE id = ?
  - `sampleQuery` string — concrete SQL instance used for EXPLAIN
  - `schemaName` string

## Other responses

- `403` — No valid ACL
- `500` — Cluster Not Found" or "Server Not Found" or "Encoding error

## Changes

- **2026-07-17** `7465ea0ee21a` — 1 info
  - endpoint added
- **2023-03-31** `b57fc7b9446e` — 1 breaking
  - api path removed without deprecation

[Change history](https://skmtc.dev/signal18/apis/untitled-api/changes/api/clusters/:clusterName/servers/:serverName/queries/explain-pfs-cached/get.md)

---

[API](https://skmtc.dev/signal18/apis/untitled-api.md) · [All operations](https://skmtc.dev/signal18/apis/untitled-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/signal18/untitled-api/revisions/7465ea0ee21a/schema)