pg_profile: PostgreSQL historical workload reports
Summary: The pg_profile extension helps you to find out most resource-consuming activities in PostgreSQL databases.
pg_profile: User function statistics
Summary: This report section contains top functions in cluster, based on pg_stat_user_functions view.
pg_profile: Usage
Summary: in this section, you will learn how to use pg_profile in PostgreSQL.
pg_profile: SQL query statistics
Summary: This report section contains tables of top statements during report interval sorted by several important statistics.
pg_profile: Schema object statistics
Summary: This section of report contains top database objects, using statistics from Statistics Collector views.
pg_profile: Getting started
Summary: The pg_profile extension helps you to find out most resource intensive activities in PostgreSQL databases.
pg_variables: session variables with various types
Summary: The pg_variables module provides functions for working with variables of various types. The created variables are only available in the current user session.
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.
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.