8.13. SQL Query and Statement Metrics #
Metrics based on the pg_stat_statements view:
postgresql.statements.blocks_read_time_millisecondspostgresql.statements.blocks_read_time_millisecondspostgresql.statements.callspostgresql.statements.exec_time_millisecondspostgresql.statements.jit_emission_countpostgresql.statements.jit_emission_time_millisecondspostgresql.statements.jit_functionspostgresql.statements.jit_generation_time_millisecondspostgresql.statements.jit_inlining_countpostgresql.statements.jit_inlining_time_millisecondspostgresql.statements.jit_optimization_countpostgresql.statements.jit_optimization_time_millisecondspostgresql.statements.local_blocks_dirtiedpostgresql.statements.local_blocks_hitpostgresql.statements.local_blocks_readpostgresql.statements.local_blocks_writtenpostgresql.statements.plan_time_millisecondspostgresql.statements.planspostgresql.statements.query_infopostgresql.statements.rowspostgresql.statements.shared_blocks_dirtiedpostgresql.statements.shared_blocks_hitpostgresql.statements.shared_blocks_readpostgresql.statements.shared_blocks_writtenpostgresql.statements.temp_blocks_read_time_millisecondspostgresql.statements.temp_blocks_readpostgresql.statements.temp_blocks_write_time_millisecondspostgresql.statements.temp_blocks_writtenpostgresql.statements.wal_bytespostgresql.statements.wal_fpipostgresql_.tatements.wal_records
Metrics based on the pgpro_stats_statements view:
postgresql.pgpro_statements.callspostgresql.pgpro_statements.rowspostgresql.pgpro_statements.exec_time_millisecondspostgresql.pgpro_statements.shared_blocks_read_time_millisecondspostgresql.pgpro_statements.shared_blocks_write_time_millisecondspostgresql.pgpro_statements.planspostgresql.pgpro_statements.plan_time_millisecondspostgresql.pgpro_statements.shared_blocks_hitpostgresql.pgpro_statements.shared_blocks_readpostgresql.pgpro_statements.shared_blocks_dirtiedpostgresql.pgpro_statements.shared_blocks_writtenpostgresql.pgpro_statements.local_blocks_hitpostgresql.pgpro_statements.local_blocks_readpostgresql.pgpro_statements.local_blocks_dirtiedpostgresql.pgpro_statements.local_blocks_writtenpostgresql.pgpro_statements.temp_blocks_readpostgresql.pgpro_statements.temp_blocks_writtenpostgresql.pgpro_statements.temp_blocks_read_time_millisecondspostgresql.pgpro_statements.temp_blocks_write_time_millisecondspostgresql.pgpro_statements.wal_recordspostgresql.pgpro_statements.wal_fpipostgresql.pgpro_statements.wal_bytespostgresql.pgpro_statements.jit_functionspostgresql.pgpro_statements.jit_generation_time_millisecondspostgresql.pgpro_statements.jit_inlining_countpostgresql.pgpro_statements.jit_inlining_time_millisecondspostgresql.pgpro_statements.jit_optimization_countpostgresql.pgpro_statements.jit_optimization_time_millisecondspostgresql.pgpro_statements.jit_emission_countpostgresql.pgpro_statements.jit_emission_time_millisecondspostgresql.pgpro_statements.query_infopostgresql.pgpro_statements.plan_infopostgresql.pgpro_statements.inval_msgs_totalpostgresql.pgpro_statements.inval_msgs_catcachepostgresql.pgpro_statements.inval_msgs_catalogpostgresql.pgpro_statements.inval_msgs_relcachepostgresql.pgpro_statements.inval_msgs_relcache_allpostgresql.pgpro_statements.inval_msgs_smgrpostgresql.pgpro_statements.inval_msgs_relmappostgresql.pgpro_statements.inval_msgs_snapshotpostgresql.pgpro_statements.rusage_readspostgresql.pgpro_statements.rusage_writespostgresql.pgpro_statements.rusage_user_time_millisecondspostgresql.pgpro_statements.rusage_system_time_millisecondspostgresql.pgpro_statements.rusage_minfltspostgresql.pgpro_statements.rusage_majfltspostgresql.pgpro_statements.rusage_nswapspostgresql.pgpro_statements.rusage_msgsndspostgresql.pgpro_statements.rusage_msgrcvspostgresql.pgpro_statements.rusage_nsignalspostgresql.pgpro_statements.rusage_nvcswspostgresql.pgpro_statements.rusage_nivcswspostgresql.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_millisecondspostgresql.pgpro_statements.local_blocks_read_time_millisecondspostgresql.statements.local_blocks_write_time_millisecondspostgresql.pgpro_statements.local_blocks_write_time_millisecondspostgresql.statements.jit_deform_countpostgresql.pgpro_statements.jit_deform_countpostgresql.statements.jit_deform_time_millisecondspostgresql.pgpro_statements.jit_deform_time_milliseconds
Starting from Postgres Pro and PostgreSQL 18, the following additional metrics are available:
postgresql.statements.parallel_workers_to_launchpostgresql.statements.parallel_workers_launchedpostgresql.pgpro_statements.parallel_workers_to_launchpostgresql.pgpro_statements.parallel_workers_launchedpostgresql.statements.wal_buffers_fullpostgresql.pgpro_statements.wal_buffers_full