Sign in
DatabaseQueries

Get cached EXPLAIN plan for a PFS digest

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

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

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