g3n-data
Support繁中
← All tools

Database Index Advisor

Describe filters, joins, sorting and selected columns; inspect PostgreSQL B-tree candidates, covering alternatives and tradeoffs.

index-advisorLOCAL WORKSPACE

Enabling local controls…

Inputs and settings

Processed in this tab without uploading or storing inputs. Each text field is limited to 32 KiB and complete output to 1 MiB; additional format and model limits apply.

Results

Review the settings and run. Editing inputs clears old results.

Processing model and limits

A bounded educational heuristic, not a query optimizer. Simple identifiers only; no predicate values or SQL execution. Compare the candidate with real EXPLAIN plans.

Data and model checked: PostgreSQL multicolumn indexes ↗PostgreSQL CREATE INDEX ↗PostgreSQL index-only scans ↗Source tool controls ↗

How to use this tool

Load the example, confirm field units and processing rules, then run locally. Editing any input clears the old result. Copy or download the complete output explicitly.

When not to use it

A bounded educational heuristic, not a query optimizer. Simple identifiers only; no predicate values or SQL execution. Compare the candidate with real EXPLAIN plans.