The default mode. Only the statement results are returned.
Plan
This mode returns only the query plan, without any results or
execution statistics information.
Profile
This mode returns the query plan, overall execution statistics,
operator level execution statistics along with the results. This has a
performance overhead compared to the other modes. It is not recommended
to use this mode for production traffic.
WithPlanAndStats
This mode returns the query plan, overall (but not operator-level)
execution statistics along with the results.
WithStats
This mode returns the overall (but not operator-level) execution
statistics along with the results.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["\u003cp\u003eThe latest version available for \u003ccode\u003eExecuteSqlRequest.Types.QueryMode\u003c/code\u003e is 5.0.0-beta05, which can be found within the Google Cloud Spanner v1 API.\u003c/p\u003e\n"],["\u003cp\u003eThis API enum, \u003ccode\u003eExecuteSqlRequest.Types.QueryMode\u003c/code\u003e, controls how SQL statements are processed, offering various modes like \u003ccode\u003eNormal\u003c/code\u003e, \u003ccode\u003ePlan\u003c/code\u003e, \u003ccode\u003eProfile\u003c/code\u003e, \u003ccode\u003eWithPlanAndStats\u003c/code\u003e, and \u003ccode\u003eWithStats\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eProfile\u003c/code\u003e query mode provides detailed execution statistics but has a performance overhead, making it unsuitable for production traffic.\u003c/p\u003e\n"],["\u003cp\u003eThere are multiple versions of the \u003ccode\u003eExecuteSqlRequest.Types.QueryMode\u003c/code\u003e available, ranging from version 3.5.0 to 5.0.0-beta05, each accessible through different URLs.\u003c/p\u003e\n"],["\u003cp\u003eThe default query mode \u003ccode\u003eNormal\u003c/code\u003e will only return the results of the statement.\u003c/p\u003e\n"]]],[],null,[]]