Integrate Prometheus with Tiger Cloud

Export telemetry metrics from Tiger Cloud services to Prometheus for pull-based monitoring, alerting with PromQL, and time-series data visualization.

Prometheus is an open-source monitoring system with a dimensional data model, flexible query language, and a modern alerting approach.

This page shows you how to export your telemetry to Prometheus:

• For , using a dedicated Prometheus exporter in .
• For , using Postgres Exporter.

Prerequisites

To follow the steps on this page:

• Download and run Prometheus.

• For :

  Create a target with the time-series and analytics capability enabled.

• For :

  • Create a target instance. You need your connection details.
  • Install Postgres Exporter. To reduce latency and potential data transfer costs, install Prometheus and Postgres Exporter on a machine in the same AWS region as your .

This feature is currently not supported for on Microsoft Azure.

Export Tiger Cloud service telemetry to Prometheus

To export your data, do the following:

To export metrics from a , you create a dedicated Prometheus exporter in , attach it to your , then configure Prometheus to scrape metrics using the exposed URL. The Prometheus exporter exposes the metrics related to the like CPU, memory, and storage. To scrape other metrics, use Postgres Exporter as described for . The Prometheus exporter is available for and s.

1. Create a Prometheus exporter

   1. In , click Exporters > + New exporter.

   2. Select Metrics for data type and Prometheus for provider.

      

   3. Choose the region for the exporter. Only s in the same project and region can be attached to this exporter.

   4. Name your exporter.

   5. Change the auto-generated Prometheus credentials, if needed. See official documentation on basic authentication in Prometheus.

      

2. Attach the exporter to a

   1. Select a , then click Operations > Exporters.

   2. Select the exporter in the drop-down, then click Attach exporter.

      

      The exporter is now attached to your . To unattach it, click the trash icon in the exporter list.

      

3. Configure the Prometheus scrape target

   1. Select your service, then click Operations > Exporters and click the information icon next to the exporter. You see the exporter details.

      

   2. Copy the exporter URL.

   3. In your Prometheus installation, update prometheus.yml to point to the exporter URL as a scrape target:

      scrape_configs:
       - job_name: "timescaledb-exporter"
         scheme: https
         static_configs:
           - targets: ["my-exporter-url"]
         basic_auth:
           username: "user"
           password: "pass"
      

      See the Prometheus documentation for details on configuring scrape targets.

      You can now monitor your metrics. Use the following metrics to check the service is running correctly:

      • timescale.cloud.system.cpu.usage.millicores
      • timescale.cloud.system.cpu.total.millicores
      • timescale.cloud.system.memory.usage.bytes
      • timescale.cloud.system.memory.total.bytes
      • timescale.cloud.system.disk.usage.bytes
      • timescale.cloud.system.disk.total.bytes

      Additionally, use the following tags to filter your results.

      Tag	Example variable	Description
      host	us-east-1.timescale.cloud
      project-id
      service-id
      region	us-east-1	AWS region
      role	replica or primary	For with replicas

You can further visualize your data with Grafana. Use the Grafana Postgres dashboard or create a custom dashboard that suits your needs.