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,610 points
1,018 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,190 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
• 5,820 points
64 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,190 points
296 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,190 points
290 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,190 points
252 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,190 points
1,036 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,190 points
456 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