← Back to blog

Quantitative, local, explainable analysis

EXPLAIN analyzer for PostgreSQL and MySQL

Find where time really goes, compare estimates with execution, measure buffers, and validate an optimization — without executing SQL or uploading the plan.

1. Paste the plan

Text or JSON; automatic detection.

2. Find hotspots

Self time, total time, loops, and buffers.

3. Understand the cause

Findings with evidence and confidence.

4. Compare the fix

Current plan against a baseline.

Local privacy: the content stays in this browser. Remove sensitive literals before sharing the report.

Loops change the math

Node timings are per loop; buffers already represent accumulated work. The tool handles those units separately.

Functions can hide SQL

Function Scan shows outer cost, not nested statements. Opaque findings recommend instrumentation instead of a blind index.

An index is a hypothesis, not a reflex

Single plans do not show frequency, write cost, or the full workload. Validate before changing production.

From calculation to real operations

A calculator shows the risk. PG Monitoring shows when it is happening.

Use this plan as a starting point. Then connect PostgreSQL to validate configuration against real load, concurrency, I/O, WAL, autovacuum, and query behavior — continuously, not only on tuning day.

Assisted diagnostic: we never request passwords or connection strings through forms, email, or WhatsApp.

What the SaaS tracks in PostgreSQL

  • Memory, connections, waits, I/O, and real-time health
  • Slow queries, plans, temporary files, and regressions
  • Autovacuum, bloat, locks, replication, and operational risk
  • Configuration recommendations with workload context
  • Alerts and history to prove whether a change improved things

Frequently asked questions

Is the plan sent to a server?+

No. Parsing, calculations, and diagnostics all run in your browser. No query is executed, uploaded, or stored by PG Monitoring.

Which format provides the fullest analysis?+

For PostgreSQL, prefer EXPLAIN (ANALYZE, BUFFERS, WAL, SETTINGS, FORMAT JSON). For MySQL, use EXPLAIN ANALYZE FORMAT=TREE; JSON v2, JSON v1, and traditional table output are also accepted.

What does self time mean?+

It is an approximation of inclusive node time minus child time, with loops applied correctly. Parallelism and instrumentation can overlap, which the tool flags.

Can I compare an optimization?+

Yes. Paste the new plan in the main field and the previous one in the optional field. The tool compares execution, work volume, and access-method changes; for PostgreSQL it also compares JIT and buffers.

Does the tool create indexes automatically?+

No. A single plan does not reveal write cost, frequency, or the full workload. The tool presents evidence and a next step while keeping the decision reviewable.

Talk to us