optimization

PostgreSQL Tutorial: Setting up Slow Query Logging

Summary: in this tutorial, you will learn how to setup slow query logging in PostgreSQL.

Continue reading

PostgreSQL Tutorial: Query analysis using pg_stat_statements

Summary: The pg_stat_statements extension exposes a lot of query statistics that will be helpful in finding slow queries that need to be optimized. In this tutorial, we shall see some example queries to view some information from pg_stat_statements.

Continue reading