How to find out what index Cloud Spanner is using to process a query

Question

I have a cloud spanner instance along with its own database that is somewhere around 1.7TB. How do I  find out what index Cloud Spanner is using to process a query?

Answer 1

To find out what index Cloud Spanner is using to process a query, view the query execution plan in the Google Cloud Platform Console:

1. Go to the Cloud Spanner Instances page in the GCP Console.

2. Click the name of the instance you want to query.

3. In the left pane, click the database you want to query, then click search Query.

4. Enter the query to test.

5. In the Run query drop-down list, select Explanation only. Cloud Spanner displays the query plan.

If you need to know more about Cloud Computing, We recommend joining Cloud Computing Training today.