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 in GCP by Rahul
• 2,080 points
53 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 by Korak
• 5,820 points

Related Questions In GCP

0 votes
2 answers
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 in GCP by Korak
• 5,820 points
51 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,170 points
780 views
0 votes
1 answer
0 votes
1 answer
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 in GCP by Korak
• 5,820 points
145 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 in GCP by Korak
• 5,820 points
111 views
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