# Easier Postgres fine-tuning with online\_advisor

DevFeed: [Easier Postgres fine-tuning with online\_advisor](<https://devfeed.tech/articles/easier-postgres-fine-tuning-with-online-advisor-5221.md>)

Original publisher: [Read original article](<https://neon.com/blog/easier-postgres-fine-tuning-with-online_advisor>)

Author: Carlota Soto

Published: 2025-09-16T18:17:18Z

Content type: article

Language: en

Sources: [Blog -- Neon Docs](<https://devfeed.tech/sources/blog-neon-docs.md>)

Topics: [Databases](<https://devfeed.tech/topics/databases.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Statistics](<https://devfeed.tech/topics/statistics.md>), [real-time](<https://devfeed.tech/topics/real-time.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [monitor](<https://devfeed.tech/tags/monitor.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [sql](<https://devfeed.tech/tags/sql.md>), [statistics](<https://devfeed.tech/tags/statistics.md>)

## AI overview

The article introduces a Postgres extension called online_advisor that analyzes query workloads in real time and recommends indexes, extended statistics, and prepared statements. It monitors query execution data but leaves review and application of the recommendations to the user.

## Source excerpt

You've heard this many times before - in order to keep your Postgres database working smoothly, you need to have proper index planning. Too few indexes, and your query performance suffers. Misestimated row counts can also trick the planner into poor choices, and if you're not usi...