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.
- Create a Managed Service for TimescaleDB instance.
- Make a note of the
Port
andHost
of your Managed Service for TimescaleDB instance.
Log in to your Managed Service for TimescaleDB account, and navigate to
Integration Endpoints
.In the
Integration endpoints
page, navigate toPrometheus
, and clickCreate new
.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.- In the
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: 10sevaluation_interval: 10sscrape_configs:- job_name: prometheusscheme: httpsstatic_configs:- targets: ['<HOST>:<PORT>']tls_config:insecure_skip_verify: truebasic_auth:username: <USER>password: <PASSWORD>remote_write:- url: "http://<HOST>:9201/write"remote_read:- url: "http://<HOST>:9201/read"In the Managed Service for TimescaleDB account, navigate to
Services
and select the service you want to monitor.In the
Integrations
tab, go toExternal integrations
section and selectPrometheus
.In the
Prometheus integrations
dialog, select the Prometheus endpoint that you created.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