QueryTriage

QueryTriage is a web app + lightweight agent that continuously identifies the top 1% most expensive queries in production and turns them into a prioritized, actionable queue. It ingests query logs and execution stats (e.g., Postgres pg_stat_statements, MySQL performance_schema, Snowflake/BigQuery history), groups similar queries, and highlights regressions after deploys. For each item, it shows the exact impact in dollars/CPU time, the plan diff over time, and a short list of realistic fixes (index changes, query rewrites, parameterization, stats refresh, partition pruning). It also generates safe, reviewable migration snippets and can open a PR with suggested changes. This is not a magic “one-click optimize” tool—it's a triage system that helps teams stop performance fires with minimal guesswork and clear ROI.