SIsignal18
DatabaseQueries

List all cached EXPLAIN plans for a server

Changed on

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

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

Request

  • The document declares no server URL.
  • Auth
    none declared. Required headers: Authorization

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