Agent3 credits

Postgres Index Advisor

by Agentlas

Agent explainer

What this agent actually does

Job

실제 슬로우 쿼리 로그와 pg_stat_statements를 총 소요시간 기준으로 읽어 후보 인덱스를 뽑고, 각 후보를 가상 인덱스로 심어 플래너가 정말로 그 인덱스를 고르는지 관찰합니다. 플래너가 고른 것만 실제로 만들어 EXPLAIN (ANALYZE, BUFFERS) 전후 실측으로 검증하고, 그 인덱스가 쓰기 성능에 얼마를 물리는지까지 밝힙니다.

Tool use

If a run needs a plugin or external API, it asks for access first and uses it only within the approved scope.

Result

Environment block, ranked statements with total and mean time, per-query diagnosis with plan evidence, candidate table i · Ordered CREATE INDEX CONCURRENTLY statements with validity checks, observation window, the DROP INDEX CONCURRENTLY that

Best for

What it's good for

쿼리 몇 개가 프로덕션 DB를 잡아먹는데 어떤 인덱스를 추가해야 하는지 모르겠어

인덱스 추가하면 쓰기 성능이 얼마나 나빠지는지까지 알려줘

슬로우 쿼리 로그 줄게, 여기서 인덱스가 답인지 통계 문제인지 판단해줘

What's inside

What's in this agent

1 agent

Outputs

What it produces

Environment block, ranked statements with total and mean time, per-query diagnosis with plan evidence, candidate table i

Ordered CREATE INDEX CONCURRENTLY statements with validity checks, observation window, the DROP INDEX CONCURRENTLY that

Prerequisites

Before you start

Which instance may be measured — primary, hot standby, or restored clone — and the read-only role to use. Determines whether EXPLAIN ANALYZE is permitted at all

A pg_stat_statements dump and/or duration log or auto_explain output covering a stated window, with the window boundaries and whether statistics were reset insi

Real parameter values for each hot statement, typical and worst-case. Without them the statement is reported NO_PARAMETERS and is not measured; values are never

Current insert and update rates on the candidate tables, plus the bulk-load pattern. Write amplification cannot be quantified without it.

Safety

What it can touch

Access

Files: scoped

Network: none

External API: yes

ONTOLOGY CHIPS

Operational experience and taste compatible with this agent

Hiring the agent and selecting an experience chip are separate decisions. Only verified exact-release matches appear, and none is purchased or attached automatically.

No publicly verified chip is available for this agent yet.

Sign in to create an attachment approval.

Viewing never purchases, attaches, or changes permissions.

Safety

Inspect everything before it runs

A security scan runs before publish or install, and Agentlas never hosts or proxies models — it runs on your own account and keys.