How to check the queries which have taken the most CPU utilization

Question

I want to list the queries that have used the CPU to the max extent. How can I do this?

Answer 1

To display the recent queries that used the most CPU, follow these steps:

1. Go to the Cloud Spanner Instances page.

2. Click the name of the instance that contains your database.

3. In the Overview tab, click the name of your database. The Database details page appears.

4. Click Query stats.

   The list shows queries that had the highest total CPU usage for the complete one-minute interval that is the most recent. Below the list, the GCP Console displays the time at which the interval ended.

5. Click 10 min, 1 hour, or 24 hours to change the time period for the query statistics.