1C database monitoring

In a ready-to-use 1C cloud, you can monitor the status of your database.

For a more detailed analysis, some metrics can be viewed as charts in the control panel:

A full set of available metrics can be exported in Prometheus format. Learn more in the Export metrics in Prometheus format section of the 1C Server Cluster Monitoring manual.

The time in the control panel matches the time set on your device and does not depend on the region where the cluster is hosted.

note

For example, you have created a database in Novosibirsk, in the ru-8 pool. The Moscow time zone is set on the device you used to log in to the Control Panel. The time on the metrics charts will be displayed in the Moscow time zone.

View 1C database metrics

In the control panel, in the top menu, click Products and select Ready-to-use 1C Cloud.
Go to the Databases section.
Open the database page → Monitoring tab.
In the Cluster monitoring block, select the monitoring type:
- Database server monitoring — if you need to view metrics on cloud server resources;
- Database monitoring — if you need to view the overall database load and query metrics.
Optional: filter metrics by date.
View available database metrics.

Database metrics in the control panel

Database server monitoring
Database monitoring

Memory	Used memory excluding cache and temporary data, in percent or GB
vCPU	Server core utilization in percent
CPU iowait	Percentage of time the processor is idle and waiting for I/O operations to complete
Volume	Used disk space in percent or GB. Takes into account the part of the disk space reserved for system needs
Load Average	System load average for one, five, and 15 minutes. Shows the number of completed operations
OOM	Number of operations that terminated due to out-of-memory errors
Disk load	Disk read and write operation speed per second Number of disk read and write operations per second
Network load	Number of bytes transmitted and received via the network interface Number of packets transmitted and received via the network interface per second

Connections
Execution time of the longest query	Execution time of the longest query in each database for a given period
Transactions	Number of transactions per second in each database
Row operations	Number of rows affected by operations in the selected database per second: `tup_deleted` — number of rows deleted by operations per second; `tup_fetched` — number of rows fetched by operations per second; `tup_inserted` — number of rows inserted by operations per second; `tup_returned` — number of rows returned by operations per second; `tup_updated` — number of rows updated by operations per second
Cache hits	Percentage of data in a query read from the cache
Locks	Number of locks in each database
Deadlocks	Number of deadlocks in each database

Export metrics in Prometheus format

Historical information for clusters is unavailable — metrics are collected once a minute. A list of all metrics supported in 1C server clusters and their description can be found in the table Metrics in Prometheus format.

Get a token.
Get metrics in Prometheus format.

1. Get a token

The token provides access to metrics of all clusters in the project and databases in the same pool.

In the Control panel, in the top menu, click Products and select 1C Managed Cloud.
Go to the 1C server clusters section.
Open the cluster page → Monitoring tab.
In the Prometheus tokens block, click Create. The token will be generated automatically.
In the token line, click and save it.

2. Get metrics in Prometheus format

Configuration file
CLI

Add the following to the Prometheus configuration file:
```
scrape_configs:
  - job_name: get-metrics-from-1c
    scrape_interval: 1m
    static_configs:
      - targets:
        - '<domain>'
    scheme: https
    authorization:
      type: Bearer
      credentials: <token>
```
Specify:
- <domain> — domain for accessing the API. This is the part of the URL without https://, for example metrics.ru-9.1c.selcloud.ru. You can copy it in the Control panel: in the top menu, click Products → 1C Managed Cloud → 1C server clusters → cluster page → Monitoring tab → in the Prometheus tokens block, click next to the URL;
- <token> — token that you saved in step 5 when getting the token in stage 1.
Open the page in your browser where metrics in Prometheus format will be available:
```
http://<ip_address>:9090/targets
```
Specify <ip_address> — the IP address of the server where Prometheus is installed.
Set up monitoring and alerts for the 1C server cluster yourself.

Metrics in Prometheus format

Metrics in Prometheus format are provided for all project clusters. A specific cluster can be found by the 1C cluster ID in the cluster_id label.

Server clusters
Apache servers
Databases
Infobases

You can use the preconfigured dashboard template in Grafana.

go1c_cluster_info	Cluster information
go1c_cluster_config_info	Information on static cluster configuration
go1c_cluster_maintenance_timestamp_seconds	Unix timestamp (Unix) of the last or upcoming cluster maintenance. The status reflects the maintenance state
go1c_cluster_proxy_info	Information on the cluster proxy configuration
go1c_cluster_cpu_usage_cores	Number of CPUs used per cluster node
go1c_cluster_cpu_limit_cores	Configured CPU limit per cluster node
go1c_cluster_memory_usage_bytes	Current working set memory usage in bytes per cluster node
go1c_cluster_memory_limit_bytes	Configured memory limit in bytes per cluster node
go1c_cluster_disk_usage_bytes	Current disk usage in bytes per cluster node
go1c_cluster_disk_capacity_bytes	Total disk size in bytes per cluster node
go1c_cluster_proc_cpu_usage_cores	Number of CPUs used by processes per cluster node
go1c_cluster_proc_open_filedesc	Number of file descriptors by processes per cluster node
go1c_cluster_proc_num_threads	Number of threads for all processes per cluster node
go1c_cluster_proc_thread_cpu_usage_cores	Number of CPUs used by processes and thread subgroups per cluster node
go1c_cluster_proc_resident_memory_bytes	RAM usage in bytes by processes per cluster node
go1c_cluster_proc_virtual_memory_bytes	Virtual memory usage in bytes by processes per cluster node
go1c_cluster_network_receive_bytes_rate	Network data receive rate in bytes per second per cluster node
go1c_cluster_network_transmit_bytes_rate	Network data transmit rate in bytes per second per cluster node
go1c_cluster_network_receive_packets_rate	Number of network packets received per cluster node
go1c_cluster_network_transmit_packets_rate	Number of network packets transmitted per cluster node
go1c_cluster_network_receive_packets_dropped_rate	Number of dropped received network packets per cluster node
go1c_cluster_network_transmit_packets_dropped_rate	Number of dropped transmitted network packets per cluster node
go1c_cluster_fs_reads_rate	Number of file system read operations per second (IOPS) per cluster node
go1c_cluster_fs_writes_rate	Number of file system write operations per second (IOPS) per cluster node
go1c_cluster_fs_read_bytes_rate	File system read rate in bytes per second per cluster node
go1c_cluster_fs_write_bytes_rate	File system write rate in bytes per second per cluster node
go1c_cluster_sessions	Total number of 1C sessions by application type: for example, 1CV8, WebClient and others
go1c_cluster_session_info	Information about an active session: user, application, and session ID
go1c_cluster_licenses	Total number of licenses per cluster
go1c_cluster_seats	Total number of client licenses or seats for activated licenses
go1c_cluster_activated_license_info	Information about activated licenses: type, number, and product
go1c_cluster_1c_rnmgr_info	Information about the `rnmgr` process: process ID, host, and port
go1c_cluster_1c_rphost_info	Information about the `rphost` process: process ID, host, port, and status
go1c_cluster_1c_process_available_performance	Available performance of the `rphost` process
go1c_cluster_1c_process_connections	Current number of active connections to the `rphost` process
go1c_cluster_1c_process_connections_per_app	Current number of active connections to the `rphost` process, grouped by application type
go1c_cluster_1c_process_memory_excess_duration_seconds	Duration in seconds during which the process exceeded the allowed memory usage
go1c_health_issues	Indication of 1C Managed Cloud issues. If the metric is missing, the Managed Cloud is operating correctly
go1c_cluster_session_cpu_time_total	CPU time consumed by server calls within a single session, in seconds
go1c_cluster_session_memory_bytes	Difference in bytes between used memory and memory freed by threads executing requests since the beginning of the session
go1c_cluster_session_calls	Total number of server calls during a session
go1c_cluster_session_server_time_seconds	Total duration of server calls during a session, in seconds
go1c_cluster_session_write_bytes	Volume of data written to disk since the start of the current call, in bytes
go1c_cluster_session_read_bytes	Volume of data read from disk since the beginning of the session, in bytes
go1c_cluster_session_dbms_time_seconds	Total duration of database calls since the first call, in seconds
go1c_cluster_session_dbms_transmitted_bytes	Volume of data transferred between the 1C server and the database since the beginning of the session, in bytes

go1c_apache_info	Information about the Apache version
go1c_apache_up	Indication of Apache server availability
go1c_apache_cpu_usage_cores	Number of CPUs used by the Apache server
go1c_apache_cpu_limit_cores	Configured CPU limit for the Apache server
go1c_apache_memory_usage_bytes	Current working set memory usage by the Apache server in bytes
go1c_apache_memory_limit_bytes	Configured memory limit for the Apache server in bytes
go1c_apache_accesses_total	Total number of HTTP requests to the Apache server
go1c_apache_sent_kilobytes_total	Total volume of data sent by the Apache server in kilobytes
go1c_apache_duration_ms	Average duration of an HTTP request to the Apache server in milliseconds
go1c_apache_scoreboard	Current status of Apache server worker processes and threads. Available statuses: `open_slot` — free slot; `read` — reading request; `reply` — sending response; `startup` — process startup; `keepalive` — holding connection; `closing` — closing connection; `dns` — performing DNS query; `graceful_stop` — graceful shutdown; `idle` — idle; `idle_cleanup` — preparing for cleanup; `logging` — writing data to the log file
go1c_apache_workers	Current number of Apache server worker processes and threads (busy and idle)
go1c_health_issues	Indication of 1C Managed Cloud issues. If the metric is missing, the Managed Cloud is operating correctly

go1c_datastore_info	Information about the database
go1c_datastore_config_info	Information about the database configuration (e.g., whether automatic scaling is enabled)
go1c_datastore_maintenance_timestamp_seconds	Unix timestamp (Unix) of the last or upcoming database maintenance. The status reflects the maintenance state
go1c_datastore_cpu	VCPU usage in percent on database nodes
go1c_datastore_cpu_iowait	Percentage of time the processor is idle while waiting for I/O operations to complete
go1c_datastore_node_load1	Average system load over one minute. Shows the number of operations performed during this time
go1c_datastore_node_load5	Average system load over five minutes. Shows the number of operations performed during this time
go1c_datastore_node_load15	Average system load over 15 minutes. Shows the number of operations performed during this time
go1c_datastore_memory_bytes	Used memory in bytes, excluding cache and temporary data
go1c_datastore_memory_percent	Percentage of used memory, excluding cache and temporary data
go1c_datastore_oom_count	Number of operations that terminated due to lack of memory
go1c_datastore_disk_percent	Disk space usage percentage
go1c_datastore_disk_bytes	Disk space usage in bytes
go1c_datastore_disk_read_iops	Number of disk read operations per second
go1c_datastore_disk_write_iops	Number of disk write operations per second
go1c_datastore_disk_read_bytes	Disk read rate in bytes per second
go1c_datastore_disk_write_bytes	Disk write rate in bytes per second
go1c_datastore_dbaas_network_receive_bytes	Number of bytes received through the network interface
go1c_datastore_network_transmit_bytes	Number of bytes sent through the network interface
go1c_datastore_network_receive_packets	Number of packets received through the network interface per second
go1c_datastore_network_transmit_packets	Number of packets sent through the network interface per second
go1c_health_issues	Indication of 1C Managed Cloud issues. If the metric is missing, the Managed Cloud is operating correctly
go1c_datastore_max_tx_duration_seconds	Duration of the longest active PostgreSQL transaction

go1c_infobase_info	Information about the infobase
go1c_infobase_backup_vault_info	Information about the backup vault
go1c_infobase_backup_tasks	Number of completed infobase backup tasks
go1c_infobase_backup_size_bytes	Infobase backup size in bytes
go1c_infobase_restore_tasks	Number of completed infobase restore tasks from backup
go1c_infobase_http_probe_success	Success rate of HTTP probes on cluster infobases
go1c_health_issues	Indication of 1C Managed Cloud issues. If the metric is missing, the Managed Cloud is operating correctly