# Postgres Support Recap: Investigating Postgres Query Performance

DevFeed: [Postgres Support Recap: Investigating Postgres Query Performance](<https://devfeed.tech/articles/postgres-support-recap-investigating-postgres-query-performance-5740.md>)

Original publisher: [Read original article](<https://neon.com/blog/postgres-support-recap-investigating-postgres-query-performance>)

Author: Daniel Price

Published: 2024-02-29T16:54:40Z

Content type: article

Language: en

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

Topics: [SQL](<https://devfeed.tech/topics/sql.md>), [Monitoring](<https://devfeed.tech/topics/monitoring.md>), [Optimization](<https://devfeed.tech/topics/optimization.md>), [Statistics](<https://devfeed.tech/topics/statistics.md>), [Caching](<https://devfeed.tech/topics/caching.md>), [Open Source](<https://devfeed.tech/topics/open-source.md>)

Tags: [analysis](<https://devfeed.tech/tags/analysis.md>), [article](<https://devfeed.tech/tags/article.md>), [database](<https://devfeed.tech/tags/database.md>), [monitoring](<https://devfeed.tech/tags/monitoring.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [optimization](<https://devfeed.tech/tags/optimization.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgres](<https://devfeed.tech/tags/postgres.md>), [sql](<https://devfeed.tech/tags/sql.md>)

## AI overview

This article presents three strategies for investigating Postgres query performance: analyzing query statistics with pg_stat_statements, checking the cache hit ratio, and checking for table or index bloat. It also introduces PgHero, a free and open-source application for visually monitoring and analyzing Postgres queries.

## Source excerpt

Neon Support often receives support tickets related to Postgres query performance. Such issues could result from a myriad of factors ranging from missing indexes or lack of database maintenance to ineffective queries and joins or system resource limitations. Where should you star...