IssueTracker

Problem you have encountered: The user is using Spanner client libraries for Go to access the Spanner database and wants to get the query plan for a SELECT statement.

What you expected to happen: There should be a way to get a query plan of a select statement using golang.

This can be achieved in Node.js by using queryMode properties when running the method executeSql.

The queryMode can have three values:

NORMAL: 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 both the query plan and the execution statistics along with the results.

Other information (workarounds you have tried, documentation consulted, etc):

• https://pkg.go.dev/google.golang.org/api/spanner/v1#ExecuteSqlRequest
• https://github.com/GoogleCloudPlatform/golang-samples/blob/main/spanner/spanner_snippets/spanner/spanner_opencensus_capture_query_stats_metric.go