Integrate Prometheus with Timescale Cloud

Create a user to access telemetry data about your Timescale Cloud service

1. Connect to your Timescale Cloud service:

   For Timescale Cloud, open an SQL editor in Timescale Console. For self-hosted, use psql.

2. Create a user named monitoring with a secure password:

   CREATE USER monitoring WITH PASSWORD '<password>';

   Copy

3. Grant the pg_read_all_stats permission to the monitoring user:

   GRANT pg_read_all_stats to monitoring;

   Copy

Import telemetry data about your Timescale Cloud service to PostgreSQL Exporter

1. Connect PostgreSQL Exporter to your Timescale Cloud service:

   Use your connection details to import telemetry data about your Timescale Cloud service. You connect as the monitoring user:

   • Local installation:

     export DATA_SOURCE_NAME="postgres://monitoring:<password>@<host>.tsdb.cloud.timescale.com:<port>/tsdb?sslmode=require"
     ./postgres_exporter

     Copy
   • Docker:

     docker run -d \ 
        -e DATA_SOURCE_NAME="postgres://monitoring:<password>@<host>.tsdb.cloud.timescale.com:<port>/tsdb?sslmode=require" \ 
        -p 9187:9187 \ 
        prometheuscommunity/postgres-exporter

     Copy

2. Check the metrics for your Timescale Cloud service in the Prometheus format:

   • Browser:

     Navigate to http://<exporter-host>:9187/metrics.

   • Command line:

     curl http://<exporter-host>:9187/metrics

     Copy

Configure Prometheus to scrape metrics

1. In your Prometheus installation, update prometheus.yml to point to your PostgreSQL Exporter instance as a scrape target. In the following example, you replace <exporter-host> with the hostname or IP address of the PostgreSQL Exporter.

   global:
     scrape_interval: 15s
   
   scrape_configs:
   - job_name: 'postgresql'
     static_configs:
      - targets: ['<exporter-host>:9187']

   Copy

   If prometheus.yml has not been created during installation, create it manually. If you are using Docker, you can find the IPAddress in Inspect > Networks for the container running PostgreSQL Exporter.

2. Restart Prometheus.

3. Check the Prometheus UI at http://<prometheus-host>:9090/targets and http://<prometheus-host>:9090/tsdb-status.

   You see the PostgreSQL Exporter target and the metrics scraped from it.