Set up a Prometheus endpoint

You can get more insights into the performance of your Managed Service for TimescaleDB service by monitoring it using Prometheus, a popular open source metrics-based systems monitoring solution.

Before you begin

• Create a Managed Service for TimescaleDB service.
• Make a note of the Port and Host for your MST service.

Enabling Prometheus service integration

1. Create a new Prometheus endpoint

   1. In MST Console, choose a project and navigate to Integration Endpoints. Navigate to Prometheus, and click Create new.

   2. In the Create new Prometheus endpoint dialog, complete these fields:

      • In the Endpoint name field, type a name for your endpoint.
      • In the Username field, type your username.
      • In the Password field, type your password.

   3. Click Create to create the endpoint.

   These details are used when setting up your Prometheus installation, in the prometheus.yml configuration file. This allows you to make this Managed Service for TimescaleDB endpoint a target for Prometheus to scrape.

2. Configure Prometheus

   Use this sample configuration file to set up your Prometheus installation, by substituting <PORT>, <HOST>, <USER>, and <PASSWORD> with those of your Managed Service for TimescaleDB service:

   global:
     scrape_interval:     10s
     evaluation_interval: 10s
   scrape_configs:
     - job_name: prometheus
       scheme: https
       static_configs:
         - targets: ['<HOST>:<PORT>']
       tls_config:
         insecure_skip_verify: true
       basic_auth:
         username: <USER>
         password: <PASSWORD>
   remote_write:
     - url: "http://<HOST>:9201/write"
   remote_read:
     - url: "http://<HOST>:9201/read"

3. Enable Prometheus for a service

   1. In the MST Console, navigate to Services and select the MST service you want to monitor.

   2. In the Integrations tab, go to External integrations section and select Prometheus.

   3. In the Prometheus integrations dialog, select the Prometheus endpoint that you created and click Enable.

   The Prometheus endpoint is listed under Enabled integrations for the Managed Service for TimescaleDB service.