Obsfly

Feature · /query-summary

Query-Übersicht

Jede Query, die deine Datenbank ausgeführt hat, normalisiert auf eine Signatur, sortiert nach dem, was wirklich wehtut.

In one line

Top-N normalisierte Queries mit p50 / p95 / p99 Latenz, QPS, Gesamtzeit, berührten Zeilen und Plan-Änderungen.

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

· · ·

Überwache deine Datenbanken wie deine Services.

Buche eine 30-minütige Demo. Wir besprechen deine Flotte und erstellen ein 30-Tage-Angebot.

Query-Übersicht for Postgres, MySQL, MongoDB & more · Obsfly