Properties on Postgres Instances

Properties are grouped below by topic.

Activity and utilization

Name	Description	Typical values
activity_active_sessions	Active sessions percentage
activity_buffers_backend_write	Backend buffer writes per second
activity_buffers_backend_write_counter	Current backend buffer write counter
activity_buffers_checkpoint_write	Checkpoint buffer writes per second
activity_buffers_checkpoint_write_counter	Current checkpoint buffer write counter
activity_buffers_clean_write	Clean buffer writes per second
activity_buffers_clean_write_counter	Current clean buffer write counter
activity_buffers_totall_write	Total buffer writes per second
activity_buffers_write_lasttime	Last buffer write sample time in milliseconds since 1970
activity_dml_test	DML performance test task ID
activity_logical_reads	Logical reads per second
activity_logical_reads_activity	Activity score derived from logical reads
activity_logical_reads_counter	Current logical reads counter
activity_logical_reads_lasttime	Last logical read sample time in milliseconds since 1970
delete_avg	Average delete performance
disk_hit	Disk hits since the last sample
disk_hit_counter	Current disk hit counter
disk_hit_ratio	Disk hit ratio
disk_hit_ratio_lasttime	Last disk hit sample time in milliseconds since 1970
disk_usage	The approximate disk usage (in GB) for the instance	45.3
dml_perf_avg	Average DML performance
dml_perf_var	DML performance variation
dml_platform_comp	DML platform comparison
dml_test_count	Number of DML tests
insert_avg	Average insert performance
load_fifteen	15-minute load average
load_five	5-minute load average
load_one	1-minute load average
memory_usage	The approximate memory usage (in MB) for the instance	2450
one	Constant value one
sec_after_1970	Seconds since 1970
select_avg	Average select performance
total_session_count	The total number of sessions on the instance	12, 432
transactions_per_sec	Transactions per second
transactions_per_sec_counter	Current transaction counter
tup_del_per_sec	Deletes per second
tup_del_per_sec_counter	Current delete counter
tup_fet_per_sec	Fetches per second
tup_fet_per_sec_counter	Current fetch counter
tup_ins_per_sec	Inserts per second
tup_ins_per_sec_counter	Current insert counter
tup_per_sec_lasttime	Last tuple sample time in milliseconds since 1970
tup_ret_per_sec	Returns per second
tup_ret_per_sec_counter	Current return counter
tup_upd_per_sec	Updates per second
tup_upd_per_sec_counter	Current update counter
update_avg	Average update performance
version	PostgreSQL version

Collector jobs and maintenance

Name	Description	Typical values
pg_collector_analyze_check	Analyze check collector job
pg_collector_backup_check_ssh	SSH backup check collector job
pg_collector_pgdumpall_backup_job	pg_dumpall backup collector job
pg_stat_activity_type1
pg_stat_activity_type2
pg_stat_activity_type3
postgres_log_destinations_config_value	Log destinations configuration value
postgres_log_destinations_last_reconfige_date	Last log destinations reconfiguration date
postgres_log_destinations_reconfige_status	Log destinations reconfiguration status
postgres_log_destinations_trace_info	Log destinations trace info
priv_read_pg_stat_archiver	Whether pg_stat_archiver can be read
sc_alert_job_count	Alert job count
sc_disable_job_count	Disabled job count
sc_issues_count_current	Current issues count
sc_job_count	Job count
sc_task_id	Task ID
sc_task_id/sc_details	Task details
sc_task_id/sc_last_run	Last task run
sc_task_id/sc_name	Task name
sc_task_id/sc_status	Task status
sc_task_id/sc_status_job	Task status job
schema_debug_pretty_print_cmd_list	Pretty print command list
schema_debug_pretty_print_trace_info	Pretty print trace info
schema_debug_print_parse_cmd_list	Parse command list
schema_debug_print_parse_trace_info	Parse trace info
schema_debug_print_plan_cmd_list	Plan command list
schema_debug_print_plan_trace_info	Plan trace info
schema_debug_print_rewritten_cmd_list	Rewritten command list
schema_debug_print_rewritten_trace_info	Rewritten trace info
schema_growth_collector_db_list	Growth collector database list
schema_growth_collector_rows_count	Growth collector row count
schema_growth_collector_sch_list	Growth collector schema list
schema_growth_collector_trace_info	Growth collector trace info
schema_log_connections_cmd_list	Log connections command list
schema_log_connections_trace_info	Log connections trace info
schema_log_destinations_cmd_list	Log destinations command list
schema_log_destinations_trace_info	Log destinations trace info
schema_log_directory_cmd_list	Log directory command list
schema_log_directory_trace_info	Log directory trace info
schema_log_disconnections_cmd_list	Log disconnections command list
schema_log_disconnections_trace_info	Log disconnections trace info
schema_log_error_verbosity_cmd_list	Log error verbosity command list
schema_log_error_verbosity_trace_info	Log error verbosity trace info
schema_log_file_mode_cmd_list	Log file mode command list
schema_log_file_mode_trace_info	Log file mode trace info
schema_log_filename_cmd_list	Log filename command list
schema_log_filename_trace_info	Log filename trace info
schema_log_hostname_cmd_list	Log hostname command list
schema_log_hostname_trace_info	Log hostname trace info
schema_log_line_prefix_cmd_list	Log line prefix command list
schema_log_line_prefix_trace_info	Log line prefix trace info
schema_log_min_error_statement_cmd_list	Log min error statement command list
schema_log_min_error_statement_trace_info	Log min error statement trace info
schema_log_min_messages_cmd_list	Log min messages command list
schema_log_min_messages_trace_info	Log min messages trace info
schema_log_rotation_age_cmd_list	Log rotation age command list
schema_log_rotation_age_trace_info	Log rotation age trace info
schema_log_rotation_size_cmd_list	Log rotation size command list
schema_log_rotation_size_trace_info	Log rotation size trace info
schema_log_statement_cmd_list	Log statement command list
schema_log_statement_trace_info	Log statement trace info
schema_log_timezone_cmd_list	Log timezone command list
schema_log_timezone_trace_info	Log timezone trace info
schema_log_truncate_on_rotation_cmd_list	Log truncate on rotation command list
schema_log_truncate_on_rotation_trace_info	Log truncate on rotation trace info
schema_pgaudit_extension_cmd_list	pgaudit extension command list
schema_pgaudit_extension_trace_info	pgaudit extension trace info
schema_postgres_login_enabled_cmd_list	Postgres login enabled command list
schema_postgres_login_enabled_trace_info	Postgres login enabled trace info
schema_set_user_extention_cmd_list	Set user extension command list
schema_set_user_extention_trace_info	Set user extension trace info
schema_syslog_facility_cmd_list	Syslog facility command list
schema_syslog_facility_trace_info	Syslog facility trace info
schema_syslog_ident_cmd_list	Syslog ident command list
schema_syslog_ident_trace_info	Syslog ident trace info
schema_syslog_sequence_numbers_cmd_list	Syslog sequence numbers command list
schema_syslog_sequence_numbers_trace_info	Syslog sequence numbers trace info
schema_syslog_split_messages_cmd_list	Syslog split messages command list
schema_syslog_split_messages_trace_info	Syslog split messages trace info

Database and instance metadata

Name	Description	Typical values
database	Database name
db_count	The number of databases on the instance	23
dbhost	Database host name
edition	The edition of the instance	Standard Edition, Enterprise Edition
engine_edition	PostgreSQL
instance_class	Instance class
instance_started_sec_1970	Instance start time in seconds since 1970
is_awsrds	Whether the instance is on AWS RDS
is_enterprisedb	Whether EnterpriseDB is used
is_in_recovery	Whether the database is in recovery
is_patroni	Whether Patroni is detected
iscluster	Whether the instance is clustered
maj_version	Major PostgreSQL version
ostype_db	Operating system type for the database
platform_info	Platform and version info	PostgreSQL 17.1
platform_is_linux	Whether the platform is Linux
platform_is_windows	Whether the platform is Windows
server_addr	Server address
sid
started	A text representation of the start time for the instance	21.10.2020 11:39:16, 11.10.2023 11:47:08
system_identifier	System identifier
users	User names
version-hide

High availability and replication

Name	Description	Typical values
replication_delay_sec	Replication delay in seconds
replication_used	Number of replication connections

Performance, SQL, and waits

Name	Description	Typical values
disk_fetched	Disk fetches since the last sample
disk_fetched_counter	Current disk fetch counter
performance	Performance statistics
performance/bgwriter	Bgwriter statistics
performance/bgwriter/buffers_alloc	Buffers allocated
performance/bgwriter/buffers_backend	Buffers written by backends
performance/bgwriter/buffers_backend_fsync	Backend fsyncs
performance/bgwriter/buffers_checkpoint	Buffers written by checkpoints
performance/bgwriter/buffers_clean	Buffers written by the background writer
performance/bgwriter/checkpoint_sync_time	Checkpoint sync time
performance/bgwriter/checkpoint_write_time	Checkpoint write time
performance/bgwriter/checkpoints_req	Requested checkpoints
performance/bgwriter/checkpoints_timed	Timed checkpoints
performance/bgwriter/maxwritten_clean	Background writer maxwritten_clean count
performance/bgwriter/stats_reset	Bgwriter statistics reset time
performance/database	Database statistics
performance/database/database	Database statistics
performance/database/database/blk_read_time	Block read time
performance/database/database/blk_write_time	Block write time
performance/database/database/blks_hit	Buffer hits
performance/database/database/blks_read	Blocks read
performance/database/database/conflicts	Conflicts
performance/database/database/datid	Database ID
performance/database/database/deadlocks	Deadlocks
performance/database/database/numbackends	Number of backends
performance/database/database/stats_reset	Statistics reset time
performance/database/database/temp_bytes	Temporary bytes
performance/database/database/temp_files	Temporary files
performance/database/database/tup_deleted	Tuples deleted
performance/database/database/tup_fetched	Tuples fetched
performance/database/database/tup_inserted	Tuples inserted
performance/database/database/tup_returned	Tuples returned
performance/database/database/tup_updated	Tuples updated
performance/database/database/xact_commit	Transaction commits
performance/database/database/xact_rollback	Transaction rollbacks
performance/index	Index statistics
performance/index/index	Index statistics
performance/index/index/idx_blks_hit	Index block hits
performance/index/index/idx_blks_read	Index blocks read
performance/index/index/idx_scan	Index scans
performance/index/index/idx_tup_fetch	Index tuples fetched
performance/index/index/idx_tup_read	Index tuples read
performance/index/index/indexrelname	Index name
performance/index/index/relid	Relation ID
performance/index/index/relname	Relation name
performance/index/index/schemaname	Schema name
performance/table	Table statistics
performance/table/table	Table statistics
performance/table/table/analyze_count	Analyze count
performance/table/table/autoanalyze_count	Autoanalyze count
performance/table/table/autovacuum_count	Autovacuum count
performance/table/table/heap_blks_hit	Heap block hits
performance/table/table/heap_blks_read	Heap blocks read
performance/table/table/idx_blks_hit	Index block hits
performance/table/table/idx_blks_read	Index blocks read
performance/table/table/idx_scan	Index scans
performance/table/table/idx_tup_fetch	Index tuples fetched
performance/table/table/last_analyze	Last analyze time
performance/table/table/last_autovacuum	Last autovacuum time
performance/table/table/last_vacuum	Last vacuum time
performance/table/table/n_dead_tup	Dead tuples
performance/table/table/n_live_tup	Live tuples
performance/table/table/n_mod_since_analyze	Modifications since analyze
performance/table/table/n_tup_del	Tuples deleted
performance/table/table/n_tup_hot_upd	HOT updates
performance/table/table/n_tup_ins	Tuples inserted
performance/table/table/n_tup_upd	Tuples updated
performance/table/table/relname	Table name
performance/table/table/schemaname	Schema name
performance/table/table/seq_scan	Sequential scans
performance/table/table/seq_tup_read	Sequential tuples read
performance/table/table/tidx_blks_hit	TOAST index block hits
performance/table/table/tidx_blks_read	TOAST index blocks read
performance/table/table/toast_blks_hit	TOAST block hits
performance/table/table/toast_blks_read	TOAST blocks read
performance/table/table/vacuum_count	Vacuum count
sql_repository_size_mb	SQL repository size in MB
sql_statistics_avg_exec_time_ms	Average SQL execution time in ms
sql_statistics_exec_time_ms	SQL execution time in ms
sql_statistics_max_exec_time_ms	Maximum SQL execution time in ms

Schema and configuration

Name	Description	Typical values
issues_date	Issues history by date
issues_date/issues_count	Issue count
issues_per_day_histr_sec	Issues per day history
issues_per_day_histr_sec/histr_date	History date
issues_per_day_histr_sec/job_count	Job count
issues_per_day_histr_sec/job_warnings	Job warnings
issues_per_day_histr_sec/sc_warnings	Security and compliance warnings
schema_logging_collector_cmd_list	Logging collector command list
schema_logging_collector_trace_info	Logging collector trace info

Sessions and users

Name	Description	Typical values
inactive_session_count	Number of inactive sessions

Storage and objects

Name	Description	Typical values
param_max_connections	Maximum number of connections

Miscellaneous

Name	Description	Typical values
activity	Overall activity score
between_ninetwo_and_ninesix	Version between 9.2 and 9.6
listener_port	Listener port
newer_than_ninefour	Newer than 9.4
newer_than_ninesix	Newer than 9.6
newer_than_ninetwo	Newer than 9.2
older_than_ninesix	Older than 9.6
older_than_ninetwo	Older than 9.2