Published task benchmark

SQL Query Performance Diagnosis

Given a SQL query, schema, indexes, and execution plan, identify likely bottlenecks and rank safe optimization suggestions without changing query semantics.

Compare measured quality, workload cost, and latency across model tiers. Results are task-specific and directional—not a general model ranking.

Engineering & ProductAnalysisEvaluated 9/9/2026100 evaluation examplesFallback pricing checked September 11, 2026
Analysis

SQL Query Performance Diagnosis

Given a SQL query, schema, indexes, and execution plan, identify likely bottlenecks and rank safe optimization suggestions without changing query semantics.

Engineering & ProductPer query
Not benchmarked
No result on this tier
Token profile pending
/100K
Run this tier to add it
Gemma 4 E4B IT
E4B · Off-the-shelf
775 in · 1,161 out · 18.26s p50
$13.88 /100K
Current price · TrustedRouter
View token rates · observed 9/11/2026
TrustedRouter · $0.0211 input · $0.1055 output /1M
64%
Cheapest
DeepSeek V3
Hosted · Off-the-shelf
640 in · 1,138 out · 11.60s p50
$128 /100K
Best current price · TrustedRouter
Compare 2 router rates · observed 9/11/2026
TrustedRouter · $0.3376 input · $0.9390 output /1M
OpenRouter · $0.2900 input · $1.14 output /1M
59%
GPT-5.4
Hosted · Off-the-shelf
626 in · 1,923 out · 18.38s p50
$3041 /100K
Best current price · OpenRouter
Compare 2 router rates · observed 9/11/2026
OpenRouter · $2.50 input · $15.00 output /1M
TrustedRouter · $2.64 input · $15.82 output /1M
70%
All 12 model results and methodology

Generated 100/100 examples

ModelTierQualityJudgedScenario cost
Nemotron Nano 9B v2small7%100/100$49.30
Qwen3 235B A22Bmid32%100/100$292
DeepSeek V3mid59%100/100$128
Mistral Large 2407mid53%100/100$205
Arcee Trinity Large Thinkingmid0%100/100$174
GPT-5.4frontier70%100/100$3041
Claude Opus 4.7frontier56%100/100$5510
Gemini 3.1 Pro Previewfrontier1%100/100$2547
Gemma 4 E4B ITsmall64%100/100$13.88
Granite 4.1 8Bsmall17%100/100$17.82
Ministral 8B Instruct 2410small8%100/100$24.48
Qwen3 4B Instruct 2507small4%100/100$128

LLM-judge pass rate on 100 synthetic examples. Generator: gpt-5.2. Judge: gpt-5.2. Evaluated 2026-09-09T01:31:02.861Z.

Directional: measured on a synthetic eval set generated by drydock. Cost/latency are not yet captured for taskrouter-run benchmarks.

drydock

Have a neighboring workload?

Describe it in Task Explorer. If it is not measured yet, you can request a benchmark and follow future results.

Explore another task