Sign in
DatabaseQueries

List all cached EXPLAIN plans for a server

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

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

Path parameters

clusterNamestring required

Cluster Name

serverNamestring required

Server Name

Headers

Authorizationstring required

Insert your access token

Response

All cached explain plans

capturedAtstring

RFC3339 timestamp of first EXPLAIN

digeststring

PFS digest hash

digestTextstring

normalised template e.g. SELECT * FROM t WHERE id = ?

sampleQuerystring

concrete SQL instance used for EXPLAIN

schemaNamestring

Changes

Changed in 2 of the 5 revisions of this API.11