8.13. SQL Query and Statement Metrics #

Metrics based on the pg_stat_statements view:

  • postgresql.statements.blocks_read_time_milliseconds

  • postgresql.statements.blocks_read_time_milliseconds

  • postgresql.statements.calls

  • postgresql.statements.exec_time_milliseconds

  • postgresql.statements.jit_emission_count

  • postgresql.statements.jit_emission_time_milliseconds

  • postgresql.statements.jit_functions

  • postgresql.statements.jit_generation_time_milliseconds

  • postgresql.statements.jit_inlining_count

  • postgresql.statements.jit_inlining_time_milliseconds

  • postgresql.statements.jit_optimization_count

  • postgresql.statements.jit_optimization_time_milliseconds

  • postgresql.statements.local_blocks_dirtied

  • postgresql.statements.local_blocks_hit

  • postgresql.statements.local_blocks_read

  • postgresql.statements.local_blocks_written

  • postgresql.statements.plan_time_milliseconds

  • postgresql.statements.plans

  • postgresql.statements.query_info

  • postgresql.statements.rows

  • postgresql.statements.shared_blocks_dirtied

  • postgresql.statements.shared_blocks_hit

  • postgresql.statements.shared_blocks_read

  • postgresql.statements.shared_blocks_written

  • postgresql.statements.temp_blocks_read_time_milliseconds

  • postgresql.statements.temp_blocks_read

  • postgresql.statements.temp_blocks_write_time_milliseconds

  • postgresql.statements.temp_blocks_written

  • postgresql.statements.wal_bytes

  • postgresql.statements.wal_fpi

  • postgresql_.tatements.wal_records

Metrics based on the pgpro_stats_statements view:

  • postgresql.pgpro_statements.calls

  • postgresql.pgpro_statements.rows

  • postgresql.pgpro_statements.exec_time_milliseconds

  • postgresql.pgpro_statements.shared_blocks_read_time_milliseconds

  • postgresql.pgpro_statements.shared_blocks_write_time_milliseconds

  • postgresql.pgpro_statements.plans

  • postgresql.pgpro_statements.plan_time_milliseconds

  • postgresql.pgpro_statements.shared_blocks_hit

  • postgresql.pgpro_statements.shared_blocks_read

  • postgresql.pgpro_statements.shared_blocks_dirtied

  • postgresql.pgpro_statements.shared_blocks_written

  • postgresql.pgpro_statements.local_blocks_hit

  • postgresql.pgpro_statements.local_blocks_read

  • postgresql.pgpro_statements.local_blocks_dirtied

  • postgresql.pgpro_statements.local_blocks_written

  • postgresql.pgpro_statements.temp_blocks_read

  • postgresql.pgpro_statements.temp_blocks_written

  • postgresql.pgpro_statements.temp_blocks_read_time_milliseconds

  • postgresql.pgpro_statements.temp_blocks_write_time_milliseconds

  • postgresql.pgpro_statements.wal_records

  • postgresql.pgpro_statements.wal_fpi

  • postgresql.pgpro_statements.wal_bytes

  • postgresql.pgpro_statements.jit_functions

  • postgresql.pgpro_statements.jit_generation_time_milliseconds

  • postgresql.pgpro_statements.jit_inlining_count

  • postgresql.pgpro_statements.jit_inlining_time_milliseconds

  • postgresql.pgpro_statements.jit_optimization_count

  • postgresql.pgpro_statements.jit_optimization_time_milliseconds

  • postgresql.pgpro_statements.jit_emission_count

  • postgresql.pgpro_statements.jit_emission_time_milliseconds

  • postgresql.pgpro_statements.query_info

  • postgresql.pgpro_statements.plan_info

  • postgresql.pgpro_statements.inval_msgs_total

  • postgresql.pgpro_statements.inval_msgs_catcache

  • postgresql.pgpro_statements.inval_msgs_catalog

  • postgresql.pgpro_statements.inval_msgs_relcache

  • postgresql.pgpro_statements.inval_msgs_relcache_all

  • postgresql.pgpro_statements.inval_msgs_smgr

  • postgresql.pgpro_statements.inval_msgs_relmap

  • postgresql.pgpro_statements.inval_msgs_snapshot

  • postgresql.pgpro_statements.rusage_reads

  • postgresql.pgpro_statements.rusage_writes

  • postgresql.pgpro_statements.rusage_user_time_milliseconds

  • postgresql.pgpro_statements.rusage_system_time_milliseconds

  • postgresql.pgpro_statements.rusage_minflts

  • postgresql.pgpro_statements.rusage_majflts

  • postgresql.pgpro_statements.rusage_nswaps

  • postgresql.pgpro_statements.rusage_msgsnds

  • postgresql.pgpro_statements.rusage_msgrcvs

  • postgresql.pgpro_statements.rusage_nsignals

  • postgresql.pgpro_statements.rusage_nvcsws

  • postgresql.pgpro_statements.rusage_nivcsws

  • postgresql.pgpro_statements.wait_stats_milliseconds_total

Starting from Postgres Pro and PostgreSQL 17, the following additional metrics are available:

  • postgresql.statements.local_blocks_read_time_milliseconds

  • postgresql.pgpro_statements.local_blocks_read_time_milliseconds

  • postgresql.statements.local_blocks_write_time_milliseconds

  • postgresql.pgpro_statements.local_blocks_write_time_milliseconds

  • postgresql.statements.jit_deform_count

  • postgresql.pgpro_statements.jit_deform_count

  • postgresql.statements.jit_deform_time_milliseconds

  • postgresql.pgpro_statements.jit_deform_time_milliseconds

Starting from Postgres Pro and PostgreSQL 18, the following additional metrics are available:

  • postgresql.statements.parallel_workers_to_launch

  • postgresql.statements.parallel_workers_launched

  • postgresql.pgpro_statements.parallel_workers_to_launch

  • postgresql.pgpro_statements.parallel_workers_launched

  • postgresql.statements.wal_buffers_full

  • postgresql.pgpro_statements.wal_buffers_full