Not all index scans are equal: How we cut query latency by over 99%

Datadog engineers optimized a slow PostgreSQL query by replacing an inefficient composite index scan with a targeted index that better matches the query's predicates. This change, which addressed a mismatch in B-tree column order, slashed average query latency from 300 ms to just 38 μs. Additionally, the article highlights how Datadog Database Monitoring can now automatically detect and suggest remedies for similar suboptimal index scans.