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.
- Advanced platform metrics - A premium, paid tier of platform metrics in Azure Monitor that provide more granular observability for Azure resources.
- 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,
PT1Mindicates that the metric is sampled every minute,PT30Mevery 30 minutes,PT1Hevery hour, and so on. - DS Export - Shows whether the metric is exportable to Azure Monitor Logs via Diagnostic Settings.
For information on exporting metrics, see - Metrics export using data collection rules and Create diagnostic settings in Azure Monitor.
For information on metric retention, see Azure Monitor Metrics overview.
For a list of supported logs, see Supported log categories - Microsoft.HorizonDB/clusters
Category: Activity
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Active Connections Active Database Connections |
ActiveConnections |
No | Count | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| Succeeded Connections Succeeded Connections |
ConnectionsSucceeded |
No | Count | Total (Sum) | ReplicaName |
PT1M | No |
| Queries per Second Number of top-level queries executed per second, excluding queries nested within functions |
QueriesPerSecond |
No | Count | Minimum, Maximum, Total (Sum) | ReplicaName |
PT1M | No |
| Query Store Flush Status Indicates if the last query store flush succeeded (1) or failed (0) |
QueryStoreFlushStatus |
No | Count | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| Total Transactions Number of total transactions executed in this database |
TotalTransactions |
No | Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Transactions Committed Number of transactions in this database that have been committed |
TransactionsCommitted |
No | Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Transactions per Second Number of transactions executed within a second |
TransactionsPerSecond |
No | Count | Minimum, Maximum, Total (Sum) | ReplicaName |
PT1M | No |
| Transactions Rolled Back Number of transactions in this database that have been rolled back |
TransactionsRolledBack |
No | Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Tuples Deleted Number of rows deleted by queries in this database |
TuplesDeleted |
No | Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Tuples Fetched Number of rows fetched by queries in this database |
TuplesFetched |
No | Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Tuples Inserted Number of rows inserted by queries in this database |
TuplesInserted |
No | Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Tuples Returned Number of rows returned by queries in this database |
TuplesReturned |
No | Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
| Tuples Updated Number of rows updated by queries in this database |
TuplesUpdated |
No | Count | Total (Sum) | database_name, ReplicaName |
PT1M | No |
Category: Compute
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| CPU percent Host CPU utilization percent |
CpuPercent |
No | Percent | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| Memory percent Host memory utilization percent |
MemoryPercent |
No | Percent | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
Category: Concurrency
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Deadlocks Number of deadlocks that are detected in this database |
Deadlocks |
No | Count | Total (Sum) | database_name, ReplicaName |
PT1M | Yes |
| Max Connections Maximum Database connections configured in server parameters |
MaxConnections |
No | Count | Maximum | ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| Oldest Backend Age in seconds of the oldest backend (irrespective of the state) |
OldestBackend |
No | Seconds | Maximum | ReplicaName |
PT1M | No |
| Oldest Query Age in seconds of the longest query that's currently running |
OldestQuery |
No | Seconds | Maximum | ReplicaName |
PT1M | No |
| Oldest Transaction Age in seconds of the longest query that's currently running |
OldestTransaction |
No | 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 |
No | Count | Maximum | ReplicaName |
PT1M | No |
| Oldest xmin Age Age in units of the oldest xmin. Indicates how many transactions passed since the oldest |
OldestXminAge |
No | 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 |
No | 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 |
No | Count | Maximum, Minimum, Average | wait_event_type, ReplicaName |
PT1M | No |
Category: Database
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Buffer Pool Cache Hit Ratio Percentage of reads served from shared buffers |
BufferPoolCacheHitRatio |
No | Count | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| Database Size Size of database |
DatabaseSize |
No | Bytes | Average, Maximum, Minimum | database_name, ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| Maximum Used Transaction IDs Largest number of transaction IDs consumed; used to monitor proximity to XID wraparound |
MaximumUsedTransactionIDs |
No | Count | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| Temporary Files Number of temporary files that were created by queries in this database |
TemporaryFiles |
No | 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 |
No | Bytes | Total (Sum) | database_name, ReplicaName |
PT1M | No |
Category: Errors
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Failed Connections Failed Connections |
ConnectionsFailed |
No | Count | Total (Sum) | ReplicaName |
PT1M | No |
Category: Health
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Postgres Instance Is Alive Indicates if the Postgres process is running |
PGHeartbeat |
No | Count | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
Category: Network
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Network Out Network Out across active connections |
NetworkBytesEgress |
No | Bytes | Total (Sum) | ReplicaName |
PT1M | No |
| Network In Network In across active connections |
NetworkBytesIngress |
No | Bytes | Total (Sum) | ReplicaName |
PT1M | No |
Category: Replication
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Max Logical Replication Lag Maximum lag across all logical replication slots |
MaxLogicalReplicationDelay |
No | Bytes | Maximum, Minimum, Average | ReplicaName |
PT1M | No |
Category: Storage
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Commit Latency, in Microsecond The maximum duration taken by the engine to complete the commit operations |
CommitLatency |
No | Unspecified | Maximum | PT1M | No | |
| Read Iops Number of read I/O operations from storage |
ReadIops |
No | CountPerSecond | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| Read Throughput Amount of data read from storage |
ReadThroughput |
No | BytesPerSecond | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| SSD Cache Hit Ratio Percentage of reads served by the local SSD cache |
SsdCacheHitRatio |
No | Percent | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| SSD Cache Hits Number of reads served by the local SSD cache |
SsdCacheHits |
No | Count | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| SSD Cache Misses Number of reads that missed the SSD cache and were served from the storage |
SsdCacheMisses |
No | Count | Average, Maximum, Minimum | ReplicaName |
PT1M | No |
| SSD Cache Writes Number of writes performed into the SSD cache |
SsdCacheWrites |
No | Count | Average, Maximum, Minimum | ReplicaName |
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 |
No | Bytes | Average, Maximum, Minimum | PT1M | No | |
| WAL Bytes Written Amount of WAL Bytes generated by PostgreSQL Engine |
WALBytesWritten |
No | BytesPerSecond | Maximum | PT1M | No | |
| WAL Writes per Second Number of WAL write I/O operations per second |
WALWritesPerSecond |
No | CountPerSecond | Maximum | PT1M | No | |
| Write Latency, in Microsecond Maximum time taken to flush a WAL record (microseconds) |
WriteLatency |
No | Unspecified | Maximum | PT1M | No |
Category: Vacuum
| Metric | Name in REST API | Advanced platform metrics | Unit | Aggregation | Dimensions | Time Grains | DS Export |
|---|---|---|---|---|---|---|---|
| Analyze Operations on User Tables Number of times user tables have been manually analyzed in this database |
AnalyzeUserTables |
No | Count | Maximum, Minimum, Average | database_name, ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| Autoanalyze Operations on User Tables Number of times user tables have been analyzed by the autovacuum daemon in this database |
AutoAnalyzeUserTables |
No | Count | Maximum, Minimum, Average | database_name, ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| Autovacuum Operations on User Tables Number of times user tables have been vacuumed by the autovacuum daemon in this database |
AutovacuumUserTables |
No | Count | Maximum, Minimum, Average | database_name, ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| Bloat Percent Estimated bloat percentage for user tables in this database |
BloatPercent |
No | Percent | Maximum | database_name, ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| Estimated Dead Rows in User Tables Estimated number of dead rows in user tables in this database |
EstimatedDeadRowsUserTables |
No | Count | Maximum, Minimum, Average | database_name, ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| Estimated Live Rows in User Tables Estimated number of live rows in user tables in this database |
EstimatedLiveRowsUserTables |
No | Count | Maximum, Minimum, Average | database_name, ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| Rows Modified Since Analyze in User Tables Estimated number of rows modified since user tables were last analyzed in this database |
ModifiedRowsSinceAnalyzeUserTables |
No | Count | Maximum, Minimum, Average | database_name, ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| User Tables Number of user tables in this database |
UserTables |
No | Count | Maximum, Minimum, Average | database_name, ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| Analyzed User Tables Number of user tables analyzed in this database |
UserTablesAnalyzed |
No | Count | Maximum, Minimum, Average | database_name, ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| Autoanalyzed User Tables Number of user tables analyzed by the autovacuum daemon in this database |
UserTablesAutoanalyzed |
No | Count | Maximum, Minimum, Average | database_name, ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| Autovacuumed User Tables Number of user tables vacuumed by the autovacuum daemon in this database |
UserTablesAutovacuumed |
No | Count | Maximum, Minimum, Average | database_name, ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |
| Vacuumed User Tables Number of user tables vacuumed in this database |
UserTablesVacuumed |
No | Count | Maximum, Minimum, Average | database_name, ReplicaName |
PT30M, PT1H, PT6H, PT12H, P1D | No |