Метрики на основе представления pg_stat_statements:
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
Метрики на основе представления pgpro_stats_statements :
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
Начиная с Postgres Pro и PostgreSQL 17, доступны следующие дополнительные метрики:
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
Начиная с Postgres Pro и PostgreSQL 18, доступны следующие дополнительные метрики:
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