1:"$Sreact.fragment"
2:I[71341,["/_next/static/chunks/05dk83pddu73w.js","/_next/static/chunks/18har9a9axxlo.js","/_next/static/chunks/18panc4k51dyj.js"],"default"]
7:I[44969,["/_next/static/chunks/05dk83pddu73w.js","/_next/static/chunks/18har9a9axxlo.js"],"OutletBoundary"]
8:"$Sreact.suspense"
0:{"rsc":["$","$1","c",{"children":[["$","main",null,{"className":"min-h-screen bg-[#f7f5ee] text-[#0b1728]","children":[["$","script",null,{"type":"application/ld+json","dangerouslySetInnerHTML":{"__html":"{\"@context\":\"https://schema.org\",\"@type\":\"TechArticle\",\"headline\":\"Test a PostgreSQL index before creating it\",\"description\":\"Use HypoPG and real workload evidence to evaluate a proposed PostgreSQL index without creating physical DDL.\",\"mainEntityOfPage\":\"https://eyeinthesky6.github.io/indexpilot/use-cases/test-postgres-index-before-creating/\",\"about\":{\"@type\":\"SoftwareApplication\",\"name\":\"IndexPilot\",\"applicationCategory\":\"DeveloperApplication\"}}"}}],["$","article",null,{"className":"mx-auto max-w-4xl px-5 py-14 sm:px-8 sm:py-20","children":[["$","a",null,{"href":"https://eyeinthesky6.github.io/indexpilot/","className":"inline-flex items-center gap-2 text-sm font-bold text-[#456b00]","children":[["$","$L2",null,{"iconNode":[["path",{"d":"m12 19-7-7 7-7","key":"1l729n"}],["path",{"d":"M19 12H5","key":"x3x0zl"}]],"className":"lucide-arrow-left h-4 w-4"}]," IndexPilot"]}],["$","p",null,{"className":"mt-12 font-mono text-xs font-bold uppercase tracking-[0.16em] text-[#456b00]","children":"PostgreSQL index decision guide"}],["$","h1",null,{"className":"mt-4 font-display text-4xl font-bold tracking-[-0.045em] sm:text-6xl","children":"Test a PostgreSQL index before creating it"}],["$","p",null,{"className":"mt-7 max-w-3xl text-xl leading-9 text-[#435064]","children":"Use HypoPG and real workload evidence to evaluate a proposed PostgreSQL index without creating physical DDL."}],["$","section",null,{"className":"mt-12 rounded-3xl bg-[#0b1728] p-7 text-[#f7f5ee] sm:p-10","children":[["$","h2",null,{"className":"font-display text-2xl font-bold","children":"The problem"}],["$","p",null,{"className":"mt-4 text-lg leading-8 text-[#cbd4df]","children":"Building an index just to see whether the planner might use it is slow and leaves cleanup work."}],["$","h2",null,{"className":"mt-9 font-display text-2xl font-bold","children":"How IndexPilot helps"}],["$","p",null,{"className":"mt-4 text-lg leading-8 text-[#cbd4df]","children":"With HypoPG, IndexPilot evaluates the proposed shape inside a read-only review session. It does not execute the supplied CREATE INDEX or run EXPLAIN ANALYZE."}]]}],["$","section",null,{"className":"mt-12","children":[["$","h2",null,{"className":"font-display text-3xl font-bold","children":"Try it"}],["$","div",null,{"className":"mt-5 overflow-x-auto rounded-2xl border border-[#0b1728]/15 bg-white p-5 font-mono text-sm","children":[["$","span",null,{"className":"text-[#456b00]","children":"$$"}]," pipx install indexpilot",["$","br",null,{}],["$","span",null,{"className":"text-[#456b00]","children":"$$"}]," ","indexpilot review --candidate-sql 'CREATE INDEX ON public.orders (tenant_id, created_at)' --hypopg"]}],["$","ul",null,{"className":"mt-7 grid gap-3","children":[["$","li","No physical index created",{"className":"flex items-start gap-3","children":[["$","$L2",null,{"iconNode":[["path",{"d":"M20 6 9 17l-5-5","key":"1gmf2c"}]],"className":"lucide-check mt-1 h-5 w-5 text-[#456b00]"}],["$","span",null,{"children":"No physical index created"}]]}],["$","li","No migration executed",{"className":"flex items-start gap-3","children":[["$","$L2",null,{"iconNode":"$0:rsc:props:children:0:props:children:1:props:children:5:props:children:2:props:children:0:props:children:0:props:iconNode","className":"lucide-check mt-1 h-5 w-5 text-[#456b00]"}],["$","span",null,{"children":"No migration executed"}]]}],["$","li","Positive verdict means benchmark next—not safe to ship",{"className":"flex items-start gap-3","children":[["$","$L2",null,{"iconNode":"$0:rsc:props:children:0:props:children:1:props:children:5:props:children:2:props:children:0:props:children:0:props:iconNode","className":"lucide-check mt-1 h-5 w-5 text-[#456b00]"}],["$","span",null,{"children":"Positive verdict means benchmark next—not safe to ship"}]]}]]}]]}],["$","section",null,{"className":"mt-14 border-t border-[#0b1728]/15 pt-10","children":[["$","h2",null,{"className":"font-display text-3xl font-bold","children":"Important limit"}],["$","p",null,{"className":"mt-4 text-lg leading-8 text-[#435064]","children":"IndexPilot decides whether an index has enough evidence to benchmark. It does not claim that planner cost equals production latency or that an index is safe to ship."}],"$L3"]}],"$L4"]}]]}],["$L5"],"$L6"]}],"isPartial":false,"staleTime":300,"varyParams":null,"buildId":"EqUjFbeEu2GGU5Aqk3_aw"}
3:["$","div",null,{"className":"mt-8 flex flex-col gap-3 sm:flex-row","children":[["$","a",null,{"href":"https://github.com/eyeinthesky6/indexpilot#quick-start","className":"inline-flex items-center justify-center gap-2 rounded-full bg-[#b8f34a] px-6 py-3 font-bold","children":["Review a migration ",["$","$L2",null,{"iconNode":[["path",{"d":"M5 12h14","key":"1ays0h"}],["path",{"d":"m12 5 7 7-7 7","key":"xquz4c"}]],"className":"lucide-arrow-right h-4 w-4"}]]}],["$","a",null,{"href":"https://github.com/eyeinthesky6/indexpilot","className":"inline-flex items-center justify-center gap-2 rounded-full border border-[#0b1728] px-6 py-3 font-bold","children":[["$","svg",null,{"aria-hidden":true,"fill":"currentColor","viewBox":"0 0 16 16","xmlns":"http://www.w3.org/2000/svg","className":"h-4 w-4","children":["$","path",null,{"d":"M8 0C3.58 0 0 3.64 0 8.13c0 3.59 2.29 6.64 5.47 7.71.4.08.55-.18.55-.39 0-.2-.01-.84-.01-1.53-2.01.38-2.53-.5-2.69-.96-.09-.23-.48-.96-.82-1.16-.28-.15-.68-.53-.01-.54.63-.01 1.08.59 1.23.83.72 1.23 1.87.88 2.33.67.07-.53.28-.88.51-1.08-1.78-.21-3.64-.9-3.64-4.01 0-.89.31-1.62.82-2.19-.08-.2-.36-1.04.08-2.16 0 0 .67-.22 2.2.84A7.5 7.5 0 0 1 8 3.89c.68 0 1.36.09 2 .27 1.53-1.06 2.2-.84 2.2-.84.44 1.12.16 1.96.08 2.16.51.57.82 1.3.82 2.19 0 3.12-1.87 3.8-3.65 4.01.29.25.54.73.54 1.49 0 1.08-.01 1.95-.01 2.22 0 .21.15.47.55.39A8.14 8.14 0 0 0 16 8.13C16 3.64 12.42 0 8 0Z"}]}]," View on GitHub"]}]]}]
4:["$","aside",null,{"className":"mt-16 rounded-2xl border border-[#0b1728]/10 p-6","children":[["$","p",null,{"className":"flex items-center gap-2 font-bold","children":[["$","$L2",null,{"iconNode":[["path",{"d":"M12 19h8","key":"baeox8"}],["path",{"d":"m4 17 6-6-6-6","key":"1yngyt"}]],"className":"lucide-terminal h-4 w-4"}]," Other PostgreSQL index questions"]}],["$","ul",null,{"className":"mt-4 grid gap-2","children":[["$","li","should-i-add-this-postgres-index",{"children":["$","a",null,{"className":"text-[#456b00] underline decoration-[#456b00]/30 underline-offset-4","href":"https://eyeinthesky6.github.io/indexpilot/use-cases/should-i-add-this-postgres-index/","children":"Should I add this PostgreSQL index?"}]}],["$","li","postgres-index-not-used",{"children":["$","a",null,{"className":"text-[#456b00] underline decoration-[#456b00]/30 underline-offset-4","href":"https://eyeinthesky6.github.io/indexpilot/use-cases/postgres-index-not-used/","children":"Why is PostgreSQL not using my index?"}]}],["$","li","duplicate-postgres-index",{"children":["$","a",null,{"className":"text-[#456b00] underline decoration-[#456b00]/30 underline-offset-4","href":"https://eyeinthesky6.github.io/indexpilot/use-cases/duplicate-postgres-index/","children":"Does this migration add a duplicate PostgreSQL index?"}]}],["$","li","postgres-index-review-in-ci",{"children":["$","a",null,{"className":"text-[#456b00] underline decoration-[#456b00]/30 underline-offset-4","href":"https://eyeinthesky6.github.io/indexpilot/use-cases/postgres-index-review-in-ci/","children":"Review PostgreSQL index migrations in CI"}]}]]}]]}]
5:["$","script","script-0",{"src":"/_next/static/chunks/18panc4k51dyj.js","async":true}]
6:["$","$L7",null,{"children":["$","$8",null,{"name":"Next.MetadataOutlet","children":"$@9"}]}]
9:null
