What is the difference between GCP s cloud SQL database and cloud SQL instance

0 votes

I'm trying to setup some monitoring of lock times in my Posgres Database on GCP. The metric I'm trying to use is database/postgresql/insights/perquery/lock_time1.

What has confused me about this is that GCP Monitoring has said that this is available for Cloud SQL Instance Database and not Cloud SQL Database.

What is the difference and how would you monitor this in your own databases?

Mar 8, 2022 in GCP by Rahul
 • 2,120 points • 843 views

1 answer to this question.

0 votes
A Cloud SQL instance can have many databases. Your query lock time for cloud metrics is worded in a way that implies that it can return results of a particular database name inside the instance itself. I suspect this since since it says "Accumulated lock wait time per user per database as a description.
answered Mar 9, 2022 by Korak
 • 5,820 points

Related Questions In GCP

0 votes
2 answers

What is the difference between Google App Engine and Google Compute Engine?

In App Engine we have limited facility ...READ MORE

answered Dec 25, 2018 in GCP by anonymous
 • 4,153 views
0 votes
1 answer

What is the difference between boot disk and data disk in GCP (especially AI platform)

Boot disk is dedicated to the boot ...READ MORE

answered Apr 6, 2022 in GCP by Korak
 • 5,820 points • 3,622 views
0 votes
1 answer

what is the difference between BigQuery and Storage on GCP?

Both a data warehouse and a SQL ...READ MORE

answered Nov 7, 2022 in GCP by Tejashwini
 • 3,820 points • 510 views
0 votes
2 answers

Listing the pricing differences between AWS, Azure and GCP? Which cloud provider is cheaper and cost-effective ?

I wouldn’t say that there is one ...READ MORE

answered Aug 29, 2020 in GCP by nbavis
 • 380 points • 2,403 views
0 votes
1 answer

What are the libraries and tools for cloud storage on GCP?

At the center level, XML API and ...READ MORE

answered Oct 7, 2019 in GCP by Sirajul
 • 59,230 points • 1,956 views
0 votes
1 answer

Billing of my GCP instance goes down every week and increases at the start of every month. Why is this fluctauation?

The prices don't change, but an increasing ...READ MORE

answered Oct 9, 2019 in GCP by Sirajul
 • 59,230 points • 1,071 views
0 votes
1 answer

What is the best ways to keep my Google Cloud Storage bucket data safe?

There's rsync command that could be used ...READ MORE

answered Oct 16, 2019 in GCP by Sirajul
 • 59,230 points • 964 views
0 votes
1 answer

What is the need for ACL's when GCP already has Cloud IAM permissions for the same?

In most cases, Cloud Identity and Access Management ...READ MORE

answered Nov 5, 2019 in GCP by Sirajul
 • 59,230 points • 3,690 views
0 votes
1 answer

What is the difference between GCP cloud composer and workflow?

There are some key differences to consider ...READ MORE

answered Mar 17, 2022 in GCP by Korak
 • 5,820 points • 2,327 views
0 votes
1 answer

What is the difference between Google Cloud Dataflow and Google Cloud Dataproc?

Cloud Dataflow and Dataproc can both be ...READ MORE

answered Apr 6, 2022 in GCP by Korak
 • 5,820 points • 2,302 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.