Back to documentation
Diagnostic

Comparing two before/after snapshots

5 min read

Isolate the real impact of a deployment, a migration or a load spike by comparing two snapshots of your database.

Why compare two snapshots?

A single reading never tells you whether a value is normal or abnormal. By comparing a "before" snapshot and an "after" snapshot around a change (deployment, migration, traffic spike), you precisely isolate what changed.

PWR highlights the significant differences in slow queries, locks, cache hit ratio and CPU/IO consumption.

How to run a comparison

Select two existing reports from the history, then choose "Compare". PWR automatically aligns the common metrics and highlights regressions and improvements.

You can compare a normal day with an incident day, or a state before/after an index optimization.

Reading the results

Each gap is annotated with a severity indicator to help you prioritize actions: whatever degraded response times the most appears first.