SIsignal18
DatabaseQueries

Get cached EXPLAIN plan for a PFS digest

Changed on

Returns the explain plan that was captured at snapshot time for the given digest.

get/api/clusters/{clusterName}/servers/{serverName}/queries/{queryDigest}/actions/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

queryDigeststring required

Query Digest

Headers

Authorizationstring required

Insert your access token

Response

Cached explain plan

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