Monitoring of PostgreSQL cluster and databases for 1C

Last update: May 28 2025

Monitoring of PostgreSQL cluster and databases for 1C

In PostgreSQL cloud databases for 1C, 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:

• node cluster metrics;
• database metrics;
• coupling pooler metrics.

The full set of available metrics can be exported in Prometheus format.

You can tell if you are about to run out of disk space by using the disk fullness notification. When notified , clear the disk or scale the cluster and select a configuration with a larger disk size.

View cluster status⁠

1. In the Control panel, on the top menu, click Products and select Cloud Databases.
2. Open the Active tab.
3. In the cluster row, look at the status.

ACTIVE	The cluster is available
CREATING	A cluster is created
UPDATING	Changes are applied to the cluster
RESIZING	The cluster is scalable
ERROR	There was an error, create a ticket
DISK FULL	The disk is full and the cluster is read-only. To make the cluster read-write, clear the disk or scale the cluster and select a configuration with a larger disk size
DEGRADED	Some nodes in the cluster are unavailable
DELETING	The cluster is being deleted

View the status of the node cluster⁠

1. In the Control panel, on the top menu, click Products and select Cloud Databases.
2. Open the Active tab.
3. Open the cluster page → Monitoring tab.
4. In the Cluster Monitoring block, click Cluster Nodes.
5. In the Server field, select the node whose metrics you want to view.
6. Look at the available metrics of the node cluster.

Cluster node metrics in the control panel⁠

vCPU	How many percent of the node cluster cores are utilized
CPU iowait	How much percent of the processor's time was spent waiting for I/O
Memory	Memory utilization excluding cache and operating system buffers in percent or gigabytes
Disk	Used disk space in percent or gigabytes. The file system reserves 4% of the disk space for service needs, so the space occupied is greater than the actual space used by this 4%
Network load	The number of bits or packets sent and received over the network interface
Disk, read and write speed	Data read speed in B/s and data write speed in KB/s
Disk, number of IOPS	Number of read and write operations per second
OOM	Number of processes that ended with an Out of Memory error due to lack of RAM
Load Average	The average value of system load over a period of time. Indicates how many processes are processed by the cluster cores.The indicator is presented in the form of three values — for one minute, five minutes and 15 minutes. These values should not be greater than the number of cores on the node

View the status of the databases⁠

1. In the Control panel, on the top menu, click Products and select Cloud Databases.
2. Open the Active tab.
3. Open the cluster page → Monitoring tab.
4. In the Cluster Monitoring block, click Databases.
5. In the Server field, select the node whose database metrics you want to view.
6. Take a look at the available database metrics.

Database metrics in the dashboard⁠

Connections	Number of connections to each cluster database and total number of connections to all databases
Execution time of the longest query	Execution time of the longest query in each database of the cluster for a period of time
Transactions	Number of transactions per second in each cluster database
Cache hit	What percentage of the data in the query was read from the cache — the ratio of blks_hit to the sum of blks_hit and blks_read
Locks	Number of locks in each cluster database
Deadlocks	Number of mutual locks in each database
Database size	Total size of the selected database in megabytes
Statistics file size	Total size of the statistics file in kilobytes
Size of WAL files	Total size of WAL files in megabytes
Temporary file size	Total size of temporary files in kilobytes
String operations	The number of operations in the selected database per second: tup_deleted — number of rows deleted by queries in the database per second; tup_fetched — number of rows retrieved by queries in the database per second; tup_inserted — number of rows inserted by database queries per second; tup_returned — number of rows returned by database queries per second; tup_updated — number of rows modified by queries in the database per second

View the status of the connection pooler⁠

1. In the Control panel, on the top menu, click Products and select Cloud Databases.
2. Open the Active tab.
3. Open the cluster page → Monitoring tab.
4. In the Cluster Monitoring block, click Connection Pooler.
5. In the Server field, select the node whose metrics you want to view.
6. Look at the available metrics of the node cluster.

Connection pooler metrics in the control panel⁠

Client connections to the pool	The number of client connections to the pool in the selected database: pools_client_active_connections — number of client connections associated with server connections or idle without requests; pools_client_waiting_connections — number of client connections where a request has been sent but no connection to the node has yet been established
Active connections to the server	Number of server connections associated with clients in the selected database
Waiting time for a response from the server	Time to wait for a response from a node in the selected database in seconds
Maximum waiting time of the client in the queue	Maximum waiting time of the client in the queue in the selected database in seconds

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.
2. Get the metrics in Prometheus format.

1. Get a token⁠

The token gives access to the metrics of all project clusters in a single pool.

1. In the Control panel, on the top menu, click Products and select Cloud Databases.

2. Open the Active tab.

3. Open the cluster page → Monitoring tab.

4. In the Tokens for Prometheus block, click Add token. The token will be generated automatically.

5. Copy the token. To do this, click in the token line.

2. Get metrics in Prometheus format⁠

Configuration file

1. 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:

   • <pool> — pool in which the token is active, for example ru-3. Address (URL) depends on the region and pool, you can look in the URL list;
   • <monitoring_token> — The monitoring token that you received earlier.

2. 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.

3. Independently configure monitoring and alerts for database clusters.

CLI

1. Open the CLI.

2. To get 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 example ru-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.

3. 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

dbaas_memory_percent	Memory utilization excluding cache and operating system buffers (RAM) in percent
dbaas_memory_bytes	Occupied memory excluding cache and operating system buffers (RAM) in bytes
dbaas_oom_count	Number of processes that terminated with an Out of Memory error due to lack of RAM
dbaas_cpu	Percent vCPU utilization on database cluster nodes
dbaas_cpu_iowait	I/O waiting time in percent
dbaas_disk_percent	Percentage of disk space occupied. The file system reserves 4% of disk space for service needs, so the occupied space is larger than the actual space used by this 4%
dbaas_disk_bytes	Occupied disk space in bytes. The file system reserves 4% of disk space for service needs, so the occupied space is larger than the actual space used by this 4%
dbaas_disk_read_iops	Number of read operations per second
dbaas_disk_write_iops	Number of recording operations per second
dbaas_disk_read_bytes	Disk read speed in bytes per second
dbaas_disk_write_bytes	Data write speed to disk in bytes per second
dbaas_node_load1	The average value of system load in one minute. Shows how many processes are processed by the cluster cores
dbaas_node_load5	The average system utilization over five minutes. Shows how many processes are processed by the cluster cores
dbaas_node_load15	The average value of system load over 15 minutes. Shows how many processes are processed by the cluster cores
dbaas_network_receive_bytes	Number of bytes received through the network interface
dbaas_network_transmit_bytes	Number of bytes sent through the network interface
dbaas_network_receive_packets	Number of packets received through the network interface per second
dbaas_network_transmit_packets	Number of packets sent through the network interface per second
dbaas_role	Role of the node: 0 — role unknown; 1 — master; 2 — replica

Application level metrics

dbaas_connections	Number of active connections to the PostgreSQL process For example, you can use labels: ds_name — name of the database cluster; datname — database name.
dbaas_total_connections	Total number of established connections to the PostgreSQL process
dbaas_max_tx_duration	Execution time of the longest query in seconds
dbaas_xact_commit_rollback	The number of transactions per second in each database in the cluster. For example, you can use labels: ds_name — name of the database cluster; datname — database name.
dbaas_tup_deleted	Number of rows per second removed by queries in the database
dbaas_tup_fetched	Number of rows per second retrieved by queries in the database
dbaas_tup_inserted	Number of rows per second inserted by queries in the database
dbaas_tup_returned	Number of rows per second returned by queries in the database
dbaas_tup_updated	Number of rows per second changed by queries in the database
dbaas_xact_commit	Number of recorded transactions per second in the database
dbaas_xact_rollback	Number of transactions per second in the database for which rollback was performed
dbaas_cache_hit_ratio	Percentage of data in the query that was read from the cache — the ratio of blks_hit to the sum of blks_hit and blks_read
dbaas_deadlocks	The number of mutual locks per second in each database. For example, you can use labels: ds_name — name of the database cluster; datname — database name.
dbaas_locks	The number of locks per second in each cluster database.For example. you can use labels: ds_name — name of the database cluster; datname — database name.
dbaas_pg_pgss_query_texts_size_bytes	Size of the file with statistics from pg_stat_statements in bytes
dbaas_pg_total_wals_size_bytes	Directory size with WAL files in bytes
dbaas_pg_tmp_size_bytes	PostgreSQL temporary files size in bytes
dbaas_databases_size_bytes	The total size of the database in bytes. For example, you can use the label datname — database name
dbaas_pg_trx_max_age	Number of transactions executed after the last freeze with VACUUM FREEZE or AUTOVACUUM operation
dbaas_pg_pg_trx_percent_before_vacuum_freeze	Indicates the age of the earliest transaction in the database is close to the threshold, after which PostgreSQL forcibly starts VACUUM FREEZE operation. The threshold is defined by autovacuum\_freeze\_max\_age parameter
dbaas_pg_pg_trx_percent_before_wraparound_risk	Indicates how close the age of the earliest transaction in the database is to the threshold after which overflow of transaction identifiers is possible (wraparound)

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 enter DISK_FULL status and will be read-only. To make the cluster read-write , clear the disk or scale the cluster and select a configuration with a larger disk size.

Clear the disk⁠

Open transaction transaction_read_only = no and remove unnecessary data using one of the queries:

• DROP TABLE — deletes the structure (data, privileges, indexes, constraints, triggers). Use when completely deleting a table with data and structure:

  BEGIN;
  SET transaction_read_only = no;
  DROP TABLE table_name;
  COMMIT;

• TRUNCATE TABLE — deletes the contents of the table, but the structure is preserved. Works faster DROP TABLE. Use when deleting all rows of a table while preserving the table structure:

  BEGIN;
  SET transaction_read_only = no;
  TRUNCATE TABLE table_name;
  COMMIT;

• DELETE — use to delete specific strings.

For your information

We do not recommend using the DELETE FROM table WHERE ... query. to clean up disk space. This query can create oversized selections on large tables and place them on disk. The remaining free disk space may run out completely, leading to problems with PostgreSQL and the need to restore it manually.