> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-sync-clickhouse-operator-docs-7e82242.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Managed Postgres metrics reference

> Full list of metrics exposed by the Managed Postgres Prometheus endpoint

export const PrivatePreviewBadge = () => {
  return <div className="privatePreviewBadge">
            <div className="privatePreviewIcon">
            <svg width="16" height="16" viewBox="0 0 16 16" fill="none" xmlns="http://www.w3.org/2000/svg">
                <path d="M5.33301 6.66667V4.66667V4.66667C5.33301 3.194 6.52701 2 7.99967 2V2C9.47234 2 10.6663 3.194 10.6663 4.66667V4.66667V6.66667" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" />
                <path d="M8.00033 9.33337V11.3334" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" />
                <path fillRule="evenodd" clipRule="evenodd" d="M11.333 14H4.66634C3.92967 14 3.33301 13.4033 3.33301 12.6666V7.99996C3.33301 7.26329 3.92967 6.66663 4.66634 6.66663H11.333C12.0697 6.66663 12.6663 7.26329 12.6663 7.99996V12.6666C12.6663 13.4033 12.0697 14 11.333 14Z" stroke="currentColor" strokeLinecap="round" strokeLinejoin="round" />
            </svg>
        </div>
            {'Private preview in ClickHouse Cloud'}
        </div>;
};

# Metrics reference

This page lists every metric exposed by the
[Managed Postgres Prometheus endpoint](/products/managed-postgres/monitoring/prometheus).
For setup and authentication, see the [Prometheus endpoint] page.

<h2 id="common-labels">
  Common labels
</h2>

Every metric carries the following labels:

| Label                   | Description           |
| ----------------------- | --------------------- |
| `clickhouse_org`        | Organization ID       |
| `postgres_service`      | Postgres service ID   |
| `postgres_service_name` | Postgres service name |

Some metrics add a label for the dimension they break out (e.g.
`mode` on CPU metrics, `state` on connections, `database` on database
size). Those are listed alongside each metric.

<h2 id="information-metric">
  Information metric
</h2>

`PostgresServiceInfo` is a gauge that always equals `1` and carries the
service's current status and version on its labels. Use it to join
status onto other metrics or to alert on a service leaving the
`running` state.

| Metric                | Type  | Extra labels                          | Description                                  |
| --------------------- | ----- | ------------------------------------- | -------------------------------------------- |
| `PostgresServiceInfo` | gauge | `postgres_status`, `postgres_version` | One series per service; value is always `1`. |

`postgres_status` reports the current lifecycle state of the service
(for example `running`, `creating`, `stopped`). `postgres_version`
reports the major Postgres version (e.g. `17`, `18`).

<h2 id="capacity">
  Capacity
</h2>

Static limits provisioned for the service. These change only when the
service is resized.

| Metric                             | Type  | Unit  | Description                         |
| ---------------------------------- | ----- | ----- | ----------------------------------- |
| `PostgresServer_CPUCores`          | gauge | cores | CPU cores allocated to the service. |
| `PostgresServer_MemoryLimitBytes`  | gauge | bytes | Memory allocated to the service.    |
| `PostgresServer_StorageLimitBytes` | gauge | bytes | Storage allocated to the service.   |

<h2 id="resource-utilization">
  Resource utilization
</h2>

| Metric                                 | Type    | Extra labels | Description                                                                                                   |
| -------------------------------------- | ------- | ------------ | ------------------------------------------------------------------------------------------------------------- |
| `PostgresServer_CPUSeconds_Total`      | counter | `mode`       | CPU time consumed, broken out by mode: `user`, `system`, `iowait`, `softirq`, `steal`, `irq`, `nice`, `idle`. |
| `PostgresServer_MemoryUsedPercent`     | gauge   |              | Memory in use, as a percentage of `PostgresServer_MemoryLimitBytes`.                                          |
| `PostgresServer_MemoryCachePercent`    | gauge   |              | Memory used by cache and buffers, as a percentage of total memory.                                            |
| `PostgresServer_FilesystemUsedPercent` | gauge   |              | Filesystem space used, as a percentage of total storage.                                                      |

To compute CPU usage as a percentage, take the rate of
`PostgresServer_CPUSeconds_Total` over the modes you care about and
divide by `PostgresServer_CPUCores`.

<h2 id="io">
  Disk and network I/O
</h2>

| Metric                                      | Type    | Unit  | Description                         |
| ------------------------------------------- | ------- | ----- | ----------------------------------- |
| `PostgresServer_DiskReads_Total`            | counter | ops   | Disk read operations completed.     |
| `PostgresServer_DiskWrites_Total`           | counter | ops   | Disk write operations completed.    |
| `PostgresServer_NetworkReceiveBytes_Total`  | counter | bytes | Bytes received over the network.    |
| `PostgresServer_NetworkTransmitBytes_Total` | counter | bytes | Bytes transmitted over the network. |

<h2 id="database-activity">
  Database activity
</h2>

Cumulative counters since service start. Use `rate()` or `irate()` to
turn them into per-second values.

| Metric                                        | Type    | Description               |
| --------------------------------------------- | ------- | ------------------------- |
| `PostgresServer_TuplesFetched_Total`          | counter | Rows fetched by queries.  |
| `PostgresServer_TuplesInserted_Total`         | counter | Rows inserted.            |
| `PostgresServer_TuplesUpdated_Total`          | counter | Rows updated.             |
| `PostgresServer_TuplesDeleted_Total`          | counter | Rows deleted.             |
| `PostgresServer_TransactionsCommitted_Total`  | counter | Transactions committed.   |
| `PostgresServer_TransactionsRolledBack_Total` | counter | Transactions rolled back. |
| `PostgresServer_Deadlocks_Total`              | counter | Deadlocks detected.       |

<h2 id="connections-cache-size">
  Connections, cache, and database size
</h2>

| Metric                             | Type  | Extra labels | Description                                                                                           |
| ---------------------------------- | ----- | ------------ | ----------------------------------------------------------------------------------------------------- |
| `PostgresServer_ActiveConnections` | gauge | `state`      | Connections by state (e.g. `active`, `idle`).                                                         |
| `PostgresServer_CacheHitRatio`     | gauge |              | Buffer cache hit ratio: blocks served from cache vs. total blocks accessed, as a percentage.          |
| `PostgresServer_DatabaseSizeBytes` | gauge | `database`   | Disk size of each database, in bytes. Includes the `postgres` default and any user-created databases. |

<h2 id="related">
  Related pages
</h2>

* [Prometheus endpoint] — setup, authentication, and scraping
* [Dashboard](/products/managed-postgres/monitoring/dashboard) — built-in cloud console charts
* [OpenAPI guide](/products/managed-postgres/openapi) — API key creation
  and lookup of organization and service IDs

[Prometheus endpoint]: /products/managed-postgres/monitoring/prometheus