Back to Resources
Webinar

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

September 23, 2026

PostgreSQL monitoring in Oracle Enterprise Manager is becoming advisory, not just observational. In this webinar, recorded on September 23, 2026, Andre Beaumont walks through the advisory capabilities in the PostgreSQL Plug-in for Oracle Enterprise Manager, running live in the Enterprise Manager 24ai console against PostgreSQL 17.

The advisors turn collected metrics into ranked findings, the evidence behind each one, and SQL you can copy, review, and run yourself. The session also covers the plug-in's operational features and how advisor findings become alerts in the Enterprise Manager console you already run.

What's Covered

  • 00:47 Why now: advisory, not just observational
  • 03:48 The new capabilities, all in one console
  • 05:28 Demo, Plan Analysis: the plans your queries actually ran, and the Historical Query Insights list
  • 09:28 Demo, Plan Drift Advisor: baselines, drift detection, and the Fix Workbench
  • 12:43 Demo, Index Advisor: what-if index estimates with HypoPG
  • 16:29 Demo, Vacuum Advisor: and what is holding back the xmin horizon
  • 17:28 Demo, Workload History
  • 19:43 Operational features: Backup Management, Monitoring Readiness, and Retention Policies
  • 23:00 Findings become Enterprise Manager alerts
  • 23:58 What's next: the MySQL, SQL Server, and Db2 plug-ins in open beta
  • 25:20 Availability: versions and the upgrade path

Available Now

The PostgreSQL plug-in is generally available as 24.1.3.0.0 for Enterprise Manager 24ai and 13.5.17.0.0 for Enterprise Manager 13.5. It monitors PostgreSQL 14 through 18, with the Enterprise Manager agent either on the database host or remote.

The MySQL, SQL Server, and Db2 plug-ins for Oracle EM are in open beta: MySQL, SQL Server, Db2.

Go Deeper

Who Should Watch

  • Oracle Enterprise Manager Administrators
  • PostgreSQL DBAs
  • Database Reliability and Platform Engineers
  • IT Operations Teams

Presenters

  • Andre Beaumont, Presenter
  • Ben Smith, Product & Architecture
  • Christian Mundwiler, Implementation & Support

Related Resources

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

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
Blog

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

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

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

Not Sure Where to Start?

Take our free OTEL Maturity Assessment to identify gaps and get a personalized action plan.

Take the Free Assessment