You can get more insights into the performance of your managed TimescaleDB database by monitoring it using Prometheus, a popular open-source metrics-based systems monitoring solution. This tutorial takes you through setting up a Prometheus endpoint for a database running in a managed service for TimescaleDB. To create a monitoring system to ingest and analyze Prometheus metrics from your managed TimescaleDB instance, you can use Promscale!

This exposes metrics from the node_exporter as well as pg_stats metrics.

In order to proceed with this tutorial, you need a managed service for TimescaleDB database. To create one, see these instructions for how to get started with managed service for TimescaleDB

In the navigation bar, select 'Service Integrations'. Navigate to the service integrations, pictured below.

Service Integrations Menu Option

This presents you with the option to add a Prometheus integration point. Select the plus icon to add a new endpoint and give it a name of your choice. We've named ours endpoint_dev.

Create a Prometheus endpoint on Timescale Cloud

Furthermore, notice that you are given basic authentication information and a port number in order to access the service. This is used when setting up your Prometheus installation, in the prometheus.yml configuration file. This enables you to make this managed TimescaleDB endpoint a target for Prometheus to scrape.

Here's a sample configuration file you can use when you setup your Prometheus installation, substituting the target port, IP address, username, and password for those of your managed TimescaleDB instance:

# prometheus.yml for monitoring a Timescale Cloud instance
scrape_interval: 10s
evaluation_interval: 10s
- job_name: prometheus
scheme: https
- targets: ['{TARGET_IP}:{TARGET_PORT}']
insecure_skip_verify: true
- url: "http://{ADAPTER_IP}:9201/write"
- url: "http://{ADAPTER_IP}:9201/read"

Next, we want to associate our Prometheus endpoint with our Timescale managed service. Using the navigation menu, select the service we want to monitor and click the 'Overview' tab.

Navigate down to the 'Service Integrations' section and click the 'Manage Integrations' button.

Manage Service integrations on your managed service

Find the Prometheus integration option and select 'Use Prometheus'.

Select Prometheus integration to integrate with

Next, select the endpoint name you created in Step 1 as the endpoint you'd like to use with this service and then click the 'Enable' button. It's possible to use the same endpoint for multiple services or a separate one for services you'd like to keep apart.

Select name of Prometheus endpoint to integrate with

To check if this was successful, navigate back to the Service Integrations section of your managed service, and check if that "Active" flag appears, along with the name of the endpoint you associated the service with.

Success! Active prometheus endpoint with name

Congratulations, you have successfully set up a Prometheus endpoint on your managed service on managed service for TimescaleDB!

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

Found an issue on this page?

Report an issue!


Related Content