Obsfly

Feature · /query-summary

Query Summary

Every query your database has run, normalized to a signature, ranked by what's actually hurting you.

In one line

Top-N normalized queries with p50 / p95 / p99 latency, QPS, total time, rows touched, and plan-change history.

What you get

  • Normalized query digests across Postgres / MySQL / MongoDB / Oracle / SQL Server
  • Latency percentiles (p50, p95, p99, max) updated every 15s
  • Total time, calls, rows touched, plan changes, error rate per signature
  • Group by app, host, database, schema, role, or any custom tag
  • Drill from signature → individual executions → wait-event flame graph
  • 30/90/365-day retention depending on plan

vs Datadog DBM

Datadog DBM Query Metrics is the closest equivalent. Obsfly ships the same data, plus plan-change history per signature (Datadog hides plan history behind a separate Live Queries view).

FAQ

How is a query 'normalized'?+

We strip literals, deterministically hash the parameterized form (md5 in Postgres, query_id in MySQL 8+, query digest in MongoDB), and treat that hash as the signature. Same logic Datadog uses.

Does this work without pg_stat_statements?+

For Postgres, no — pg_stat_statements is the source of truth. We auto-detect it on first connect and tell you what's missing.

What about MongoDB?+

We use $currentOp + the MongoDB profiler, normalized to a query shape hash. No driver changes required.

Related reading

· · ·

Watch your databases the way you watch your services.

Book a 30-minute demo. We'll spec your fleet together and quote your first 30-day deal.

Query Summary for Postgres, MySQL, MongoDB & more · Obsfly