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

  1. Log in to your Managed Service for TimescaleDB account, and navigate to Integration Endpoints.

  2. In the Integration endpoints page, navigate to Prometheus, and click Create new.

  3. 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.
    • 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.

  4. 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 instance:

    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"
  5. In the Managed Service for TimescaleDB account, navigate to Services and select the service you want to monitor.

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

  7. In the Prometheus integrations dialog, select the Prometheus endpoint that you created.

  8. Click Enable.

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

Next, use Promscale with Timescale, Grafana, and Prometheus to ingest and analyze Prometheus metrics from your Managed Service for TimescaleDB instance.

Found an issue on this page?

Report an issue!

Keywords

Related Content