Introduction
TimescaleDB is an open-source time-series database optimized for fast ingest and complex queries and supporting full SQL. It is based on and functions as an extension of PostgreSQL. Full information on TimescaleDB is found in the official documentation: https://docs.timescale.com/timescaledb/latest/overview/
TimescaleDB was introduced in Control Center version 3.1.0.
Paragon Active Assurance stores time-series data (metrics) in a TimescaleDB database (hereafter referred to as the "metrics database"). You can use external reporting tools such as Grafana to query metrics from this database.
The external reporting tool must support PostgreSQL databases as a data source.
To get started, you need to:
- specify the parameters for connecting to the metrics database;
- update the metrics database configuration to allow connections from the node where the external tool is installed.
When using TimescaleDB you must be sure to allocate sufficient disk space to this database. See the recommendations in the Installation Guide, chapter Installing Required OS and Software.
In the following, we assume a scenario where an external client connects to Control Center in order to extract data from its TimescaleDB database.