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
• 19,600 points
833 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
• 59,170 points

Related Questions In GCP

0 votes
1 answer

How to check which user has stopped the dataflow pipeline in GCP?

You can view all Step logs for ...READ MORE

answered Mar 9 in GCP by Korak
• 4,460 points
25 views
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
• 59,170 points
250 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
• 59,170 points
233 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
• 59,170 points
207 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
• 59,170 points
967 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
• 59,170 points
404 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
Send OTP
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP