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

0 votes
I want to list the queries that have used the CPU to the max extent. How can I do this?
Nov 14 in GCP by Karan
• 6,670 points
34 views

1 answer to this question.

0 votes

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 min1 hour, or 24 hours to change the time period for the query statistics.

answered Nov 14 by Sirajul
• 40,990 points

Related Questions In GCP

0 votes
1 answer
0 votes
1 answer

What are the service accounts in GCP? How to create one?

The special accounts associated with a project are called the Service Accounts. The ...READ MORE

answered Oct 9 in GCP by Sirajul
• 40,990 points
29 views
0 votes
1 answer
0 votes
1 answer

Cancel a long running database operation.

Use projects.instances.databases.operations.cancel to cancel a long-running instance operation. Click projects.instances.databases.operations.cancel. For name, enter ...READ MORE

answered Nov 14 in GCP by anonymous
• 40,990 points
27 views
0 votes
1 answer

How to delete a long running instance operation?

Use projects.instances.operations.delete to delete a long-running instance operation. Click projects.instances.operations.delete. For name, enter ...READ MORE

answered Nov 14 in GCP by Sirajul
• 40,990 points
24 views
0 votes
1 answer

Cloud spanner instance auto-scaling

As the instance's workload changes, Cloud Spanner ...READ MORE

answered Nov 14 in GCP by Sirajul
• 40,990 points
31 views
0 votes
1 answer

Create a Cloud spanner instance.

You can create an instance with the gcloud command-line ...READ MORE

answered Nov 13 in GCP by Sirajul
• 40,990 points
30 views
0 votes
1 answer