Interface IndexAdvisorOptions

Index Advisor options from the config file (plugins[].Options).

interface IndexAdvisorOptions {
    Concurrently: boolean;
    IncludeDiscoveredFKs: boolean;
    KeyMinConfidence: number;
    LLMReview: boolean;
    MaxLLMTables: number;
    MinRowCount: number;
}

Properties

Concurrently: boolean

PostgreSQL: emit CREATE INDEX CONCURRENTLY (no write lock while building; runs outside a transaction). Default true.

IncludeDiscoveredFKs: boolean

Also index discovered (not just declared) foreign keys. Default true.

KeyMinConfidence: number

Minimum confidence for a discovered key to be used. Default 90.

LLMReview: boolean

Run the LLM review layer. Default true.

MaxLLMTables: number

Most tables the LLM review looks at (largest first). Default 40.

MinRowCount: number

Tables with fewer rows get no proposals. Default 1000.