---
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

---

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