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,080 points
302 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
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
891 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,470 points
87 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,210 points
1,171 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, 2022 in GCP by Korak
• 5,820 points
984 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
1,095 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