product direction

Roadmap

What is being built now. Everything else is TBD.

Done

Shipped

Go rewrite of iqtoolkit-analyzer — PostgreSQL-only, distributed as a self-contained binary.
Multi-format log parsing (stderr, csvlog, jsonlog) with auto-detection.
Extended data collection: pg_stat_statements, pg_stat_user_tables, pg_stat_user_indexes, pg_buffercache.
AI-enhanced recommendations via OpenAI, Anthropic, Gemini, or Amazon Bedrock.
Flexible output: text, JSON, Markdown, and self-contained HTML reports.
No external runtime dependencies, no cloud requirement.

In progress

pg_stat_activity analysis — real-time session monitoring, idle-in-transaction detection.
Lock contention detection — blocking chain identification, deadlock signals.
Vacuum & bloat health — autovacuum progress, dead tuple tracking.
EXPLAIN plan parsing — sequential scan detection, missing index signals.

TBD

Milestones beyond the current rewrite will be defined once pgtools reaches a stable release. Follow the repo for updates.