# A Methodology for Diagnosing PostgreSQL Slow Queries

> Slow queries are the sworn enemy of OLTP databases. Here’s how to identify, analyze, and fix them using metrics (Pigsty dashboards), pg_stat_statements, and logs.

---

LLMS index: [llms.txt](/llms.txt)

---

[![featured](/img/hero/pg/slow-query.jpg)](https://vonng.com/en/pg/slow-query/)

Slow queries are the sworn enemy of OLTP databases. Here’s how to identify, analyze, and fix them using metrics (Pigsty dashboards), pg_stat_statements, and logs. [**Read more**](https://vonng.com/en/pg/slow-query/)