pg_stat_statements ​

Query performance and execution statistics:

Table of Contents ​

• pgexporter_pg_stat_statements_detailed_io_timing_blk_read_time
• pgexporter_pg_stat_statements_detailed_io_timing_blk_write_time
• pgexporter_pg_stat_statements_detailed_io_timing_temp_blk_read_time
• pgexporter_pg_stat_statements_detailed_io_timing_temp_blk_write_time
• pgexporter_pg_stat_statements_exec_time_detailed_mean_exec_time
• pgexporter_pg_stat_statements_exec_time_detailed_total_exec_time
• pgexporter_pg_stat_statements_extension_info_tracked_queries
• pgexporter_pg_stat_statements_extension_metadata_dealloc
• pgexporter_pg_stat_statements_hierarchy_performance_avg_mean_exec_time
• pgexporter_pg_stat_statements_hierarchy_performance_avg_mean_plan_time
• pgexporter_pg_stat_statements_hierarchy_performance_total_wal_bytes
• pgexporter_pg_stat_statements_highest_wal_wal_bytes
• pgexporter_pg_stat_statements_io_stats_local_blks_read
• pgexporter_pg_stat_statements_io_stats_local_blks_written
• pgexporter_pg_stat_statements_io_stats_shared_blks_hit
• pgexporter_pg_stat_statements_io_stats_shared_blks_read
• pgexporter_pg_stat_statements_io_stats_shared_blks_written
• pgexporter_pg_stat_statements_io_stats_temp_blks_read
• pgexporter_pg_stat_statements_io_stats_temp_blks_written
• pgexporter_pg_stat_statements_io_timing_blk_read_time
• pgexporter_pg_stat_statements_io_timing_blk_write_time
• pgexporter_pg_stat_statements_jit_stats_jit_emission_count
• pgexporter_pg_stat_statements_jit_stats_jit_emission_time
• pgexporter_pg_stat_statements_jit_stats_jit_functions
• pgexporter_pg_stat_statements_jit_stats_jit_generation_time
• pgexporter_pg_stat_statements_jit_stats_jit_inlining_count
• pgexporter_pg_stat_statements_jit_stats_jit_inlining_time
• pgexporter_pg_stat_statements_jit_stats_jit_optimization_count
• pgexporter_pg_stat_statements_jit_stats_jit_optimization_time
• pgexporter_pg_stat_statements_jit_summary_avg_jit_time
• pgexporter_pg_stat_statements_jit_summary_jit_enabled_queries
• pgexporter_pg_stat_statements_jit_summary_total_jit_functions
• pgexporter_pg_stat_statements_jit_summary_total_jit_time
• pgexporter_pg_stat_statements_most_executed_calls
• pgexporter_pg_stat_statements_most_planned_plans
• pgexporter_pg_stat_statements_most_rows_rows
• pgexporter_pg_stat_statements_performance_summary_avg_mean_time
• pgexporter_pg_stat_statements_performance_summary_total_calls
• pgexporter_pg_stat_statements_performance_summary_total_exec_time
• pgexporter_pg_stat_statements_performance_summary_total_queries
• pgexporter_pg_stat_statements_planning_stats_mean_plan_time
• pgexporter_pg_stat_statements_planning_stats_plans
• pgexporter_pg_stat_statements_planning_stats_total_plan_time
• pgexporter_pg_stat_statements_query_hierarchy_query_count
• pgexporter_pg_stat_statements_query_hierarchy_total_calls
• pgexporter_pg_stat_statements_query_hierarchy_total_time
• pgexporter_pg_stat_statements_slowest_execution_total_exec_time

pgexporter_pg_stat_statements_most_executed_calls ​

Number of times the most frequently executed SQL query has been called

pgexporter_pg_stat_statements_most_planned_plans ​

Number of times the most frequently planned SQL query has been planned

pgexporter_pg_stat_statements_most_rows_rows ​

Number of rows affected by the SQL query that affects the most rows

pgexporter_pg_stat_statements_slowest_execution_total_exec_time ​

Total execution time in milliseconds for the slowest SQL query

pgexporter_pg_stat_statements_highest_wal_wal_bytes ​

Number of WAL bytes generated by the SQL query with highest WAL usage

pgexporter_pg_stat_statements_planning_stats_plans ​

Number of times the query has been planned.

pgexporter_pg_stat_statements_planning_stats_total_plan_time ​

Total planning time for the statement in milliseconds.

pgexporter_pg_stat_statements_planning_stats_mean_plan_time ​

Mean planning time for the statement in milliseconds.

pgexporter_pg_stat_statements_exec_time_detailed_total_exec_time ​

Total execution time in milliseconds for detailed statement execution analysis.

pgexporter_pg_stat_statements_exec_time_detailed_mean_exec_time ​

Mean execution time in milliseconds for detailed statement execution analysis.

pgexporter_pg_stat_statements_io_stats_shared_blks_hit ​

Number of shared block cache hits by this statement.

pgexporter_pg_stat_statements_io_stats_shared_blks_read ​

From pg_stat_statements: total shared blocks read from disk by a specific query.

pgexporter_pg_stat_statements_io_stats_shared_blks_written ​

From pg_stat_statements: total shared blocks dirtied and written to disk by a specific query.

pgexporter_pg_stat_statements_io_stats_local_blks_read ​

Number of local block reads by this statement.

pgexporter_pg_stat_statements_io_stats_local_blks_written ​

Number of local block writes by this statement.

pgexporter_pg_stat_statements_io_stats_temp_blks_read ​

From pg_stat_statements: total temporary blocks read from disk by a specific query.

pgexporter_pg_stat_statements_io_stats_temp_blks_written ​

From pg_stat_statements: total temporary blocks written to disk by a specific query.

pgexporter_pg_stat_statements_io_timing_blk_read_time ​

Total time spent reading blocks by this statement, in milliseconds.

pgexporter_pg_stat_statements_io_timing_blk_write_time ​

Total time spent writing blocks by this statement, in milliseconds.

pgexporter_pg_stat_statements_performance_summary_total_queries ​

Total number of distinct normalized statements tracked.

pgexporter_pg_stat_statements_performance_summary_total_calls ​

Total number of calls across all tracked statements.

pgexporter_pg_stat_statements_performance_summary_total_exec_time ​

Total execution time across all tracked statements in milliseconds.

pgexporter_pg_stat_statements_performance_summary_avg_mean_time ​

Average mean execution time across all tracked statements in milliseconds.

pgexporter_pg_stat_statements_extension_info_tracked_queries ​

Total number of distinct normalized SQL statements tracked by pg_stat_statements extension.

pgexporter_pg_stat_statements_query_hierarchy_query_count ​

Number of distinct queries in the hierarchy level.

pgexporter_pg_stat_statements_query_hierarchy_total_calls ​

Total number of calls for queries in the hierarchy level.

pgexporter_pg_stat_statements_query_hierarchy_total_time ​

Total execution time for queries in the hierarchy level in milliseconds.

pgexporter_pg_stat_statements_extension_metadata_dealloc ​

Number of times pg_stat_statements entries were deallocated due to lack of memory.

pgexporter_pg_stat_statements_hierarchy_performance_avg_mean_exec_time ​

Average mean execution time across queries in the performance hierarchy.

pgexporter_pg_stat_statements_hierarchy_performance_avg_mean_plan_time ​

Average mean planning time across queries in the performance hierarchy.

pgexporter_pg_stat_statements_hierarchy_performance_total_wal_bytes ​

Total WAL bytes generated by queries in the performance hierarchy.

pgexporter_pg_stat_statements_detailed_io_timing_blk_read_time ​

Total time spent reading data file blocks by this statement, in milliseconds.

pgexporter_pg_stat_statements_detailed_io_timing_blk_write_time ​

Total time spent writing data file blocks by this statement, in milliseconds.

pgexporter_pg_stat_statements_detailed_io_timing_temp_blk_read_time ​

Total time spent reading temporary file blocks by this statement, in milliseconds.

pgexporter_pg_stat_statements_detailed_io_timing_temp_blk_write_time ​

Total time spent writing temporary file blocks by this statement, in milliseconds.

pgexporter_pg_stat_statements_jit_stats_jit_functions ​

Number of functions JIT-compiled for this statement.

pgexporter_pg_stat_statements_jit_stats_jit_generation_time ​

Total time spent in JIT code generation for this statement, in milliseconds.

pgexporter_pg_stat_statements_jit_stats_jit_inlining_count ​

Number of times JIT inlining was performed for this statement.

pgexporter_pg_stat_statements_jit_stats_jit_inlining_time ​

Total time spent in JIT inlining for this statement, in milliseconds.

pgexporter_pg_stat_statements_jit_stats_jit_optimization_count ​

Number of times JIT optimization was performed for this statement.

pgexporter_pg_stat_statements_jit_stats_jit_optimization_time ​

Total time spent in JIT optimization for this statement, in milliseconds.

pgexporter_pg_stat_statements_jit_stats_jit_emission_count ​

Number of times JIT emission was performed for this statement.

pgexporter_pg_stat_statements_jit_stats_jit_emission_time ​

Total time spent in JIT emission for this statement, in milliseconds.

pgexporter_pg_stat_statements_jit_summary_jit_enabled_queries ​

Reports the number of distinct queries tracked by pg_stat_statements that have utilized JIT compilation.

pgexporter_pg_stat_statements_jit_summary_total_jit_functions ​

The total number of functions that have been JIT-compiled across all tracked queries.

pgexporter_pg_stat_statements_jit_summary_total_jit_time ​

The total cumulative time in milliseconds spent on JIT compilation for all tracked queries.

pgexporter_pg_stat_statements_jit_summary_avg_jit_time ​

The average time in milliseconds spent on a single JIT compilation operation.