Monitor a database
Databases publish its metrics through a Prometheus metric exposition file over the internet.
At the very bottom of the overview page of your database, you find the address for the monitoring page. Note that this page is also affected by the firewall, hence it can only be reached from the IP addresses that you've allowed. See Manage access on how to add IP addresses that are allowed to connect.
The metrics provided by the URL in the Monitoring section of the overview page are in a format called Prometheus metric exposition. This format can be ingested by tools such as InfluxDB scrapers and Prometheus itself.
Below is a short snippet of the metric data:
Ingesting the database metrics into InfluxDB
To start ingesting metrics into InfluxDB, begin by creating a new bucket. Inside InfluxDB, hover over the up-arrow icon and click Buckets.
Now, click Create bucket.
In the dialog box that appears, enter a name for the bucket. In this example, we’ll name it glesys-my-test-db. Then, click Create.
Next, click the Scrapers tab, then Create scraper.
You need to provide some information for your scraper. In this example, we name the scraper Glesys scraper my-test-db. You also need to select where the scraper should store the data—here, choose the bucket you created earlier.
In the Target URL field, enter the URL for the metrics. This URL can be found under the Monitoring section on the overview page of your database.
Everything is now set up and ready. To explore the metrics, click the graph icon to open Data Explorer.
To make things easier, toggle Switch to old Data Explorer. From here, you can click through the available metrics to visualize them.
First, select the bucket with the data; in this example, it's glesys-my-test-db. Then, choose the metrics disk_total and disk_used. In the Field column, select gauge. In the next column, switch to path and select the root path indicated by a forward slash. Finally, click Submit.
You can now hover over the graph to see exactly how much storage your database has and how much you've used.
Last updated
Was this helpful?