The online_advisor is a Postgres extension designed to optimize database performance by analyzing real-time query workloads and providing actionable recommendations for indexes, extended statistics, and prepared statements. By integrating with Postgres’ executor, it monitors queries to suggest potential performance improvements such as creating indexes when queries filter numerous rows, proposing extended statistics when planner estimates are inaccurate, and identifying queries that would benefit from prepared statements to reduce planning overhead. While it does not automatically implement these suggestions, users can review and apply the recommendations to enhance query efficiency. The extension is compatible with Postgres versions 14–17 and is available on the Neon platform specifically for Postgres 17, offering significant benefits for managing complex query environments by addressing issues like misestimated row counts and unoptimized query planning.