
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.


