Reference documentation and code samples for the Cloud Spanner V1 Client class QueryMode.
Mode in which the statement must be processed.
Protobuf type google.spanner.v1.ExecuteSqlRequest.QueryMode
Namespace
Google \ Cloud \ Spanner \ V1 \ ExecuteSqlRequest
Methods
static::name
Parameter
Name
Description
value
mixed
static::value
Parameter
Name
Description
name
mixed
Constants
NORMAL
Value: 0
The default mode. Only the statement results are returned.
Generated from protobuf enum NORMAL = 0;
PLAN
Value: 1
This mode returns only the query plan, without any results or
execution statistics information.
Generated from protobuf enum PLAN = 1;
PROFILE
Value: 2
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.
Generated from protobuf enum PROFILE = 2;
WITH_STATS
Value: 3
This mode returns the overall (but not operator-level) execution
statistics along with the results.
Generated from protobuf enum WITH_STATS = 3;
WITH_PLAN_AND_STATS
Value: 4
This mode returns the query plan, overall (but not operator-level)
execution statistics along with the results.
Generated from protobuf enum WITH_PLAN_AND_STATS = 4;
[[["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-09-04 UTC."],[],[],null,["# Cloud Spanner V1 Client - Class QueryMode (1.104.0)\n\nVersion latestkeyboard_arrow_down\n\n- [1.104.0 (latest)](/php/docs/reference/cloud-spanner/latest/V1.ExecuteSqlRequest.QueryMode)\n- [1.103.0](/php/docs/reference/cloud-spanner/1.103.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.102.0](/php/docs/reference/cloud-spanner/1.102.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.101.0](/php/docs/reference/cloud-spanner/1.101.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.100.0](/php/docs/reference/cloud-spanner/1.100.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.98.0](/php/docs/reference/cloud-spanner/1.98.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.97.0](/php/docs/reference/cloud-spanner/1.97.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.96.0](/php/docs/reference/cloud-spanner/1.96.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.95.0](/php/docs/reference/cloud-spanner/1.95.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.94.0](/php/docs/reference/cloud-spanner/1.94.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.93.1](/php/docs/reference/cloud-spanner/1.93.1/V1.ExecuteSqlRequest.QueryMode)\n- [1.92.1](/php/docs/reference/cloud-spanner/1.92.1/V1.ExecuteSqlRequest.QueryMode)\n- [1.91.0](/php/docs/reference/cloud-spanner/1.91.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.90.0](/php/docs/reference/cloud-spanner/1.90.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.89.0](/php/docs/reference/cloud-spanner/1.89.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.88.0](/php/docs/reference/cloud-spanner/1.88.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.87.0](/php/docs/reference/cloud-spanner/1.87.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.86.0](/php/docs/reference/cloud-spanner/1.86.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.85.0](/php/docs/reference/cloud-spanner/1.85.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.84.0](/php/docs/reference/cloud-spanner/1.84.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.83.0](/php/docs/reference/cloud-spanner/1.83.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.82.0](/php/docs/reference/cloud-spanner/1.82.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.81.0](/php/docs/reference/cloud-spanner/1.81.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.80.0](/php/docs/reference/cloud-spanner/1.80.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.79.0](/php/docs/reference/cloud-spanner/1.79.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.78.0](/php/docs/reference/cloud-spanner/1.78.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.77.0](/php/docs/reference/cloud-spanner/1.77.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.76.1](/php/docs/reference/cloud-spanner/1.76.1/V1.ExecuteSqlRequest.QueryMode)\n- [1.68.0](/php/docs/reference/cloud-spanner/1.68.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.67.0](/php/docs/reference/cloud-spanner/1.67.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.66.0](/php/docs/reference/cloud-spanner/1.66.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.65.0](/php/docs/reference/cloud-spanner/1.65.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.64.0](/php/docs/reference/cloud-spanner/1.64.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.63.2](/php/docs/reference/cloud-spanner/1.63.2/V1.ExecuteSqlRequest.QueryMode)\n- [1.62.1](/php/docs/reference/cloud-spanner/1.62.1/V1.ExecuteSqlRequest.QueryMode)\n- [1.61.0](/php/docs/reference/cloud-spanner/1.61.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.60.0](/php/docs/reference/cloud-spanner/1.60.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.59.0](/php/docs/reference/cloud-spanner/1.59.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.58.4](/php/docs/reference/cloud-spanner/1.58.4/V1.ExecuteSqlRequest.QueryMode)\n- [1.57.0](/php/docs/reference/cloud-spanner/1.57.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.56.0](/php/docs/reference/cloud-spanner/1.56.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.55.0](/php/docs/reference/cloud-spanner/1.55.0/V1.ExecuteSqlRequest.QueryMode)\n- [1.54.2](/php/docs/reference/cloud-spanner/1.54.2/V1.ExecuteSqlRequest.QueryMode) \nReference documentation and code samples for the Cloud Spanner V1 Client class QueryMode.\n\nMode in which the statement must be processed.\n\nProtobuf type `google.spanner.v1.ExecuteSqlRequest.QueryMode`\n\nNamespace\n---------\n\nGoogle \\\\ Cloud \\\\ Spanner \\\\ V1 \\\\ ExecuteSqlRequest\n\nMethods\n-------\n\n### static::name\n\n### static::value\n\nConstants\n---------\n\n### NORMAL\n\n Value: 0\n\nThe default mode. Only the statement results are returned.\n\nGenerated from protobuf enum `NORMAL = 0;`\n\n### PLAN\n\n Value: 1\n\nThis mode returns only the query plan, without any results or\nexecution statistics information.\n\nGenerated from protobuf enum `PLAN = 1;`\n\n### PROFILE\n\n Value: 2\n\nThis mode returns the query plan, overall execution statistics,\noperator level execution statistics along with the results. This has a\nperformance overhead compared to the other modes. It is not recommended\nto use this mode for production traffic.\n\nGenerated from protobuf enum `PROFILE = 2;`\n\n### WITH_STATS\n\n Value: 3\n\nThis mode returns the overall (but not operator-level) execution\nstatistics along with the results.\n\nGenerated from protobuf enum `WITH_STATS = 3;`\n\n### WITH_PLAN_AND_STATS\n\n Value: 4\n\nThis mode returns the query plan, overall (but not operator-level)\nexecution statistics along with the results.\n\nGenerated from protobuf enum `WITH_PLAN_AND_STATS = 4;`"]]