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, 2019 in GCP by Karan
• 10,310 points
110 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, 2019 by Sirajul
• 54,240 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, 2019 in GCP by Sirajul
• 54,240 points
56 views
0 votes
1 answer

How to enable the GKE usage metering?

To enable GKE usage metering, you first create ...READ MORE

answered Oct 17, 2019 in GCP by Sirajul
• 54,240 points
381 views
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, 2019 in GCP by anonymous
• 54,240 points
56 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, 2019 in GCP by Sirajul
• 54,240 points
48 views
0 votes
1 answer

Cloud spanner instance auto-scaling

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

answered Nov 14, 2019 in GCP by Sirajul
• 54,240 points
328 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, 2019 in GCP by Sirajul
• 54,240 points
139 views
0 votes
1 answer