GCP Cloud SQL for PostgreSQL OpenTelemetry Assets
| Version | 0.1.0
|
| Subscription level What's this? |
Basic |
| Developed by What's this? |
Elastic |
| Minimum Kibana version(s) | 9.6.0 |
To use pre-release integrations, go to the Integrations page in Kibana, scroll down, and toggle on the Display beta integrations option.
This package contains Kibana assets for monitoring Cloud SQL for PostgreSQL instances with Google Cloud Monitoring metrics collected by the OpenTelemetry Collector.
The package is content only. It does not configure data collection. Use the Google Cloud Monitoring (OpenTelemetry) input package (googlecloudmonitor_input_otel) to collect Cloud SQL for PostgreSQL metrics into Elasticsearch.
You need Elasticsearch for storing and searching your data and Kibana for visualizing and managing it. You can use our hosted Elasticsearch Service on Elastic Cloud, which is recommended, or self-manage the Elastic Stack on your own hardware.
Install the Google Cloud Monitoring OpenTelemetry Input package (googlecloudmonitor_input_otel) and configure it to collect Cloud SQL for PostgreSQL Cloud Monitoring metrics (for example, cloudsql.googleapis.com/database/cpu/utilization). This content package provides assets that visualize data collected by that input.
When configuring the input package, set the dataset name to gcp.cloudsql_postgresql.otel so that data is written to the metrics-gcp.cloudsql_postgresql.otel-default data stream, which these dashboards query.
| Dashboard | Description |
|---|---|
| [GCP OTel] Cloud SQL PostgreSQL Overview | Overview of all Cloud SQL for PostgreSQL instances. Availability, saturation (CPU, memory, disk, connections), throughput, and transaction ID wraparound risk across the fleet. |
| [GCP OTel] Cloud SQL PostgreSQL Instance Detail | Detail view of a single Cloud SQL for PostgreSQL instance. Covers availability, capacity, traffic and errors, connections, I/O and cache, vacuum and wraparound, and Query Insights. |
This integration includes one or more Kibana dashboards that visualizes the data collected by the integration. The screenshots below illustrate how the ingested data is displayed.
Changelog
| Version | Details | Minimum Kibana version |
|---|---|---|
| 0.1.0 | Enhancement (View pull request) Initial draft of the GCP Cloud SQL for PostgreSQL OpenTelemetry Assets package. |
9.6.0 |