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.
For information on using these queries in the Azure portal, see Log Analytics tutorial. For the REST API, see Query.
Transactions and multixacts health
Get current snapshot of the remaining transactions and multixacts for each database.
// If required to get the snapshot on a certain date and time just filter on TimeGenerated column, like:
// where TimeGenerated between (datetime('2023-03-01 16:00') .. datetime('2023-03-01 19:00'))
PGSQLDbTransactionsStats
| summarize arg_max(TimeGenerated,TransactionIdFrozen,TransactionIdFrozenAge,RemainingTransactionIds, RemainingTransactionIdsTillEmergencyAV,RemainingTransactionIdsTillWraparound,MinMultixactId, MinMultixactIdAge,RemainingMultixactIds, RemainingMultixactIdsTillEmergencyAV, RemainingMultixactIdsTillWraparound ) by DatabaseName