Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The following table lists the metrics available for the Microsoft.HorizonDB/clusters resource type.
Table headings
Metric - The metric display name as it appears in the Azure portal.
Name in Rest API - Metric name as referred to in the REST API.
Unit - Unit of measure.
Aggregation - The default aggregation type. Valid values: Average, Minimum, Maximum, Total, Count.
Dimensions - Dimensions available for the metric.
Time Grains - Intervals at which the metric is sampled. For example, PT1M indicates that the metric is sampled every minute, PT30M every 30 minutes, PT1H every hour, and so on.
DS Export- Whether the metric is exportable to Azure Monitor Logs via Diagnostic Settings.
For information on exporting metrics, see - Create diagnostic settings in Azure Monitor.
For information on metric retention, see Azure Monitor Metrics overview.
Category: Activity
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Active Connections Active Database Connections |
ActiveConnections |
Count | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| Succeeded Connections Succeeded Connections |
ConnectionsSucceeded |
Count | Total (Sum) | ReplicaName |
PT1M | No |
| Query Store Flush Status Indicates if the last query store flush succeeded (1) or failed (0) |
QueryStoreFlushStatus |
Count | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| Total Transactions Number of total transactions executed in this database |
TotalTransactions |
Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Transactions Committed Number of transactions in this database that have been committed |
TransactionsCommitted |
Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Transactions per Second Number of transactions executed within a second |
TransactionsPerSecond |
Count | Minimum, Maximum, Total (Sum) | ReplicaName |
PT1M | No |
| Transactions Rolled Back Number of transactions in this database that have been rolled back |
TransactionsRolledBack |
Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Tuples Deleted Number of rows deleted by queries in this database |
TuplesDeleted |
Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Tuples Fetched Number of rows fetched by queries in this database |
TuplesFetched |
Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Tuples Inserted Number of rows inserted by queries in this database |
TuplesInserted |
Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Tuples Returned Number of rows returned by queries in this database |
TuplesReturned |
Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Tuples Updated Number of rows updated by queries in this database |
TuplesUpdated |
Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
Category: Compute
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| CPU percent Host CPU utilization percent |
CpuPercent |
Percent | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| Memory percent Host memory utilization percent |
MemoryPercent |
Percent | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
Category: Concurrency
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Deadlocks Number of deadlocks that are detected in this database |
Deadlocks |
Count | Total (Sum) | database_name, ReplicaName |
PT1M | Yes |
| Max Connections Maximum Database connections configured in server parameters |
MaxConnections |
Count | Maximum | ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| Oldest Backend Age in seconds of the oldest backend (irrespective of the state) |
OldestBackend |
Seconds | Maximum | ReplicaName |
PT1M | No |
| Oldest Query Age in seconds of the longest query that's currently running |
OldestQuery |
Seconds | Maximum | ReplicaName |
PT1M | No |
| Oldest Transaction Age in seconds of the longest query that's currently running |
OldestTransaction |
Seconds | Maximum | ReplicaName |
PT1M | No |
| Oldest xmin The actual value of the oldest xmin. If xmin isn't increasing, it indicates that there are some long-running transactions that can potentially hold dead tuples from being removed. |
OldestXmin |
Count | Maximum | ReplicaName |
PT1M | No |
| Oldest xmin Age Age in units of the oldest xmin. Indicates how many transactions passed since the oldest |
OldestXminAge |
Count | Maximum | ReplicaName |
PT1M | No |
| Sessions by State Sessions by state as shown in pg_stat_activity view. It categorizes client backends into various states, such as active or idle |
SessionsByState |
Count | Maximum, Minimum, Average | state, ReplicaName |
PT1M | No |
| Sessions by WaitEventType Sessions by the type of event for which the client backend is waiting |
SessionsByWaitEventType |
Count | Maximum, Minimum, Average | wait_event_type, ReplicaName |
PT1M | No |
Category: Database
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Buffer Pool Cache Hit Ratio Cache hit ratio for shared buffers |
BufferPoolCacheHitRatio |
Count | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| Maximum Used Transaction IDs Largest number of transaction IDs consumed; used to monitor proximity to XID wraparound |
MaximumUsedTransactionIDs |
Count | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| Temporary Files Number of temporary files that were created by queries in this database |
TemporaryFiles |
Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Temporary Files Size Total amount of data that's written to temporary files by queries in this database |
TemporaryFilesSize |
Bytes | Total (Sum) | database_name, ReplicaName |
PT1M | No |
Category: Errors
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Failed Connections Failed Connections |
ConnectionsFailed |
Count | Total (Sum) | ReplicaName |
PT1M | No |
Category: Health
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Postgres Instance Is Alive Indicates if the Postgres process is running |
PGHeartbeat |
Count | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
Category: Network
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Network Out Network Out across active connections |
NetworkBytesEgress |
Bytes | Total (Sum) | ReplicaName |
PT1M | No |
| Network In Network In across active connections |
NetworkBytesIngress |
Bytes | Total (Sum) | ReplicaName |
PT1M | No |
Category: Storage
| Metric | Name in REST API | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|
| Commit Latency, in Microsecond The maximum duration taken by the engine to complete the commit operations |
CommitLatency |
Unspecified | Maximum | <none> | PT1M | No |
| Storage Used Amount of storage space that's used. The storage that's used by the service can include the database files and the transaction log tail |
StorageUsed |
Bytes | Total (Sum) | <none> | PT1M | No |
| WAL Bytes Written Amount of WAL Bytes generated by PostgreSQL Engine |
WALBytesWritten |
BytesPerSecond | Maximum | <none> | PT1M | No |
| WAL Writes per Second Number of WAL I/O operations per second |
WALWritesPerSecond |
CountPerSecond | Maximum | <none> | PT1M | No |
| Write Latency, in Microsecond The maximum duration taken by WAL record to be flushed |
WriteLatency |
Unspecified | Maximum | <none> | PT1M | No |