Obsfly

Feature · /query-summary

Resumen de consultas

Cada consulta que ha ejecutado tu base, normalizada a una firma, ordenada por lo que de verdad duele.

In one line

Top-N consultas normalizadas con latencia p50 / p95 / p99, QPS, tiempo total, filas tocadas e historial de cambio de plan.

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

· · ·

Vigila tus bases como vigilas tus servicios.

Reserva una demo de 30 minutos. Especificamos tu flota juntos y cotizamos tu primer trato de 30 días.

Resumen de consultas for Postgres, MySQL, MongoDB & more · Obsfly