Skip to technology filters Skip to main content
Dynatrace Hub

Extend the platform,
empower your team.

Popular searches:
Home hero bg
PostgreSQLPostgreSQL
PostgreSQL

PostgreSQL

Monitor your Postgres performance via our new EF2.0 extension framework.

Extension
Free trialDocumentation
Get fast, actionable insights into the health of your databases.Analyze top SQL statements and deep dive into your most impactful queries.Get detailed recommendations on your Postgres configuration parameters.Link database infrastructure monitoring to client-side service-level entities.
  • Product information
  • Release notes

Overview

Our PostgreSQL database monitoring is based on a remote monitoring approach implemented as a Dynatrace ActiveGate SQL extension. The extension queries databases for key performance and health metrics, extending your visibility, and allowing Dynatrace Intelligence to provide anomaly detection and problem analysis.

Use cases

  • Understand the impact of resource shortages, locks, slow statements or other database issues have on your application by observing the database server itself.
  • Track health and performance of your PostgreSQL servers

Get started

For more information on the installation and configuration, please see PostgreSQL extension in the Dynatrace Documentation.

Details

Compatibility information

Compatible with all currently maintained Postgres versions.

Compatibility information

The extension is designed to work with PostgreSQL version 11 and later.

Dynatrace
Documentation
By Dynatrace
Dynatrace support center
Subscribe to new releases
Copy to clipboard

Feature sets

Below is a complete list of the feature sets provided in this version. To ensure a good fit for your needs, individual feature sets can be activated and deactivated by your administrator during configuration.

Feature setsNumber of metrics included
Metric nameMetric keyDescriptionUnit
Instance uptimepostgres.uptimeTime since the instance has been startedSecond
Metric nameMetric keyDescriptionUnit
Latest transaction XID agepostgres.xid_ageDifference between the current transaction's XID and datfrozenxid. If this value exceeds 2^31, this can cause a database crash due to transaction ID wraparound.Count
Number of backendspostgres.numbackendsNumber of backends currently connected to this databaseCount
Committed transactionspostgres.xact_commit.countNumber of transactions in this database that have been committedCount
Rolled back transactionspostgres.xact_rollback.countNumber of transactions in this database that have been rolled backCount
Block read from diskpostgres.blks_read.countNumber of disk blocks read in this databaseCount
Blocks found in buffer cachepostgres.blks_hit.countNumber of times disk blocks were found already in the buffer cache, so that a read was not necessaryCount
Live rows returnedpostgres.tup_returned.countNumber of live rows fetched by sequential scans and index entries returned by index scans in this databaseCount
Live rows fetched by index scanspostgres.tup_fetched.countNumber of live rows fetched by index scans in this databaseCount
Rows insertedpostgres.tup_inserted.countNumber of rows inserted by queries in this databaseCount
Rows updatedpostgres.tup_updated.countNumber of rows updated by queries in this databaseCount
Rows deletedpostgres.tup_deleted.countNumber of rows deleted by queries in this databaseCount
Queries canceled due to conflictpostgres.conflicts.countNumber of queries canceled due to conflicts with recovery in this databaseCount
Temporary files createdpostgres.temp_files.countNumber of temporary files created by queries in this databaseCount
Data written to temporary filespostgres.temp_bytes.countTotal amount of data written to temporary files by queries in this databaseByte
Deadlockspostgres.deadlocks.countNumber of deadlocks detected in this databaseCount
Data file blocks reading timepostgres.blk_read_time.countTime spent reading data file blocks by backends in this databaseMilliSecond
Data file blocks writing timepostgres.blk_write_time.countTime spent writing data file blocks by backends in this databaseMilliSecond
Database Sizepostgres.db_sizeSize of the database in bytesByte
Time spent by sessionspostgres.session_time.countTime spent by database sessions in this databaseMilliSecond
Time spent executing SQL statementspostgres.active_time.countTime spent executing SQL statements in this databaseMilliSecond
Time spent idlingpostgres.idle_in_transaction_time.countTime spent idling while in a transaction in this databaseMilliSecond
Data page checksum failurespostgres.checksum_failures.countNumber of data page checksum failures detected in this database. Only available if data checksums are enabled.Count
Established sessionspostgres.sessions.countTotal number of sessions establishedCount
Abandoned sessionspostgres.sessions_abandoned.countNumber of database sessions to this database that were terminated because connection to the client was lostCount
Fatal error terminated sessionspostgres.sessions_fatal.countNumber of database sessions to this database that were terminated by fatal errorsCount
Killed sessionspostgres.sessions_killed.countNumber of database sessions to this database that were terminated by operator interventionCount
Metric nameMetric keyDescriptionUnit
Subscription stats - apply errorpostgres.subscription_stats.apply_error.countNumber of times an error occurred while applying changes, as reported by pg_stat_subscription_stats.Count
Subscription stats - sync errorpostgres.subscription_stats.sync_error.countNumber of times an error occurred during the initial table synchronization, as reported by pg_stat_subscription_stats.Count
Subscription stats conflict - insert existspostgres.subscription_stats.confl_insert_exists.countNumber of times a row insertion violated a NOT DEFERRABLE unique constraint during the application of changes, as reported by pg_stat_subscription_stats.Count
Subscription stats conflict - update origin differspostgres.subscription_stats.confl_update_origin_differs.countNumber of times an update operation was applied to a row that had been previously modified by another source during the application of changes, as reported by pg_stat_subscription_stats.Count
Subscription stats conflict - update existspostgres.subscription_stats.confl_update_exists.countNumber of times that an updated row value violated a NOT DEFERRABLE unique constraint during the application of changes, as reported by pg_stat_subscription_stats.Count
Subscription stats conflict - update missingpostgres.subscription_stats.confl_update_missing.countNumber of times the tuple to be updated was not found during the application of changes, as reported by pg_stat_subscription_stats.Count
Subscription stats conflict - delete origin differspostgres.subscription_stats.confl_delete_origin_differs.countNumber of times a delete operation was applied to row that had been previously modified by another source during the application of changes, as reported by pg_stat_subscription_stats.Count
Subscription stats conflict - missing deletepostgres.subscription_stats.confl_delete_missing.countNumber of times the tuple to be deleted was not found during the application of changes, as reported by pg_stat_subscription_stats.Count
Subscription stats conflict - multiple unique conflictspostgres.subscription_stats.confl_multiple_unique_conflicts.countNumber of times a row insertion or an updated row values violated multiple NOT DEFERRABLE unique constraints during the application of changes, as reported by pg_stat_subscription_stats.Count
Metric nameMetric keyDescriptionUnit
Active backend processespostgres.activity.activeNumber of server processes executing a queryCount
Active waiting backend processespostgres.activity.active_waitingNumber of server processes actively waitingCount
Idle backend processespostgres.activity.idleNumber of server processes waiting for a new client commandCount
Idle in transaction backends processespostgres.activity.idle_in_transactionNumber of server processes in transaction not currently executing a queryCount
Idle in transaction aborted backends processespostgres.activity.idle_in_transaction_abortedNumber of server processes in transaction not currently executing a query where one of the statements caused an errorCount
Fast-path function backend processespostgres.activity.fastpath_function_callNumber of server processes executing a fast-path function callCount
Metric nameMetric keyDescriptionUnit
WAL files sizepostgres.wal_files_sizeTotal size of all WAL files in the WAL directoryByte
WAL files countpostgres.wal_filesTotal number of WAL files in the WAL directoryCount
WAL files agepostgres.wal_files_ageTime elapsed since the oldest WAL file was modifiedSecond
WAL writepostgres.wal_write.countNumber of times WAL buffers were written out to disk via XLogWrite requestCount
WAL syncpostgres.wal_sync.countNumber of times WAL files were synced to disk via issue_xlog_fsync requestCount
WAL write timepostgres.wal_write_time.countTotal amount of time spent writing WAL buffers to disk via XLogWrite request, in millisecondsMilliSecond
WAL sync timepostgres.wal_sync_time.countTotal amount of time spent syncing WAL files to disk via issue_xlog_fsync request, in millisecondsMilliSecond
WAL diff sizepostgres.wal_diff_sizeSize of difference between current WAL and last WAL replayByte
WAL records per minutepostgres.wal_records.countNumber of WAL records generated per minuteCount
WAL fpi per minutepostgres.wal_fpi.countNumber of WAL full page images generated per minuteCount
WAL bytespostgres.wal_bytes.countTotal amount of WAL generated in bytesCount
WAL buffers fullpostgres.wal_buffers_full.countNumber of times WAL data was written to disk because WAL buffers became fullCount
Metric nameMetric keyDescriptionUnit
Index sizepostgres.indexes.index_sizeDisk space used by the index, as reported by pg_relation_size().Byte
Index scanspostgres.indexes.scans.countNumber of index scans initiated on this index as reported by pg_stat_user_indexes (idx_scan).Count
Index tuples readpostgres.indexes.tuples_read.countNumber of index entries returned by scans on this index as reported by pg_stat_user_indexes (idx_tup_read).Count
Index tuples fetchedpostgres.indexes.tuples_fetched.countNumber of live table rows fetched by simple index scans using this index as reported by pg_stat_user_indexes (idx_tup_fetch).Count
Index disk block readspostgres.indexes.index_disk_reads.countNumber of disk blocks read from this index as reported by pg_statio_user_indexes (idx_blks_read).Count
Index buffer hitspostgres.indexes.index_buffer_hits.countNumber of buffer hits for this index as reported by pg_statio_user_indexes (idx_blks_hit).Count
Estimated row countpostgres.tables.rowsEstimated number of live rows in the table as reported by pg_stat_user_tables (n_live_tup).Count
Dead rowspostgres.tables.dead_rowsEstimated number of dead rows in the table as reported by pg_stat_user_tables (n_dead_tup).Count
Rows modified since analyzepostgres.tables.rows_modified_since_analyzeEstimated number of rows modified since this table was last analyzed as reported by pg_stat_user_tables (n_mod_since_analyze).Count
Rows inserted since vacuumpostgres.tables.rows_inserted_since_vacuumEstimated number of rows inserted since this table was last vacuumed as reported by pg_stat_user_tables (n_ins_since_vacuum).Count
Total table sizepostgres.tables.total_sizeTotal disk space used by the table, including indexes and TOAST data, as returned by pg_total_relation_size().Byte
Table sizepostgres.tables.table_sizeDisk space used by the main fork of the table, as returned by pg_relation_size().Byte
TOAST sizepostgres.tables.toast_sizeDisk space used by the TOAST table associated with this table, as returned by pg_relation_size().Byte
Indexes sizepostgres.tables.indexes_sizeTotal disk space used by all indexes on the table, as returned by pg_indexes_size().Byte
Sequential scanspostgres.tables.sequential_scans.countNumber of sequential scans initiated on this table as reported by pg_stat_user_tables (seq_scan).Count
Index scanspostgres.tables.index_scans.countNumber of index scans initiated on this table as reported by pg_stat_user_tables (idx_scan).Count
Rows read by sequential scanspostgres.tables.rows_read_seq.countNumber of live rows fetched by sequential scans as reported by pg_stat_user_tables (seq_tup_read).Count
Rows read by index scanspostgres.tables.rows_read_idx.countNumber of live rows fetched by index scans as reported by pg_stat_user_tables (idx_tup_fetch).Count
Rows insertedpostgres.tables.rows_inserted.countNumber of rows inserted into this table as reported by pg_stat_user_tables (n_tup_ins).Count
Rows updatedpostgres.tables.rows_updated.countNumber of rows updated in this table as reported by pg_stat_user_tables (n_tup_upd).Count
Rows deletedpostgres.tables.rows_deleted.countNumber of rows deleted from this table as reported by pg_stat_user_tables (n_tup_del).Count
HOT updatespostgres.tables.hot_updates.countNumber of rows HOT updated in this table, where no separate index update was needed, as reported by pg_stat_user_tables (n_tup_hot_upd).Count
Table disk block readspostgres.tables.table_disk_reads.countNumber of disk blocks read from this table as reported by pg_statio_user_tables (heap_blks_read).Count
Table buffer hitspostgres.tables.table_buffer_hits.countNumber of buffer hits for this table as reported by pg_statio_user_tables (heap_blks_hit).Count
Index disk block readspostgres.tables.index_disk_reads.countNumber of disk blocks read from all indexes on this table as reported by pg_statio_user_tables (idx_blks_read).Count
Index buffer hitspostgres.tables.index_buffer_hits.countNumber of buffer hits for all indexes on this table as reported by pg_statio_user_tables (idx_blks_hit).Count
TOAST disk block readspostgres.tables.toast_disk_reads.countNumber of disk blocks read from this table's TOAST table as reported by pg_statio_user_tables (toast_blks_read).Count
TOAST buffer hitspostgres.tables.toast_buffer_hits.countNumber of buffer hits for this table's TOAST table as reported by pg_statio_user_tables (toast_blks_hit).Count
TOAST index disk block readspostgres.tables.toast_index_disk_reads.countNumber of disk blocks read from this table's TOAST table indexes as reported by pg_statio_user_tables (tidx_blks_read).Count
TOAST index buffer hitspostgres.tables.toast_index_buffer_hits.countNumber of buffer hits for this table's TOAST table indexes as reported by pg_statio_user_tables (tidx_blks_hit).Count
Manual vacuumspostgres.tables.vacuum.countNumber of times this table has been manually vacuumed (not counting VACUUM FULL) as reported by pg_stat_user_tables (vacuum_count).Count
Autovacuumspostgres.tables.autovacuum.countNumber of times this table has been vacuumed by the autovacuum daemon as reported by pg_stat_user_tables (autovacuum_count).Count
Manual analyzespostgres.tables.analyze.countNumber of times this table has been manually analyzed as reported by pg_stat_user_tables (analyze_count).Count
Autoanalyzespostgres.tables.autoanalyze.countNumber of times this table has been analyzed by the autovacuum daemon as reported by pg_stat_user_tables (autoanalyze_count).Count
Metric nameMetric keyDescriptionUnit
SLRU blocks zeroedpostgres.slru.blks_zeroed.countNumber of blocks zeroed during initializations, as reported by pg_stat_slru.Count
SLRU blocks hitpostgres.slru.blks_hit.countNumber of times disk blocks were found already in the SLRU cache, so that a read was not necessary, as reported by pg_stat_slru.Count
SLRU blocks readpostgres.slru.blks_read.countNumber of disk blocks read, as reported by pg_stat_slru.Count
SLRU blocks writtenpostgres.slru.blks_written.countNumber of disk blocks written, as reported by pg_stat_slru.Count
SLRU blocks existspostgres.slru.blks_exists.countNumber of blocks checked for existence, as reported by pg_stat_slru.Count
SLRU flushespostgres.slru.flushes.countNumber of SLRU flushes of dirty data, as reported by pg_stat_slru.Count
SLRU truncatespostgres.slru.truncates.countNumber of SLRU truncates, as reported by pg_stat_slru.Count
Metric nameMetric keyDescriptionUnit
Tablespace sizepostgres.tablespace.sizeTablespace size in bytesByte
Metric nameMetric keyDescriptionUnit
Buffers written by background writerpostgres.buffers_clean.countNumber of buffers written by the background writerCount
Cleaning scan stopspostgres.maxwritten_clean.countNumber of times the background writer stopped a cleaning scan because it had written too many buffersCount
Buffers allocatedpostgres.buffers_alloc.countNumber of buffers allocatedCount
Scheduled checkpoints performedpostgres.checkpoints_timed.countNumber of scheduled checkpoints that have been performedCount
Requested checkpoints performedpostgres.checkpoints_req.countNumber of requested checkpoints that have been performedCount
Checkpoints write timepostgres.checkpoint_write_time.countTotal amount of time that has been spent in the portion of checkpoint processing where files are written to diskMilliSecond
Checkpoint sync timepostgres.checkpoint_sync_time.countTotal amount of time that has been spent in the portion of checkpoint processing where files are synchronized to diskMilliSecond
Buffers written during checkpointspostgres.buffers_checkpoint.countNumber of buffers written during checkpointsCount
Buffers written by backendpostgres.buffers_backend.countNumber of buffers written directly by a backendCount
Backend fsync executionspostgres.buffers_backend_fsync.countNumber of times a backend had to execute its own fsync callCount
Metric nameMetric keyDescriptionUnit
Replication WAL restart delaypostgres.replication.restart_delayDifference between current WAL LSN and the restart_lsn as reported by pg_replication_slots.Byte
Replication WAL confirmed flush lagpostgres.replication.confirmed_flush_lagDifference between current WAL LSN and the confirmed_flush_lsn as reported by pg_replication_slots.Byte
Replication slot transaction agepostgres.replication.slot_xmin_ageAge of the oldest transaction that this logical replication slot needs the database to retain, as reported by pg_replication_slots.Byte
Database conflicts tablespacepostgres.database_conflicts.tablespace.countNumber of queries in this database that have been canceled due to dropped tablespaces, as reported by pg_stat_database_conflicts. Standby only.Count
Database conflicts lockpostgres.database_conflicts.lock.countNumber of queries in this database that have been canceled due to lock timeouts, as reported by pg_stat_database_conflicts. Standby only.Count
Database conflicts snapshotpostgres.database_conflicts.snapshot.countNumber of queries in this database that have been canceled due to old snapshots, as reported by pg_stat_database_conflicts. Standby only.Count
Database conflicts buffer pinpostgres.database_conflicts.bufferpin.countNumber of queries in this database that have been canceled due to pinned buffers, as reported by pg_stat_database_conflicts. Standby only.Count
Database conflicts deadlockpostgres.database_conflicts.deadlock.countNumber of queries in this database that have been canceled due to deadlocks, as reported by pg_stat_database_conflicts. Standby only.Count
Replication WAL write lagpostgres.replication.write_lagTime elapsed between flushing recent WAL locally and receiving notification that this standby server has written it, as reported by pg_stat_replication.Second
Replication WAL flush lagpostgres.replication.flush_lagTime elapsed between flushing recent WAL locally and receiving notification that this standby server has written and flushed it, as reported by pg_stat_replication.Second
Replication WAL replay lagpostgres.replication.replay_lagTime elapsed between flushing recent WAL locally and receiving notification that this standby server has written, flushed and applied it, as reported by pg_stat_replication.Second
Replication backend transaction agepostgres.replication.backend_xmin_ageAge of the backend's xmin horizon, as reported by pg_stat_replication.Count
Replication replay delaypostgres.replication.replay_delayDifference in bytes between the current WAL position and the last WAL position replayed on the standby server, as reported by pg_stat_replication.Byte
WAL receiver received timeline IDpostgres.wal_receiver.received_tliTimeline number of the last WAL received and flushed to disk, as reported by pg_stat_wal_receiver. Standby only.Count
WAL receiver last message send agepostgres.wal_receiver.last_msg_send_ageTime elapsed since last message sent to origin WAL sender, as reported by pg_stat_wal_receiver. Standby only.Second
WAL receiver last message receipt agepostgres.wal_receiver.last_msg_receipt_ageTime elapsed since last message received from origin WAL sender, as reported by pg_stat_wal_receiver. Standby only.Second
WAL receiver latest end agepostgres.wal_receiver.latest_end_ageTime elapsed since last write-ahead log location reported to origin WAL sender, as reported by pg_stat_wal_receiver. Standby only.Second
Metric nameMetric keyDescriptionUnit
Instance recovery modepostgres.recovery.stateIndicate that the instance is in recovery mode. 1 if in recovery, 0 otherwise.State
Metric nameMetric keyDescriptionUnit
User function callspostgres.user_functions.calls.countNumber of times this function has been called, as reported by pg_stat_user_functions.Count
User functions total timepostgres.user_functions.total_time.countTotal time spent in this function and all other functions called by it, as reported by pg_stat_user_functions.Millisecond
User functions self timepostgres.user_functions.self_time.countTotal time spent in this function itself, not including other functions called by it, as reported by pg_stat_user_functions.Millisecond
Metric nameMetric keyDescriptionUnit
I/O readspostgres.io.reads.countNumber of read operations as reported by pg_stat_io.Count
I/O read timepostgres.io.read_time.countTime spent waiting for read operations as reported by pg_stat_io.MilliSecond
I/O writespostgres.io.writes.countNumber of write operations as reported by pg_stat_io.Count
I/O write timepostgres.io.write_time.countTime spent waiting for write operations as reported by pg_stat_io.MilliSecond
I/O writebackspostgres.io.writebacks.countNumber of units of size BLCKSZ (typically 8kB) which the process requested the kernel write out to permanent storage as reported by pg_stat_io.Count
I/O writeback timepostgres.io.writeback_time.countTime spent waiting for writeback operations as reported by pg_stat_io.MilliSecond
I/O extendspostgres.io.extends.countNumber of relation extend operations as reported by pg_stat_io.Count
I/O extend timepostgres.io.extend_time.countTime spent waiting for extend operations as reported by pg_stat_io.MilliSecond
I/O hitspostgres.io.hits.countThe number of times a desired block was found in a shared buffer as reported by pg_stat_io.Count
I/O evictionspostgres.io.evictions.countNumber of times a block has been written out from a shared or local buffer in order to make it available for another use as reported by pg_stat_io.Count
I/O reusespostgres.io.reuses.countThe number of times an existing buffer in a size-limited ring buffer outside of shared buffers was reused as part of an I/O operation as reported by pg_stat_io.Count
I/O fsyncspostgres.io.fsyncs.countNumber of fsync calls as reported by pg_stat_io.Count
I/O fsync timepostgres.io.fsync_time.countTime spent waiting for fsync operations as reported by pg_stat_io.MilliSecond
I/O read bytespostgres.io.read_bytes.countThe total size of read operations as reported by pg_stat_io.Byte
I/O write bytespostgres.io.write_bytes.countThe total size of write operations as reported by pg_stat_io.Byte
I/O extend bytespostgres.io.extend_bytes.countThe total size of relation extend operations as reported by pg_stat_io.Byte
Metric nameMetric keyDescriptionUnit
Number of lockspostgres.locksNumber of locks as reported by pg_locksCount

Related to PostgreSQL

ActiveGate logo

ActiveGate

Route traffic, monitor clouds and remote technologies & run Synthetic monitors.

Full version history

To have more information on how to install the downloaded package, please follow the instructions on this page.
ReleaseDate

Full version history

Improvements

  • Queries now run conditionally depending on detected Postgres database version.

⚠️ This version requires ActiveGate version 1.339.0 or higher.

Full version history

Breaking changes:

⚠️ Possible breaking changes and warnings - PLEASE READ before upgrading to this version ⚠️:

  • This version requires a minimum Dynatrace version of 1.338 and a minimum ActiveGate EEC version of 1.337.
  • This version includes a breaking change for 3rd gen environments:
    • With the inclusion of OpenPipeline pipelines, any logs emitted by this extension will be processed by a dedicated OpenPipeline pipeline instead of the classic pipeline. This means that classic rules will no longer be used on logs emitted by the extension. Please be sure to migrate any you still need to OpenPipeline rules.
    • Some field names are handled differently in OpenPipeline, e.g. capitalization. Please double-check any custom dashboards and alerts you have created for this extension.
    • Any dynamic pipelines that were configured to route metrics or logs coming from this extension will no longer be used as data will be statically routed to the extension-shipped pipeline.
    • Finally, you must opt-in to OpenPipeline configuration via Settings API – see documentation.
  • The new tables feature set introduced with this version is disabled by default and may cause high license consumption if enabled.
  • Dropped support for PostgreSQL versions 13 and below.

Features:

  • Smartscape 2.0 topology supporting, instance, database, table and index nodes.
  • New tables feature set added with table and index-related metrics:
    • Metrics captured: postgres.tables.*, postgres.indexes.*.
    • Data captured every 15 mins by default, can be configured with Table query interval field.
    • The database schema is collected as a log every 24 hours, can be configure with the Configuration query interval field.
  • Execution plans for top queries are now automatically captured. These will be shown in a future version of the databases app.
  • Added PII masking for queries coming from pg_stat_activity.

Improvements:

  • A large portion of system queries are no longer collected as part of top statement collection.

⚠️ This version requires ActiveGate version 1.337.0 or higher.

Full version history

Bugfixes

  • Revert change from extension version 2.9.7 , regarding metric description & graphs for postgres.xid_age, to use 2^31 instead of 2^32 for the wraparound value.

Full version history

Enhancements

  • Updated entity links in Platform dashboards to redirect to the Infrastructure and Operations app

Bugfixes

  • Adjusted required dimensions for entity creation to prevent null entities from being created.

Full version history

Features

  • Added an SLRU feature set with the following metrics:
    • postgres.slru.blks_zeroed.count
    • postgres.slru.blks_hit.count
    • postgres.slru.blks_read.count
    • postgres.slru.blks_written.count
    • postgres.slru.blks_exists.count
    • postgres.slru.flushes.count
    • postgres.slru.truncates.count
  • Added an IO feature set with the following metrics (PG16+):
    • postgres.io.reads.count
    • postgres.io.read_time.count
    • postgres.io.writes.count
    • postgres.io.write_time.count
    • postgres.io.writebacks.count
    • postgres.io.writeback_time.count
    • postgres.io.extends.count
    • postgres.io.extend_time.count
    • postgres.io.hits.count
    • postgres.io.evictions.count
    • postgres.io.reuses.count
    • postgres.io.fsyncs.count
    • postgres.io.fsync_time.count
    • postgres.io.read_bytes.count
    • postgres.io.write_bytes.count
    • postgres.io.extend_bytes.count
  • Added a User Functions feature set with the following metrics:
    • postgres.user_functions.calls.count
    • postgres.user_functions.total_time.count
    • postgres.user_functions.self_time.count
  • Added a Subscription feature set with the following metrics:
    • postgres.subscription_stats.apply_error.count
    • postgres.subscription_stats.sync_error.count
    • postgres.subscription_stats.confl_insert_exists.count
    • postgres.subscription_stats.confl_update_origin_differs.count
    • postgres.subscription_stats.confl_update_exists.count
    • postgres.subscription_stats.confl_update_missing.count
    • postgres.subscription_stats.confl_delete_origin_differs.count
    • postgres.subscription_stats.confl_delete_missing.count
    • postgres.subscription_stats.confl_multiple_unique_conflicts.count
  • Added the following metrics to the Replication feature set:
    • postgres.replication.backend_xmin_age
    • postgres.replication.slot_xmin_age
    • postgres.replication.replay_delay
    • postgres.wal_receiver.last_msg_send_age
    • postgres.wal_receiver.last_msg_receipt_age
    • postgres.wal_receiver.latest_end_age
    • postgres.database_conflicts.tablespace.count
    • postgres.database_conflicts.lock.count
    • postgres.database_conflicts.snapshot.count
    • postgres.database_conflicts.bufferpin.count
    • postgres.database_conflicts.deadlock.count
  • Added the following metrics to the WAL feature set:
    • postgres.wal_files_size
    • postgres.wal_files
    • postgres.wal_files_age
  • Added the following metric to the Activity feature set:
    • postgres.activity.active_waiting
  • Adjusted Database activity charts.
  • Added feature set descriptions.

Full version history

Features

  • Added Davis Anomaly Detection alert templates.

Bugfixes

  • Fixed Postgres instance in recovery alert splitting by a non-existing dimension.

Full version history

Features

  • Postgres Instances can now be viewed from the host page.

Bugfixes

  • Fixed DQL for Query Performance and Blocking Activity in Platform dashboard.

Full version history

Bugfixes

  • Fixed bug where some background writer metrics would not be collected for Postgres 17.

Full version history

Features

  • Added ready-made Platform dashboard.
  • Database version is now an attribute of the Postgres instance entities.

Full version history

Bugfixes

  • Fixed bug where the Connection Usage % chart would sometimes show no data.

Full version history

Features

  • Database configuration parameters are now monitored as part of the default feature set. By default, this data is fetched every 24 hours, but this can be adjusted with the Configuration query interval (minutes) variable. This data will be available soon in the Databases App.
  • Added a new feature set Replication which collects replication lag metrics, postgres.replication.*.
  • Added a new feature set Locks which collects lock related metrics as well as information about blocking statements in the form of logs.
  • A new database size metric is now collected, postgres.db_size.
  • In order to monitor transaction wraparound issues, transaction ID age is now collected in the metric postgres.xid_age.
  • Added a database unreachable alert template. Note that all alert templates now default to disabled. The recommended approach to use these alerts is to clone them before enabling/changing them.

Enhancements

  • Top statements are now associated to the database they correspond to. Block hit/read/dirtied/written counts and read/write times are now collected.
  • When possible, top statements are correlated with pg_stat_activity data to obtain wait event times.
  • Additional charts added to various sections of the databases app and entity screens.

ℹ️ This version requires ActiveGate version 1.301.0 or higher.

Full version history

Features:

  • When OneAgent monitoring is configured in the database server, a SAME_AS relationship will be established between the sql:postgres_instance and the corresponding PROCESS_GROUP_INSTANCE.

ℹ️ This version requires ActiveGate version 1.301.0 or higher.

Full version history

Bug fixes:

  • Fixed bug where the WAL diff size metric would not be collected for replication instances. This metric will now have value 0 instead of null when there is no recovery happening.

ℹ️ This version requires ActiveGate version 1.301.0 or higher.

Full version history

Bug fixes:

  • Fixed bug where the heavy-query-interval variable's default value would not be set correctly.

Full version history

Bug fixes:

  • Fixed bug where top statements would appear duplicated in the Databases app

Features:

  • There are now two variables which can be defined at the configuration level, query-interval and heavy-query-interval, which control the frequency with which the Dynatrace queries the database/ingests data. Please see the FAQ section for more details.

Full version history

Bugfixes:

  • Fixed the top queries not showing for certain non-Grail environment in the Postgres Instance screen.

ℹ️ This version requires ActiveGate version 1.293.0 or higher.

Full version history

Improvements

  • Top queries will now no longer collect ALTER statements for security reasons.

Bugfixes:

  • Fixed the Top queries by execution time section in the Databases app.
  • Fixed the displayed columns for top statements in the Databases app.

ℹ️ This version requires ActiveGate version 1.293.0 or higher.

Full version history

WARNING This extension requires minimum ActiveGate version 1.293. Please check your version before upgrading.

Bugfixes:

  • Fixed bug where top queries would not be collected from pg_stat_statements for PostgreSQL 13.

Full version history

WARNING This extension requires minimum ActiveGate version 1.293. Please check your version before upgrading.

Features:

  • (SaaS only) Added execution plan query support with the database app. For users on SaaS who have access to the Databases app execution plan fetching is now supported. View the Getting started section on the hub tile for more details on how to set it up.

Full version history

Bug fixes:

  • Query duration as collected by longest_queries is now calculated as clock_timestamp() - query_start. Previously it was computed as now() - query_start which sometimes caused the query duration to be negative.

    The reason behind this is that now() or CURRENT_TIMESTAMP represent the start of the transaction and an individual query within the transaction can start later. The clock_timestamp() however returns an actual system cpu clock and can change over the course of the transaction, producing a correct value to subtract query_start from to compute a valid duration.

Full version history

Bug fixes:

  • [BREAKING CHANGE] Renamed postgres.blk_hit.count metric key to postgres.blks_hit.count to match official Postgres statistics collector name.

Features:

  • Added an optional endpoint metadata configuration parameter to each endpoint in the monitoring configuration. This parameter will populate the endpoint_metadata attribute of sql:postgres_instance entities and can be used in entity selectors (to facilitate tagging, for example).
  • The Queries feature set will now collect queries (ingested as logs) from the pg_stat_statements table as well. These new logs can be queried by filtering by event_group = top_queries. Note that for this to work, the pg_stat_statements table needs to be enabled at the database level as per the official docs.
  • Added metric charts to the Postgres instance view in the Databases app.

Improvements:

  • Aggregated activities from pg_stat_activity is now collected for all activities, not just the ones associated with a specific datid. That adds monitoring for activites such as autovacuum worker.

Full version history

Improvements:

  • Monitoring for databases was improved to support all versions of Postgres starting with 11. Previously, it only worked for Postgres 14+.
  • All metrics were linked to their corresponding Entity Type to make sure the metrics are displayed correctly when Management Zones are activated and are filtered by entity.

Bug fixes:

  • client_port dimension was removed from the following metrics, because the field bring no valuable information and is too volatile, causing too many distinct timeseries to be generated.
    • postgres.activity.active
    • postgres.activity.fastpath_function_call
    • postgres.activity.idle_in_transaction_aborted
    • postgres.activity.idle_in_transaction
    • postgres.activity.idle

Full version history

Breaking changes: Existing monitoring configurations must be recreated through API or manually

New features:

  • New feature sets
  • New topology type: Tablespace
  • WAL diff metric
  • Query level visibility for longest running queries
  • New metrics and charts on entity screens

Bug fixes:

  • Duplicate topology entities
  • Incorrect metric types
  • Incorrect recovery metric
  • Dashboard and entity screen links

Full version history

Fix for schema change

Full version history

  • Fix link to configurations in overview dashboard

Full version history

No release notes

Dynatrace Hub
Hub HomeGet data into DynatraceBuild your own app
Dynatrace Intelligence - Agentic Operations SystemThe Dynatrace Agentic AI ecosystem
All (914)Log Management and AnalyticsKubernetesAI and LLM ObservabilitySoftware DeliveryApplication ObservabilityApplication SecurityBusiness ObservabilityDigital Experience
Filter
Type
Built and maintained by
Deployment model
SaaS
  • SaaS
  • Managed
Partner FinderBecome a partnerDynatrace Developer

Infrastructure Observability

Get automatic and intelligent observability across cloud and hybrid environments with continuous auto-discovery of any type of infrastructure, all in context and with precise, AI-powered answers.

Essentials

Get automatic and intelligent infrastructure monitoring and observability across hybrid and cloud environments.

OneAgent logo

OneAgent

The simplest way to capture all observation signals automatically and in context.

Discovery & Coverage logo

Discovery & Coverage

Ensure enterprise-wide visibility. Discover and remediate coverage gaps.

Infrastructure & Operations logo

Infrastructure & Operations

Detailed hosts, process, and network insights across the entire environment.

Databases logo

Databases

Monitor databases, prevent issues, and resolve incidents quickly in real time.

Clouds logo

Clouds

Gain full visibility and proactive monitoring across your cloud infrastructure.

Hybrid cloud

AWS logo

AWS

Reliable, scalable, and inexpensive cloud computing services.

Microsoft Azure logo

Microsoft Azure

Cloud computing service for building, testing, deploying, and managing services.

Google Cloud logo

Google Cloud

Meet your business challenges head on with cloud computing services from Google.

VMware logo

VMware

Monitor health and performance of VMware virtual machines.

Nutanix Clusters logo

Nutanix Clusters

Monitor Nutanix clusters' performance, usage and availability, with Nutanix API.

Microsoft Hyper-V Infrastructure logo

Microsoft Hyper-V Infrastructure

Monitor health and performance of the Hyper-V clusters, hosts and VMs.

Technology coverage

F5 BIG-IP logo

F5 BIG-IP

Gain insights into the performance of your F5 BIG-IP LTM and DNS solutions.

Oracle Database logo

Oracle Database

Observe, analyze and optimize the usage, health and performance of your database.

Microsoft SQL Server logo

Microsoft SQL Server

Improve the health and performance monitoring of your Microsoft SQL Servers.

Also popular

See more (5)
Juniper Networks (SNMP) logo

Juniper Networks (SNMP)

Gain insights into the performance of your Juniper networking solutions.

SNMP Traps logo

SNMP Traps

Supplement network monitoring with event-based data reported via SNMP Traps.

Generic Cisco Device logo

Generic Cisco Device

Monitor Cisco devices using SNMP to feed Dynatrace with metrics and alerts.

Palo Alto firewalls logo

Palo Alto firewalls

Palo Alto extension for problems detection.

Remote Windows Host Monitoring logo

Remote Windows Host Monitoring

Monitor health and performance of Windows Hosts without installing an agent.

AWS Lambda logo

AWS Lambda

Automatic and intelligent end-to-end observability of AWS Lambda traces and logs.

More resources

Amazon API Gateway logo

Amazon API Gateway

Service for developers to create, publish, maintain, monitor, and secure APIs.

Amazon AppStream 2.0 logo

Amazon AppStream 2.0

Fully managed application streaming service that provides users with instant access to their desktop applications from anywhere.

Amazon Athena logo

Amazon Athena

Interactive query service that makes it easy to analyze data directly in Amazon S3 using standard SQL.

Amazon Aurora logo

Amazon Aurora

Relational database service developed and offered by Amazon Web Services.

Amazon CloudFront logo

Amazon CloudFront

Content delivery network offered by Amazon Web Services.

Amazon CloudSearch logo

Amazon CloudSearch

Set up, manage, and scale a search solution for your website or application using CloudSearch.

Amazon CloudWatch Logs logo

Amazon CloudWatch Logs

Monitor, store, and access your log files from instances, AWS CloudTrail, Route 53, and other sources.

Amazon Cognito logo

Amazon Cognito

Add user sign-up, sign-in, and access control to your web and mobile apps quickly and easily.

Amazon Connect logo

Amazon Connect

Easy to use omnichannel cloud contact center that helps you to provide superior customer service at a lower cost.

Amazon DocumentDB logo

Amazon DocumentDB

Amazon DocumentDB (with MongoDB compatibility) is a fast, reliable, and fully managed database service.

Amazon DynamoDB Accelerator (DAX) logo

Amazon DynamoDB Accelerator (DAX)

Fully managed, highly available, in-memory cache for your Amazon DynamoDB.

Amazon EC2 Auto Scaling logo

Amazon EC2 Auto Scaling

Amazon EC2 Auto Scaling helps you ensure that you have the correct number of Amazon EC2 instances available.

Amazon EC2 Spot Fleet logo

Amazon EC2 Spot Fleet

Spot Instances and On-Demand Instances to meet the target capacity that you specified.

Amazon Elastic Container Service (ECS) logo

Amazon Elastic Container Service (ECS)

Fully managed container orchestration service.

Amazon Elastic File Service (EFS) logo

Amazon Elastic File Service (EFS)

Cloud storage service provided by Amazon Web Services.

Amazon Elastic Transcoder logo

Amazon Elastic Transcoder

Convert and transcode media files stored in Amazon S3.

Amazon ElastiCache logo

Amazon ElastiCache

Fully managed, Redis- and Memcached-compatible service delivering real-time performance for modern applications by Amazon Web Services.

Amazon Elasticsearch Service logo

Amazon Elasticsearch Service

Fully managed service to deploy, secure, and run Elasticsearch cost effectively at scale, without the operational overhead.

Amazon EMR logo

Amazon EMR

Cloud big data platform for processing vast amounts of data using open source tools.

Amazon EventBridge logo

Amazon EventBridge

Serverless event bus to connect applications together using data from your own applications, integrated SaaS applications, and AWS services.

Amazon FSx for Lustre logo

Amazon FSx for Lustre

Makes it easy and cost-effective to launch and run the popular, high-performance Lustre file system.

Amazon FSx for Windows File Server logo

Amazon FSx for Windows File Server

Provides a managed Microsoft Windows file servers, backed by a native Windows file system.

Amazon GameLift logo

Amazon GameLift

Enables developers to deploy, operate, and scale dedicated, low-cost servers in the cloud for session-based, multiplayer games.

Amazon Inspector logo

Amazon Inspector

Tests the network accessibility of your EC2 instances and the security state of your applications that run on those instances.

AWS IoT logo

AWS IoT

Run local compute, messaging, data caching, and machine learning inference capabilities.

Amazon Keyspaces for Apache Cassandra logo

Amazon Keyspaces for Apache Cassandra

Scalable, highly available, and managed Apache Cassandra–compatible database service.

Amazon Kinesis Data Analytics logo

Amazon Kinesis Data Analytics

Transform and analyze streaming data in real time with open source framework and engine for processing data streams (Apache Flink).

Amazon Kinesis Data Firehose logo

Amazon Kinesis Data Firehose

Fully managed service for delivering real-time streaming data.

Amazon Kinesis Data Streams logo

Amazon Kinesis Data Streams

Collect log and event data from sources such as servers, desktops, and mobile devices.

Amazon Kinesis Video Streams logo

Amazon Kinesis Video Streams

Provides you SDKs to install on your devices to make it easy to stream media.

Amazon Lex logo

Amazon Lex

Service for building conversational interfaces for applications using voice and text.

Amazon MQ logo

Amazon MQ

Managed message broker service for Apache ActiveMQ that makes it easy to migrate to a message broker in the cloud.

Amazon MSK logo

Amazon MSK

Fully managed service that enables you to build and run applications that use Apache Kafka to process streaming data.

Amazon Neptune logo

Amazon Neptune

Fast, reliable, fully managed graph database built for highly connected datasets.

Amazon Polly logo

Amazon Polly

Cloud service that converts text into lifelike speech.

Amazon Quantum Ledger Database (QLDB) logo

Amazon Quantum Ledger Database (QLDB)

Ledger by a central trusted authority that provides an immutable, and cryptographically verifiable transaction log.

Amazon Redshift logo

Amazon Redshift

Data warehouse product which forms part of the larger cloud-computing platform AWS.

Amazon Rekognition logo

Amazon Rekognition

Amazon Rekognition makes it easy to add image and video analysis to your applications.

Amazon Route 53 logo

Amazon Route 53

Effectively connects user requests to infrastructure running in AWS.

Amazon Simple Email Service (SES) logo

Amazon Simple Email Service (SES)

Cloud-based service that helps developers send marketing, notification, and transactional emails.

Amazon Simple Notification Service (SNS) logo

Amazon Simple Notification Service (SNS)

Provides a simple web services interface that can be used to create topics you want to notify apps.

Amazon Simple Queue Service (SQS) logo

Amazon Simple Queue Service (SQS)

Programmatic sending of messages via web service applications.

Amazon Simple Workflow Service (SWF) logo

Amazon Simple Workflow Service (SWF)

Makes it easy to build applications that coordinate work across distributed components.

Amazon Textract logo

Amazon Textract

Makes it easy to add document text detection and analysis to your applications.

Amazon Transfer Family logo

Amazon Transfer Family

Provides fully managed support for file transfers directly into and out of Amazon S3 using SFTP, FTPS, and FTP.

Amazon Translate logo

Amazon Translate

Text translation service using machine learning to provide high-quality translation on demand.

Amazon VPC (NAT Gateway) logo

Amazon VPC (NAT Gateway)

Connect to the Internet from instances within a private subnet in an AWS Virtual Private Cloud.

Amazon WorkMail logo

Amazon WorkMail

Secure, managed business email and calendaring service with support for existing desktop and mobile email clients.

Are you looking for something different?

We have hundreds of apps, extensions, and other technologies to customize your environment

Extend your knowledge

Learn the Dynatrace Query Language

Learn the Dynatrace Query Language

Explore data, discover patterns, anomalies and outliers, and create statistical modeling with DQL, our powerful query language..
Learn DQL
Get certified and advance your career

Get certified and advance your career

Go to Dynatrace University for practical, on-demand courses and learning paths -- from platform basics to key certifications.
Build skills