verify_index
Measure a candidate index on a disposable clone, comparing read savings to write costs and checking for regressions, to produce an evidence-based adoption verdict.
Instructions
MEASURE a candidate index on a disposable data-bearing clone and return a verdict. This is the only tool that produces evidence: real CREATE INDEX, EXPLAIN (ANALYZE, BUFFERS) with grounded parameters before/after, a measured write-cost micro-benchmark, and a regression check across the top production queries. Verdict = read savings vs write cost at observed traffic rates, REJECT on any top-query regression.
Needs a clone provider on the profile (clone_provider = "docker") and Docker running; the clone is destroyed afterwards, always. Takes tens of seconds to minutes depending on database size. Fails loudly when the profile cannot measure — there is no degraded verdict.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sqls | No | ||
| profile | Yes | ||
| queryids | No | ||
| index_def | Yes | ||
| regression_top_n | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||