PostgreSQL Tutorial: Tune selectivity estimation of equalities
Summary: in this tutorial, you will learn how to tune selectivity estimation of equalities.
Planner statistics for indexed expressions
Summary: PostgreSQL is gathering statistics for indexed expressions, in order to make good choices of query plans.
Planner statistics in PostgreSQL
Summary: Planner statistics play a key role in improving the performance of the database. The query planner uses the statistical data to generate efficient run plans for queries. The purpose of this post is to explain the types of statistics in PostgreSQL and how to read and understand them.
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.