Index Tuning Online detects
- • missing indexes
- • excessive sequential scans
- • large tables
- • high DML activity
- • uncleaned dead tuples
- • VACUUM / autovacuum gaps
- • slow or poorly indexed queries
- • high physical reads
- • abnormal WAL volume
Index Tuning Online
Optimize your PostgreSQL indexes online
Automatic analysis of your tables and queries based on real PostgreSQL statistics.
pg_stat_user_tables + pg_stat_statements
Analysis grounded in your statistics
PWR combines pg_stat_user_tables and pg_stat_statements to turn raw signals into understandable optimization priorities.
Every recommendation includes
- • a risk score from 0 to 100
- • a dominant factor
- • a clear explanation
- • severity and confidence
- • expected impact
- • before/after tracking