pg_hint_plan: The hint table
Summary: The pg_hint_plan extension provides a hint table, through which you can change the execution plan of a query in a convenient way.
pg_hint_plan: Introduction
Summary: The pg_hint_plan extension gives PostgreSQL ability to manually force some decisions in execution plans.
pg_stat_kcache: Gather I/O and CPU statistics of queries
Summary: The pg_stat_kcache extension gathers statistics about physical disk access and CPU consumption done by backends.
pg_qualstats: PostgreSQL index advisor
Summary: The pg_qualstats extension gathers statistics about predicates, helping find what indices are missing.
hypopg: Hypothetical Indexes
Summary: A hypothetical, or virtual, index is an index that does not really exist, and therefore does not cost CPU, disk or any resource to create. They are useful to find out whether specific indexes can increase the performance for problematic queries, since you can discover if PostgreSQL will use these indexes or not without having to spend resources to create them.
PostgreSQL Tutorial: Logging lock waits and temp files
Summary: in this tutorial, you will learn how to log lock waits and temp files in PostgreSQL.
PostgreSQL Tutorial: Tune optimizer settings
Summary: in this tutorial, you will learn how to tune optimizer settings in PostgreSQL.
PostgreSQL Tutorial: Setting up Slow Query Logging
Summary: in this tutorial, you will learn how to setup slow query logging in PostgreSQL.
PostgreSQL Tutorial: Configuring pg_stat_statements as an extension
Summary: in this tutorial, you will learn how to configure pg_stat_statements as an extension.
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.