PostgreSQL Monitoring

Is This Database Slower Than Last Month? Workload History and the Agent-Local History Store

pg_stat_statements counts everything since its last reset, which answers what is expensive overall but not what changed this week. Workload History snapshots those counters into a per-target store on the Enterprise Manager agent and replays them over any window you choose, from the whole workload down to one statement. Wait-event sampling adds what each statement was waiting on, and the Retention Policies page sets how long each kind of history is kept. Part four of four on the advisory features in the PostgreSQL Plug-in for Oracle Enterprise Manager.

Oct 6, 2026

Why Isn't Autovacuum Keeping Up? The Vacuum Advisor and the xmin Horizon

When a table keeps growing while autovacuum is running, the cause is usually one of three things: the table's own storage parameters moved its trigger point, cleanup runs too rarely for the churn, or something is holding the transaction horizon so no vacuum can remove dead rows. The Vacuum Advisor recomputes each table's trigger point from its effective settings, estimates avoidable growth with pgstattuple, names whatever is holding the xmin horizon with the command that releases it, and tracks transaction-ID age against the wraparound limit. Part three of four on the advisory features in the PostgreSQL Plug-in for Oracle Enterprise Manager.

Oct 2, 2026

Webinar – What's New with the PostgreSQL Plug-in for Oracle Enterprise Manager

Recorded September 23, 2026. Plan Analysis, the Plan Drift Advisor, the Index Advisor, the Vacuum Advisor, and Workload History, demonstrated live in the Enterprise Manager 24ai console, plus how their findings become Enterprise Manager alerts.

Sep 23, 2026

Is This Query Still Running the Baseline Plan? Plan Analysis and the Plan Drift Advisor

When a query that was fine last week turns slow, the evidence you need is the plan it actually ran, and that plan is usually gone by the time anyone looks. Plan Analysis keeps it, captured by auto_explain during the query's own execution with nothing re-run, and checks it against five detection rules. The Plan Drift Advisor keeps each query's accepted baseline plans and tells you when a query leaves them. Part two of four on the advisory features in the PostgreSQL Plug-in for Oracle Enterprise Manager.

Sep 21, 2026

Which Index Should You Actually Create? HypoPG, pg_qualstats, and the PostgreSQL Index Advisor

Most index advice is a hunch with a table name attached: this table gets scanned a lot, so maybe index something on it. The Index Advisor in the August 2026 release of the PostgreSQL Plug-in for Oracle Enterprise Manager replaces the hunch with two kinds of evidence. HypoPG prices a candidate index by planning against it without building it, and pg_qualstats reports the predicates your workload actually ran that no index served. Part one of four on the release's advisory features: how each layer works, where each one stops, why they deliberately disagree, and what it takes to install them.

Sep 9, 2026

PostgreSQL Plug-in 13.5.12 for Oracle Enterprise Manager: Patroni Monitoring That Survives Failover

Release 13.5.12 adds native Patroni REST API monitoring to the PostgreSQL Plug-in for Oracle Enterprise Manager, so your cluster visibility no longer depends on the database you're trying to watch.

Jun 4, 2026

Why a Fortune 100 Bank Chose Integration Plumbers for PostgreSQL Monitoring at Scale

When a global bank needed to monitor 2,000+ PostgreSQL instances across 40 countries, every solution they evaluated fell short — except one. Here's why scale made the difference.

Feb 24, 2026

PostgreSQL Plug-in for Oracle Enterprise Manager – Demo

Watch a demo of the PostgreSQL plugin for Oracle Enterprise Manager — monitoring, dashboards, and alerting in action.

PostgreSQL Plugin for Oracle Enterprise Manager – AI World Demo

AI World demo showcasing the PostgreSQL plugin for Oracle Enterprise Manager with intelligent monitoring features.

Installing and configuring the PostgreSQL Plugin for Oracle Enterprise Manager

Step-by-step guide to installing and configuring the PostgreSQL plugin for Oracle Enterprise Manager.

How Oracle EM's PostgreSQL Plugin Saves Time and Reduces Monitoring Complexity

Discover how the PostgreSQL plugin for Oracle Enterprise Manager saves time and simplifies database monitoring.

Aug 4, 2025

Alerts & Monitoring Templates | PostgreSQL for Oracle Enterprise Manager

Pre-built alerts and monitoring templates for PostgreSQL databases in Oracle Enterprise Manager.

Out-of-the-box Dashboards with the PostgreSQL Plugin for Oracle Enterprise Manager

Explore the pre-built dashboards included with the PostgreSQL plugin for Oracle Enterprise Manager.

PostgreSQL Plugin for Oracle Enterprise Manager: Overview & Walkthrough

Complete overview and walkthrough of the PostgreSQL plugin for Oracle Enterprise Manager's key features.

Oracle Enterprise Manager Plugin for Postgres Database Overview

Overview of the Oracle Enterprise Manager plugin for PostgreSQL database monitoring and management.

The Integration Plumbers' PostgreSQL Plug-in and The High Cost of Database Downtime

How the PostgreSQL plugin for Oracle Enterprise Manager helps prevent costly database downtime.

Feb 13, 2025

Getting Started with the PostgreSQL Plugin for Oracle Enterprise Manager

Getting started guide for the PostgreSQL plugin for Oracle Enterprise Manager — setup, configuration, and first steps.

Jan 24, 2025