pg_show_plans: Inspect execution plans of queries running in PostgreSQL
Summary: The pg_show_plans extension can show query plans of all the currently running SQL statements. Query plans can be shown in several formats, like JSON or YAML.
pg_store_plans: Track PostgreSQL execution plans for queries
Summary: The pg_store_plans module provides a means for tracking execution plan statistics of all SQL statements executed by a server.
PostgreSQL Tutorial: Tune parallel safety of a function
Summary: in this tutorial, you will learn how to tune parallel safety of a function.
PostgreSQL Tutorial: Tune the estimated number of returned rows for a function
Summary: in this tutorial, you will learn how to tune the estimated number of returned rows for a function.
PostgreSQL Tutorial: Tune the estimated execution cost of a function
Summary: in this tutorial, you will learn how to tune the estimated execution cost of a function.
PostgreSQL Tutorial: Avoid redundant function calls in queries
Summary: in this tutorial, you will learn how to avoid redundant function calls in queries.
pg_hint_plan: Details in hinting
Summary: in this article, let’s take a look at the detailed usage of pg_hint_plan in various scenarios.
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.