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
Postgres overview screenPostgres overview screen
  • Product information
  • Release notes

Overview

PostgresSQL monitoring solution is based on a remote monitoring approach implemented as a Dynatrace ActiveGate extension. The extension queries Postgres databases for key performance and health. Dynatrace's DAVIS AI then analyzes these metrics to provide anomaly and problem analysis.

Use cases

  • Monitor the health state and performance of their PostgreSQL setup.
  • Detect anomalies and alert on them.
  • Take pre-emptive measures to avoid service degradations.

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

Extension content

Content typeNumber of items included
screen injections
2
screen logs cards
3
alerts
2
list screen layout
3
screen properties
2
screen layout
5
document dashboard
1
metric metadata
59
screen actions
8
screen metric tables
4
screen entities lists
9
screen custom cards
2
dashboards
1
generic type
4
generic relationship
5
screen dql table
5
screen chart groups
26

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
Tablespace sizepostgres.tablespace.sizeTablespace size in bytesByte
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
Active backend processespostgres.activity.activeNumber of server processes executing a queryCount
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 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
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
Metric nameMetric keyDescriptionUnit
Replication WAL restart delaypostgres.replication.restart_delayDifference between current WAL LSN and the restart_lsn as reported by pg_replication_slotsByte
Replication WAL confirmed flush lagpostgres.replication.confirmed_flush_lagDifference between current WAL LSN and the confirmed_flush_lsn as reported by pg_replication_slotsByte
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
Metric nameMetric keyDescriptionUnit
Number of lockspostgres.locksNumber of locks as reported by pg_locksCount
Metric nameMetric keyDescriptionUnit
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 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 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
Buffers allocatedpostgres.buffers_alloc.countNumber of buffers allocatedCount
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
Data page checksum failurespostgres.checksum_failures.countNumber of data page checksum failures detected in this database. Only available if data checksums are enabled.Count
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
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

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

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
Log Management and AnalyticsKubernetesAI and LLM ObservabilityInfrastructure ObservabilitySoftware DeliveryApplication ObservabilityApplication SecurityDigital ExperienceBusiness Observability
Filter
Type
Built and maintained by
Deployment model
SaaS
  • SaaS
  • Managed
Partner FinderBecome a partnerDynatrace Developer

All

194 Results filtered by:

Palo Alto firewalls logo

Palo Alto firewalls

Palo Alto extension for problems detection

Extension
Confluent Cloud (Kafka) logo

Confluent Cloud (Kafka)

Remotely monitor your Confluent Cloud Kafka Clusters and other resources!

Extension
Kong - Prometheus logo

Kong - Prometheus

Monitor Prometheus metrics exposed by Kong and proxied upstream services

Extension
Nutanix Clusters logo

Nutanix Clusters

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

Extension
Luna Network HSM Device logo

Luna Network HSM Device

Monitor your Luna Network Hardware Security Module (HSM) Devices through SNMP.

Extension
Consul Service Mesh (StatsD) logo

Consul Service Mesh (StatsD)

Extend visibility into your Consul Service Mesh instances to monitor health and improve performance.

Extension
Microsoft IIS logo

Microsoft IIS

Flexible and secure web server for hosting with Windows Server.

Extension
Kubernetes Monitoring Statistics logo

Kubernetes Monitoring Statistics

Troubleshoot your Dynatrace Kubernetes monitoring and Prometheus integration.

Extension
Snyk logo

Snyk

Ingest Snyk vulnerability findings, scans, and audit logs.

Extension
Citrix DaaS & Virtual Apps and Desktops logo

Citrix DaaS & Virtual Apps and Desktops

Gain insight into your Citrix DaaS & Virtual Apps and Desktops environments

Extension
Google Memorystore logo

Google Memorystore

Get insights into Google Memorystore service metrics collected from the Google Operations API to ensure health of your cloud infrastructure.

Extension
Databricks Workspace logo

Databricks Workspace

Remotely monitor your Databricks Workspaces!

Extension
UPS Device logo

UPS Device

Monitor your Uninterruptible Power Supplies (UPS) over SNMP

Extension
Google App Engine (integration) logo

Google App Engine (integration)

Insights into Google App Engine service metrics collected from Operations API

Extensioncoming soon
Traceroute logo

Traceroute

Run traceroute commands and collect step performance metrics

Extension
[Deprecated] Kubernetes PVCs logo

[Deprecated] Kubernetes PVCs

Monitor your Kubernetes persistent volume claims and alert on capacity limits.

Extension
Google Cloud Storage Transfer logo

Google Cloud Storage Transfer

Get insights into Google Cloud Storage Transfer metrics collected from the Google Operations API to ensure health of cloud infrastructure.

Extension
NVIDIA GPU logo

NVIDIA GPU

Monitor base parameters of the GPU, including load, memory and temperature

Extension
Oracle Database logo

Oracle Database

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

Extension
Cisco ACI/APIC logo

Cisco ACI/APIC

Get insights into your Cisco Application Centric Infrastructure (ACI)

Extension
Dell iDRAC logo

Dell iDRAC

Connect to the Redfish API to get insights into your Dell iDRAC environment

Extension
Azure Managed Apache Cassandra logo

Azure Managed Apache Cassandra

Gain insights into your Azure Managed Cassandra Instance health and performance

Extension
PayShield HSM Device logo

PayShield HSM Device

Monitor PayShield Payment Hardware Security Module (HSM) Devices through SNMP.

Extension
NetApp OnTap (Remote) logo

NetApp OnTap (Remote)

Remote extension that collects NetApp OnTap metrics from the OnTap 9.6+ API.

Extension
Google Firestore in Datastore mode logo

Google Firestore in Datastore mode

Get insights into Google Firestore in Datastore mode metrics collected from the Google Operations API to ensure health of infrastructure.

Extension
Redis (2.0) logo

Redis (2.0)

Collect important additional data for your Redis instances.

Extension
PHP-FPM logo

PHP-FPM

Monitor the PHP-FPM status of your applications with this extension.

Extension
Timedrift Monitoring logo

Timedrift Monitoring

Monitor your host's NTP/Chrony Time Offset!

Extension
Apache Kafka logo

Apache Kafka

Automatic and intelligent observability with trace and metric insights.

Extension
MongoDB (local or remote monitoring) logo

MongoDB (local or remote monitoring)

Monitor your MongoDB servers either locally or remotely!

Extension
Connection Pools: C3P0 logo

Connection Pools: C3P0

Application server method of pooling and sharing connections to a database.

Extension
AWS Entities for Metric Streaming logo

AWS Entities for Metric Streaming

Analyse metrics in the context of an entity based on AWS Metric Streaming.

Extension
MongoDB Atlas logo

MongoDB Atlas

Remotely monitor your SaaS installation of MongoDB (Atlas)

Extension
Microsoft SQL Server logo

Microsoft SQL Server

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

Extension
IBM MQ Appliance logo

IBM MQ Appliance

Monitor your IBM MQ Appliances over SNMP

Extension
Google Apigee logo

Google Apigee

Get insights into Google Apigee service metrics collected from the Google Operations API to ensure health of your cloud infrastructure.

Extension
Oracle Autonomous Database on OCI logo

Oracle Autonomous Database on OCI

Monitor health and performance of the Oracle Autonomous Database.

Extension
Google Pub/Sub Lite logo

Google Pub/Sub Lite

Get insights into Google Pub/Sub Lite service metrics collected from the Google Operations API to ensure health of the cloud infrastructure.

Extension
Infoblox DDI logo

Infoblox DDI

Monitor Infoblox DDI using SNMP

Extension
SAP HANA Database (remote monitoring) logo

SAP HANA Database (remote monitoring)

Easily understand the health and performance of your SAP HANA databases.

Extension
Connection Pools: WebSphere Liberty logo

Connection Pools: WebSphere Liberty

Application server method of pooling and sharing connections to a database.

Extension
Google Cloud Composer logo

Google Cloud Composer

Get insights into Google Cloud Composer metrics collected from the Google Operations API to ensure health of your cloud infrastructure.

Extension
Google Cloud Spanner logo

Google Cloud Spanner

Get insights into Google Cloud Spanner metrics collected from the Google Operations API to ensure health of your cloud infrastructure.

Extension
IBM i logo

IBM i

Collect performance data from your IBM i Hosts via this Remote extension.

Extension
Google reCAPTCHA Enterprise logo

Google reCAPTCHA Enterprise

Get insights into Google reCAPTCHA Enterprise metrics collected from the Google Operations API to ensure health of your cloud infrastructure

Extension
.NET logo

.NET

Automatic end-to-end observability for .NET applications and processes.

Extension
Google Cloud's operations suite logo

Google Cloud's operations suite

Get insights into Google Cloud's operations suite metrics collected from the Google Operations API to ensure health of cloud infrastructure.

Extension
Google Vertex AI logo

Google Vertex AI

Get insights into Google Vertex AI service metrics.

Extension
Oracle Exadata logo

Oracle Exadata

Monitor Oracle Exadata systems for performance, usage and availability

Extension
Cisco Catalyst Center (DNA Center) logo

Cisco Catalyst Center (DNA Center)

Get insights into the Cisco Catalyst Center infrastructure (f.k.a. DNA Center).

Extension