Monitoring of cluster, nodes and PostgreSQL databases
In cloud databases PostgreSQL you can monitor the status of the cluster.
To assess the overall state of the cluster check his status..
For more detailed analysis, some metrics can be viewed as graphs in the dashboard:
The full set of available metrics can be export in Prometheus format.
You can find out if your disk is about to run out of space by using disk fill notifications.
View cluster status
- В control panels go to Cloud platform → Databases.
- In the cluster row, look at the status.
View the status of the node cluster
- В control panels go to Cloud platform → Databases.
- Open the cluster page → tab Monitoring.
- In the block Monitoring of cluster servers click Cluster servers.
- In the field Server select the node whose metrics you want to view.
- See what's available node cluster metrics.
Cluster node metrics in the control panel
View the status of the databases
- В control panels go to Cloud platform → Databases.
- Open the cluster page → tab Monitoring.
- In the block Monitoring of cluster servers click Databases.
- In the field Server select the node whose metrics you want to view.
- See what's available database metrics.
Database metrics in the dashboard
View the status of the connection pooler
- В control panels go to Cloud platform → Databases.
- Open the cluster page → tab Monitoring.
- In the block Monitoring of cluster servers click Connection Pooler.
- In the field Server select the node whose metrics you want to view.
- See what's available node cluster metrics.
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 seen in the following table Metrics in Prometheus format.
Get a token
The token gives access to the metrics of all clusters project in one bullet.
-
В control panels go to Cloud platform → Databases.
-
Open the cluster page → tab Monitoring.
-
In the block Tokens for Prometheus click Add token. The token will be generated automatically.
-
Copy the token. To do this, in the token row, click .
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>
— 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 valid, e.g.ru-3
. The address (URL) depends on the region and pool, you can look in the URL list;<monitoring_token>
— a monitoring token that you received Previously.
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 label ds_id
.
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 email of the Account Owner and those users subscribed to the the "Services and services" notification category.
If the cluster disk is 95% full or more, the cluster will go into status DISK_FULL
and will be read-only. To make the cluster read-write, disk cleanup or scale the cluster and select a configuration with a larger disk size.