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?