Monitoring of cluster, nodes and PostgreSQL databases
In cloud databases PostgreSQL you can monitor the state of the cluster.
To assess the overall health of the cluster , look at the status of the cluster.
For more detailed analysis, some metrics can be viewed as graphs in the dashboard:
The full set of available metrics can be exported in Prometheus format.
You can find out if you are about to run out of disk space by using the disk fullness notification.
View cluster status
-
In the Control panel, on the top menu, click Products and select Cloud Databases.
-
Open the Active tab.
-
In the cluster row, look at the status.
View the status of the node cluster
- In the Control panel, on the top menu, click Products and select Cloud Databases.
- Open the Active tab.
- Open the cluster page → Monitoring tab.
- In the Cluster Monitoring block, click Cluster Nodes.
- In the Server field, select the node whose metrics you want to view.
- Look at the available metrics of the node cluster.
Cluster node metrics in the control panel
View the status of the databases
- In the Control panel, on the top menu, click Products and select Cloud Databases.
- Open the Active tab.
- Open the cluster page → Monitoring tab.
- In the Cluster Monitoring block, click Databases.
- In the Server field, select the node whose metrics you want to view.
- Take a look at the available database metrics.
Database metrics in the dashboard
View the status of the connection pooler
- In the Control panel, on the top menu, click Products and select Cloud Databases.
- Open the Active tab.
- Open the cluster page → Monitoring tab.
- In the Cluster Monitoring block, click Connection Pooler.
- In the Server field, select the node whose metrics you want to view.
- Look at the available metrics of the node cluster.
Connection pooler metrics in the control panel
Export metrics in Prometheus format
Historical information for clusters is not available — metrics are requested only in real time. The list of all metrics that are supported in cloud databases and their description can be viewed in the Metrics table in Prometheus format.
1. Get a token
The token gives access to the metrics of all project clusters in a single pool.
-
In the Control panel, on the top menu, click Products and select Cloud Databases.
-
Open the Active tab.
-
Open the cluster page → Monitoring tab.
-
In the Tokens for Prometheus block, click Add token. The token will be generated automatically.
-
Copy the token. To do this, click in the token line.
2. Get metrics in Prometheus format
Configuration file
CLI
-
Add to the Prometheus configuration file:
scrape_configs:
- job_name: get-metrics-from-dbaas
scrape_interval: 1m
static_configs:
- targets:
- '<pool>.dbaas.selcloud.ru'
scheme: https
authorization:
type: Bearer
credentials: <monitoring_token>Specify:
-
Open a page in your browser where Prometheus-formatted metrics will be available:
http://<ip_address>:9090/targets
Specify
<ip_address>
— the IP address where Prometheus is installed. -
Independently configure monitoring and alerts for database clusters.
-
Open the CLI.
-
To get the metrics, submit a request:
curl -L "https://<pool>.dbaas.selcloud.ru/metrics" -H "Authorization: Bearer <monitoring_token>"
Specify:
<pool>
— pool in which the token is active, for exampleru-3
. Address (URL) depends on the region and pool, you can look in the URL list;<monitoring_token>
— The monitoring token you received earlier.
Available metrics in Prometheus format will appear in the response.
-
Independently configure monitoring and alerts for database clusters.
Metrics in Prometheus format
Metrics in Prometheus format are provided for all clusters. A specific cluster can be found by the database cluster identifier in the ds_id
label.
Infrastructure level metrics
Application level metrics
Disk fullness notifications
If the cluster disk is 80% full, a notification will appear in the dashboard and will be sent to the Account Owner's email and those users subscribed to the "Services and Services" notification category.
If the cluster disk is 95% full or more, the cluster will go into status