PostgreSQL Mage

PostgreSQL

PostgreSQL ecosystem news, plus development, operations, internals and tuning.

PostgreSQL Mage
2023-10-26	PostgreSQL Macro Query Optimization with pg_stat_statements	PostgreSQL PG Admin Performance

PostgreSQL Macro Query Optimization with pg_stat_statements

2023-10-26 Nikolay Samokhvalov 4334 words 21 min

Query optimization is one of the core responsibilities of DBAs. This article introduces how to use metrics provided by pg_stat_statements for macro-level PostgreSQL query optimization.

PostgreSQL Macro Query Optimization with pg_stat_statements
2023-10-26 By Nikolay Samokhvalov In PGSQL 4334 words 21 min
Nikolay Samokhvalov PostgreSQL PG Admin Performance
In production online databases, slow queries not only affect end-user experience but also waste system resources, increase resource saturation, cause deadlocks and transaction conflicts, increase database connection pressure, and lead to master-slave …
In production online databases, slow queries not only affect end-user experience but also waste system resources, increase resource saturation, cause deadlocks and transaction conflicts, increase database connection pressure, and lead to master-slave …