---
title: "1C database monitoring"
sidebar_label: "Database monitoring"
sidebar_position: 4
description: "How to monitor the status of a 1C database"
---

import Formbricks from '@theme/MDXComponents/Formbricks'
import {CustomTable} from '@selectel/docux/components'
import Tabs from '@theme/Tabs'
import TabItem from '@theme/TabItem'
import {TabItemLabel} from '@selectel/docux/components'
import CopyIcon from '@selectel/docux/icons/copy'
import ExportMetrics from '@site/i18n/en/docusaurus-plugin-content-docs/current/_partials/1c-cloud/export-metrics.mdx'

# 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:

* [database metrics](#view-database-metrics);
* [cluster metrics](/cloud-1c/cluster/monitoring.mdx).

A full set of available metrics can be exported in Prometheus format. Learn more in the [Exporting metrics in Prometheus format](/cloud-1c/cluster/monitoring.mdx#export-metrics-in-prometheus-format) subsection of the [Monitoring a 1C server cluster](/cloud-1c/cluster/monitoring.mdx) guide.

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 \{#view-database-metrics}

1. In the [control panel](https://my.selectel.ru/vpc/default/ones/), on the top menu, click **Products** and select **1C Ready-to-Use Cloud**.
2. Go to the **Databases** section.
3. Open the database page → **Monitoring** tab.
4. In the **Cluster monitoring** block, select the monitoring type:
   * **Database server monitoring** — if you need to view resource metrics for cloud servers;
   * **Database monitoring** — if you need to view the overall database load and query metrics.
5. Optional: filter metrics by date.
6. View the available [database metrics](#database-metrics).

### Database metrics in the control panel \{#database-metrics}

<Tabs queryString="database-metrics">
  <TabItem value="servers-monitoring">
    <TabItemLabel>
      Database server monitoring
    </TabItemLabel>

    <CustomTable>
      <table data-sticky>
        <tbody>
          <tr>
            <th>Memory</th><td>Used memory excluding cache and temporary data, in percent or GB</td>
          </tr>

          <tr>
            <th>vCPU</th><td>Server core utilization in percent</td>
          </tr>

          <tr>
            <th>CPU iowait</th><td>Percentage of time the processor is idle and waiting for I/O operations to complete</td>
          </tr>

          <tr>
            <th>Volume</th><td>Used disk space in percent or GB. Takes into account the part of the disk space reserved for system needs</td>
          </tr>

          <tr>
            <th>Load Average</th><td>System load average for one, five, and 15 minutes. Shows the number of completed operations</td>
          </tr>

          <tr>
            <th>OOM</th><td>Number of operations that terminated due to out-of-memory errors</td>
          </tr>

          <tr>
            <th>Disk load</th>

            <td>
              <ul>
                <li>Disk read and write operation speed per second</li><li>Number of disk read and write operations per second</li>
              </ul>
            </td>
          </tr>

          <tr>
            <th>Network load</th>

            <td>
              <ul>
                <li>Number of bytes transmitted and received via the network interface</li><li>Number of packets transmitted and received via the network interface per second</li>
              </ul>
            </td>
          </tr>
        </tbody>
      </table>
    </CustomTable>
  </TabItem>

  <TabItem value="database-monitoring">
    <TabItemLabel>
      Database monitoring
    </TabItemLabel>

    <CustomTable>
      <table data-sticky>
        <tbody>
          <tr>
            <th>Connections</th>

            <td />
          </tr>

          <tr>
            <th>Execution time of the longest query</th><td>Execution time of the longest query in each database for a given period</td>
          </tr>

          <tr>
            <th>Transactions</th><td>Number of transactions per second in each database</td>
          </tr>

          <tr>
            <th>Row operations</th>

            <td>
              Number of rows affected by operations in the selected database per second:

              <ul>
                <li>`tup_deleted` — number of rows deleted by operations per second;</li><li>`tup_fetched` — number of rows fetched by operations per second;</li><li>`tup_inserted` — number of rows inserted by operations per second;</li><li>`tup_returned` — number of rows returned by operations per second;</li><li>`tup_updated` — number of rows updated by operations per second</li>
              </ul>
            </td>
          </tr>

          <tr>
            <th>Cache hits</th><td>Percentage of data in a query read from the cache</td>
          </tr>

          <tr>
            <th>Locks</th><td>Number of locks in each database</td>
          </tr>

          <tr>
            <th>Deadlocks</th><td>Number of deadlocks in each database</td>
          </tr>
        </tbody>
      </table>
    </CustomTable>
  </TabItem>
</Tabs>

<ExportMetrics />

<Formbricks />