pgexporter

Appearance

pgexporter Internal Metrics ​

The main task of pgexporter is to gather metrics from your database and format it according to Prometheus metrics standards. pgexporter provides some built-in metrics that are necessary/useful, supports extension metrics, and also provides the capability of providing custom metrics to the user.

Table of Contents ​

General ​

Logging ​

Postgresql ​

pgexporter_state ​

Provides the operational status of the pgexporter service itself, indicating if it's running (1) or stopped/failed (0).

AttributeDescriptionValues
serverThe configured name/identifier for the PostgreSQL server.1: Running, 0: Stopped or encountered a fatal error during startup/runtime

pgexporter_logging_info ​

Counts the total number of informational (INFO level) log messages produced by pgexporter since its last startup.

pgexporter_logging_warn ​

Accumulates the total count of warning (WARN level) messages logged by pgexporter, potentially indicating recoverable issues.

pgexporter_logging_error ​

Tallies the total number of error (ERROR level) messages from pgexporter, often signaling problems needing investigation.

pgexporter_logging_fatal ​

Records the total count of fatal (FATAL level) errors encountered by pgexporter, usually indicating service termination.

pgexporter_version ​

Exposes the version of the running pgexporter service through labels.

AttributeDescription
pgexporter_versionThe semantic version string of the running pgexporter (e.g., "0.7.0").

pgexporter_postgresql_active ​

Reports if the monitored PostgreSQL instance is fully active (1) or in a recovery/non-operational state (0).

AttributeDescriptionValues
serverThe configured name/identifier for the PostgreSQL server being monitored.1: Server is active (not in recovery, accepting connections)., 0: Server is in recovery or otherwise not fully active.

pgexporter_postgresql_version ​

Displays the major and minor version numbers of the monitored PostgreSQL server via labels.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
versionMajor PostgreSQL version number (e.g., 16).
minor_versionMinor PostgreSQL version number (e.g., 8).
NoteThe metric value itself is often 1, the version info is in the labels.

pgexporter_postgresql_uptime ​

Measures the uptime of the monitored PostgreSQL server process in seconds since its last start.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_postgresql_primary ​

Identifies if the monitored PostgreSQL instance is operating as a primary (1, not in recovery) or a standby/replica (0, in recovery).

AttributeDescriptionValues
serverThe configured name/identifier for the PostgreSQL server.1: This server is the primary (not in recovery)., 0: This server is a replica/standby (in recovery).

pgexporter_pg_settings_allow_in_place_tablespaces ​

Reflects the PostgreSQL allow_in_place_tablespaces setting, allowing tablespaces inside pg_tblspc for testing (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_allow_system_table_mods ​

Represents the PostgreSQL allow_system_table_mods setting, permitting structural changes to system tables (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_application_name ​

Mirrors the PostgreSQL application_name setting, which defines the name reported in logs and statistics (value is typically 1, name is not in the metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_archive_cleanup_command ​

Corresponds to the PostgreSQL archive_cleanup_command setting, specifying a shell command executed at each restartpoint (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_archive_command ​

Represents the PostgreSQL archive_command setting, defining the shell command used to archive completed WAL files (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_archive_library ​

Mirrors the PostgreSQL archive_library setting, specifying a shared library for WAL archiving instead of a command (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_archive_mode ​

Reflects the PostgreSQL archive_mode setting, controlling WAL archiving behavior (0=off, 1=on, 2=always).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_archive_timeout ​

Shows the PostgreSQL archive_timeout setting, the maximum time in seconds to wait before forcing a WAL file switch (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_array_nulls ​

Corresponds to the PostgreSQL array_nulls setting, controlling whether NULL elements are allowed in array inputs (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_authentication_timeout ​

Represents the PostgreSQL authentication_timeout setting, the maximum time in seconds allowed for client authentication.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum ​

Reflects the PostgreSQL autovacuum setting, indicating if the autovacuum launcher process is enabled (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum_analyze_scale_factor ​

Shows the PostgreSQL autovacuum_analyze_scale_factor, the fraction of table size changes triggering an auto-analyze.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum_analyze_threshold ​

Represents the PostgreSQL autovacuum_analyze_threshold, the minimum number of row changes triggering an auto-analyze.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum_freeze_max_age ​

Mirrors the PostgreSQL autovacuum_freeze_max_age, the maximum transaction age before forcing autovacuum to prevent TXID wraparound.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum_max_workers ​

Reflects the PostgreSQL autovacuum_max_workers setting, the maximum number of concurrent autovacuum worker processes.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum_multixact_freeze_max_age ​

Shows the PostgreSQL autovacuum_multixact_freeze_max_age, the maximum multixact age before forcing autovacuum to prevent MultiXact wraparound.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum_naptime ​

Represents the PostgreSQL autovacuum_naptime setting, the sleep interval in seconds between autovacuum cycles.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum_vacuum_cost_delay ​

Corresponds to the PostgreSQL autovacuum_vacuum_cost_delay, the cost delay in milliseconds applied specifically to autovacuum (-1 uses vacuum_cost_delay).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum_vacuum_cost_limit ​

Mirrors the PostgreSQL autovacuum_vacuum_cost_limit, the cost limit applied specifically to autovacuum before sleeping (-1 uses vacuum_cost_limit).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum_vacuum_insert_scale_factor ​

Reflects the PostgreSQL autovacuum_vacuum_insert_scale_factor, the fraction of inserts triggering an insert autovacuum.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum_vacuum_insert_threshold ​

Shows the PostgreSQL autovacuum_vacuum_insert_threshold, the minimum number of inserts triggering an insert autovacuum (-1 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum_vacuum_scale_factor ​

Represents the PostgreSQL autovacuum_vacuum_scale_factor, the fraction of updates/deletes triggering an autovacuum.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum_vacuum_threshold ​

Corresponds to the PostgreSQL autovacuum_vacuum_threshold, the minimum number of updates/deletes triggering an autovacuum.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_autovacuum_work_mem ​

Mirrors the PostgreSQL autovacuum_work_mem setting, the maximum memory in kB per autovacuum worker process (-1 uses maintenance_work_mem).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_backend_flush_after ​

Reflects the PostgreSQL backend_flush_after setting, the number of pages written by a backend before attempting to flush OS caches (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_backslash_quote ​

Shows the PostgreSQL backslash_quote setting, controlling how \' is treated in string literals (0=off, 1=on, 2=safe_encoding).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_backtrace_functions ​

Represents the PostgreSQL backtrace_functions setting, a list of C functions for which to log backtraces on error (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_bgwriter_delay ​

Corresponds to the PostgreSQL bgwriter_delay setting, the sleep time in milliseconds between background writer activity rounds.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_bgwriter_flush_after ​

Mirrors the PostgreSQL bgwriter_flush_after setting, the number of pages written by the bgwriter before attempting to flush OS caches (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_bgwriter_lru_maxpages ​

Reflects the PostgreSQL bgwriter_lru_maxpages setting, the maximum number of LRU pages the bgwriter can flush per round.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_bgwriter_lru_multiplier ​

Shows the PostgreSQL bgwriter_lru_multiplier, a factor determining how many dirty buffers the bgwriter aims to clean per round.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_block_size ​

Displays the fundamental disk block size (in bytes) used by the PostgreSQL server (read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_bonjour ​

Represents the PostgreSQL bonjour setting, enabling server advertisement via Bonjour (mDNS) (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_bonjour_name ​

Corresponds to the PostgreSQL bonjour_name setting, specifying the Bonjour service name (defaults to computer name if empty, value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_bytea_output ​

Mirrors the PostgreSQL bytea_output setting, controlling the output format for bytea values (1=hex, 2=escape).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_check_function_bodies ​

Reflects the PostgreSQL check_function_bodies setting, enabling validation of function bodies during CREATE FUNCTION (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_checkpoint_completion_target ​

Shows the PostgreSQL checkpoint_completion_target, the fraction of the checkpoint interval over which checkpoint writes should be spread.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_checkpoint_flush_after ​

Represents the PostgreSQL checkpoint_flush_after setting, the number of pages written during a checkpoint before attempting to flush OS caches (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_checkpoint_timeout ​

Corresponds to the PostgreSQL checkpoint_timeout setting, the maximum time in seconds between automatic WAL checkpoints.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_checkpoint_warning ​

Mirrors the PostgreSQL checkpoint_warning setting, the time threshold in seconds for warning about checkpoints occurring too frequently (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_client_connection_check_interval ​

Reflects the PostgreSQL client_connection_check_interval setting, the interval in milliseconds for checking client disconnection during queries (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_client_encoding ​

Shows the PostgreSQL client_encoding setting for the connection pgexporter uses (value is typically 1, actual encoding not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_client_min_messages ​

Represents the PostgreSQL client_min_messages setting, the minimum severity level of messages sent to the client (numeric representation, e.g., 1=notice).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_cluster_name ​

Corresponds to the PostgreSQL cluster_name setting, an identifier included in the process title (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_commit_delay ​

Mirrors the PostgreSQL commit_delay setting, a delay in microseconds between commit and WAL flush, potentially allowing group commit.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_commit_siblings ​

Reflects the PostgreSQL commit_siblings setting, the minimum number of concurrent transactions required to activate commit_delay.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_compute_query_id ​

Shows the PostgreSQL compute_query_id setting, controlling whether query IDs are computed for monitoring purposes (0=off, 1=on, 2=regress).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_config_file ​

Represents the PostgreSQL config_file setting, the path to the main server configuration file (value 1, path not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_constraint_exclusion ​

Corresponds to the PostgreSQL constraint_exclusion setting, enabling query optimization using CHECK constraints (0=off, 1=partition, 2=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_cpu_index_tuple_cost ​

Mirrors the PostgreSQL cpu_index_tuple_cost, the planner's estimated CPU cost for processing one index entry.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_cpu_operator_cost ​

Reflects the PostgreSQL cpu_operator_cost, the planner's estimated CPU cost for processing one operator or function call.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_cpu_tuple_cost ​

Shows the PostgreSQL cpu_tuple_cost, the planner's estimated CPU cost for processing one tuple (row).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_createrole_self_grant ​

Represents the PostgreSQL createrole_self_grant setting, controlling automatic role granting upon creation (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_cursor_tuple_fraction ​

Corresponds to the PostgreSQL cursor_tuple_fraction, the planner's estimated fraction of rows retrieved from a cursor.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_data_checksums ​

Indicates if data checksums are enabled for this PostgreSQL cluster (0=off, 1=on, read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_data_directory ​

Shows the path to the PostgreSQL data directory (value 1, path not in metric, read-only at runtime).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_data_directory_mode ​

Displays the file system permissions (octal) of the PostgreSQL data directory (read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_data_sync_retry ​

Represents the PostgreSQL data_sync_retry setting, whether to continue after a data file sync failure (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_DateStyle ​

Corresponds to the PostgreSQL DateStyle setting, controlling the display format for date/time values (value 1, style not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_db_user_namespace ​

Mirrors the PostgreSQL db_user_namespace setting, enabling per-database usernames (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_deadlock_timeout ​

Reflects the PostgreSQL deadlock_timeout setting, the time in milliseconds to wait on a lock before checking for deadlocks.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_debug_assertions ​

Shows if the PostgreSQL server was compiled with assertion checks enabled (0=off, 1=on, read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_debug_discard_caches ​

Represents the PostgreSQL debug_discard_caches setting, used for debugging cache behavior (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_debug_io_direct ​

Corresponds to the PostgreSQL debug_io_direct setting, forcing direct I/O usage (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_debug_logical_replication_streaming ​

Mirrors the PostgreSQL debug_logical_replication_streaming setting for logical replication debugging (0=off, 1=on, 2=force_immediate).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_debug_parallel_query ​

Reflects the PostgreSQL debug_parallel_query setting, forcing parallel query plan usage for debugging (0=off, 1=on, 2=regress).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_debug_pretty_print ​

Shows the PostgreSQL debug_pretty_print setting, enabling indented output for debug plan/parse trees (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_debug_print_parse ​

Represents the PostgreSQL debug_print_parse setting, enabling logging of query parse trees (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_debug_print_plan ​

Corresponds to the PostgreSQL debug_print_plan setting, enabling logging of query execution plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_debug_print_rewritten ​

Mirrors the PostgreSQL debug_print_rewritten setting, enabling logging of query rewritten parse trees (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_default_statistics_target ​

Reflects the PostgreSQL default_statistics_target, the default number of samples used by ANALYZE for column statistics.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_default_table_access_method ​

Shows the PostgreSQL default_table_access_method setting for newly created tables (value 1, method name not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_default_tablespace ​

Represents the PostgreSQL default_tablespace setting, the default tablespace used if none is specified (value 1 if set, 0 if empty/pg_default).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_default_text_search_config ​

Corresponds to the PostgreSQL default_text_search_config setting, the default configuration for text search functions (value 1, config name not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_default_toast_compression ​

Mirrors the PostgreSQL default_toast_compression setting, the default compression method for TOASTable values (1=pglz, 2=lz4).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_default_transaction_deferrable ​

Reflects the PostgreSQL default_transaction_deferrable setting for new transactions (0=off/NOT DEFERRABLE, 1=on/DEFERRABLE).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_default_transaction_isolation ​

Shows the PostgreSQL default_transaction_isolation level for new transactions (numeric representation, e.g., 1 = read committed).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_default_transaction_read_only ​

Represents the PostgreSQL default_transaction_read_only status for new transactions (0=off/read write, 1=on/read only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_dynamic_library_path ​

Corresponds to the PostgreSQL dynamic_library_path setting, the search path for loadable modules (value 1, path not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_dynamic_shared_memory_type ​

Mirrors the PostgreSQL dynamic_shared_memory_type setting, the implementation used for dynamic shared memory (numeric representation, e.g., 1=posix).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_effective_cache_size ​

Reflects the PostgreSQL effective_cache_size setting, the planner's estimate of total available cache memory (in 8kB blocks).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_effective_io_concurrency ​

Shows the PostgreSQL effective_io_concurrency setting, the number of concurrent disk I/O operations the system can handle efficiently.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_async_append ​

Represents the PostgreSQL enable_async_append setting, allowing the planner to use asynchronous append plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_bitmapscan ​

Corresponds to the PostgreSQL enable_bitmapscan setting, allowing the planner to use bitmap index scan plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_gathermerge ​

Mirrors the PostgreSQL enable_gathermerge setting, allowing the planner to use gather merge plans for parallel queries (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_hashagg ​

Reflects the PostgreSQL enable_hashagg setting, allowing the planner to use hash aggregation plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_hashjoin ​

Shows the PostgreSQL enable_hashjoin setting, allowing the planner to use hash join plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_incremental_sort ​

Represents the PostgreSQL enable_incremental_sort setting, allowing the planner to use incremental sort steps (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_indexonlyscan ​

Corresponds to the PostgreSQL enable_indexonlyscan setting, allowing the planner to use index-only scan plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_indexscan ​

Mirrors the PostgreSQL enable_indexscan setting, allowing the planner to use regular index scan plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_material ​

Reflects the PostgreSQL enable_material setting, allowing the planner to use materialization steps (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_memoize ​

Shows the PostgreSQL enable_memoize setting, allowing the planner to use memoization for caching subplan results (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_mergejoin ​

Represents the PostgreSQL enable_mergejoin setting, allowing the planner to use merge join plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_nestloop ​

Corresponds to the PostgreSQL enable_nestloop setting, allowing the planner to use nested loop join plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_parallel_append ​

Mirrors the PostgreSQL enable_parallel_append setting, allowing the planner to use parallel append plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_parallel_hash ​

Reflects the PostgreSQL enable_parallel_hash setting, allowing the planner to use parallel hash join plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_partition_pruning ​

Shows the PostgreSQL enable_partition_pruning setting, enabling partition elimination optimizations (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_partitionwise_aggregate ​

Represents the PostgreSQL enable_partitionwise_aggregate setting, allowing partition-aware aggregation plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_partitionwise_join ​

Corresponds to the PostgreSQL enable_partitionwise_join setting, allowing partition-aware join plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_presorted_aggregate ​

Mirrors the PostgreSQL enable_presorted_aggregate setting, allowing optimization of aggregates with presorted input (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_seqscan ​

Reflects the PostgreSQL enable_seqscan setting, allowing the planner to use sequential scan plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_sort ​

Shows the PostgreSQL enable_sort setting, allowing the planner to use explicit sort steps (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_enable_tidscan ​

Represents the PostgreSQL enable_tidscan setting, allowing the planner to use TID scan plans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_escape_string_warning ​

Corresponds to the PostgreSQL escape_string_warning setting, controlling warnings for backslash escapes in standard strings (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_event_source ​

Mirrors the PostgreSQL event_source setting, the application name used for Windows Event Log messages (value 1, name not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_exit_on_error ​

Reflects the PostgreSQL exit_on_error setting, controlling whether a session terminates on any error (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_extension_destdir ​

Shows the PostgreSQL extension_destdir setting, a directory path prepended for extension script loading (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_external_pid_file ​

Represents the PostgreSQL external_pid_file setting, the location of an additional PID file (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_extra_float_digits ​

Corresponds to the PostgreSQL extra_float_digits setting, controlling the number of digits displayed for floating-point numbers.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_from_collapse_limit ​

Mirrors the PostgreSQL from_collapse_limit, the threshold beyond which the planner avoids collapsing subqueries in the FROM list.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_fsync ​

Reflects the PostgreSQL fsync setting, controlling whether updates are physically written to disk using fsync (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_full_page_writes ​

Shows the PostgreSQL full_page_writes setting, determining if full pages are written to WAL after checkpoints (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_geqo ​

Represents the PostgreSQL geqo setting, enabling the Genetic Query Optimizer for large joins (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_geqo_effort ​

Corresponds to the PostgreSQL geqo_effort setting, controlling the trade-off between planning time and query quality for GEQO (range 1-10).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_geqo_generations ​

Mirrors the PostgreSQL geqo_generations setting, the number of iterations used by GEQO (0 uses default).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_geqo_pool_size ​

Reflects the PostgreSQL geqo_pool_size setting, the number of individuals in the GEQO population (0 uses default).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_geqo_seed ​

Shows the PostgreSQL geqo_seed setting, the seed for the random number generator used by GEQO (range 0-1).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_geqo_selection_bias ​

Represents the PostgreSQL geqo_selection_bias, the selective pressure within the GEQO population (range 1.5-2.0).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_geqo_threshold ​

Corresponds to the PostgreSQL geqo_threshold, the number of FROM items triggering the use of GEQO.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_gin_fuzzy_search_limit ​

Mirrors the PostgreSQL gin_fuzzy_search_limit, the maximum result size for exact GIN searches (0 means no limit).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_gin_pending_list_limit ​

Reflects the PostgreSQL gin_pending_list_limit, the maximum size in kB of the pending list for GIN indexes.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_gss_accept_delegation ​

Shows the PostgreSQL gss_accept_delegation setting, controlling GSSAPI credential delegation acceptance (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_hash_mem_multiplier ​

Represents the PostgreSQL hash_mem_multiplier, a factor applied to work_mem determining memory limits for hash operations.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_hba_file ​

Corresponds to the PostgreSQL hba_file setting, the path to the client authentication configuration file (value 1, path not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_hot_standby ​

Mirrors the PostgreSQL hot_standby setting, enabling connections and queries on a standby server during recovery (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_hot_standby_feedback ​

Reflects the PostgreSQL hot_standby_feedback setting, allowing standby servers to send feedback to the primary to prevent query conflicts (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_huge_page_size ​

Shows the PostgreSQL huge_page_size setting, the requested size in kB for huge pages (0 uses default).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_huge_pages ​

Represents the PostgreSQL huge_pages setting, controlling the use of huge memory pages (0=off, 1=try, 2=require).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_icu_validation_level ​

Corresponds to the PostgreSQL icu_validation_level setting, the log level for reporting invalid ICU locale strings (numeric representation).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ident_file ​

Mirrors the PostgreSQL ident_file setting, the path to the ident authentication configuration file (value 1, path not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_idle_in_transaction_session_timeout ​

Reflects the PostgreSQL idle_in_transaction_session_timeout setting, the maximum idle time in milliseconds allowed within a transaction (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_idle_session_timeout ​

Shows the PostgreSQL idle_session_timeout setting, the maximum idle time in milliseconds allowed outside a transaction (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ignore_checksum_failure ​

Represents the PostgreSQL ignore_checksum_failure setting, determining if processing continues after a data checksum failure (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ignore_invalid_pages ​

Corresponds to the PostgreSQL ignore_invalid_pages setting, whether recovery continues after encountering invalid pages (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ignore_system_indexes ​

Mirrors the PostgreSQL ignore_system_indexes setting, disabling reads from system table indexes for debugging (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_in_hot_standby ​

Indicates if the server is currently operating in hot standby mode (0=off, 1=on, read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_integer_datetimes ​

Shows if the PostgreSQL server was built with 64-bit integer datetimes (0=off, 1=on, read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_IntervalStyle ​

Represents the PostgreSQL IntervalStyle setting, controlling the display format for interval values (numeric representation).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_jit ​

Corresponds to the PostgreSQL jit setting, enabling Just-In-Time compilation of queries (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_jit_above_cost ​

Mirrors the PostgreSQL jit_above_cost setting, the query cost threshold above which JIT compilation is attempted (-1 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_jit_debugging_support ​

Reflects the PostgreSQL jit_debugging_support setting, enabling registration of JIT functions with debuggers (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_jit_dump_bitcode ​

Shows the PostgreSQL jit_dump_bitcode setting, enabling output of LLVM bitcode for JIT debugging (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_jit_expressions ​

Represents the PostgreSQL jit_expressions setting, allowing JIT compilation of expressions (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_jit_inline_above_cost ​

Corresponds to the PostgreSQL jit_inline_above_cost setting, the query cost threshold for attempting JIT inlining (-1 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_jit_optimize_above_cost ​

Mirrors the PostgreSQL jit_optimize_above_cost setting, the query cost threshold for attempting JIT optimization (-1 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_jit_profiling_support ​

Reflects the PostgreSQL jit_profiling_support setting, enabling registration of JIT functions with perf profilers (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_jit_provider ​

Shows the PostgreSQL jit_provider setting, the JIT implementation library being used (value 1, provider name not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_jit_tuple_deforming ​

Represents the PostgreSQL jit_tuple_deforming setting, allowing JIT compilation for tuple deforming (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_join_collapse_limit ​

Corresponds to the PostgreSQL join_collapse_limit, the FROM-list size threshold beyond which explicit JOIN syntax is not flattened.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_krb_caseins_users ​

Mirrors the PostgreSQL krb_caseins_users setting, controlling case-insensitivity for Kerberos/GSSAPI usernames (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_krb_server_keyfile ​

Reflects the PostgreSQL krb_server_keyfile setting, the location of the Kerberos server keytab file (value 1, path not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_lc_messages ​

Shows the PostgreSQL lc_messages setting, the locale used for message display language (value 1, locale not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_lc_monetary ​

Represents the PostgreSQL lc_monetary setting, the locale used for formatting monetary amounts (value 1, locale not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_lc_numeric ​

Corresponds to the PostgreSQL lc_numeric setting, the locale used for formatting numbers (value 1, locale not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_lc_time ​

Mirrors the PostgreSQL lc_time setting, the locale used for formatting dates and times (value 1, locale not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_listen_addresses ​

Reflects the PostgreSQL listen_addresses setting, the IP addresses or hostnames the server listens on (value 1, addresses not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_lo_compat_privileges ​

Shows the PostgreSQL lo_compat_privileges setting, enabling backward compatibility for large object privilege checks (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_local_preload_libraries ​

Represents the PostgreSQL local_preload_libraries setting, libraries preloaded for non-superuser sessions (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_lock_timeout ​

Corresponds to the PostgreSQL lock_timeout setting, the maximum time in milliseconds to wait for any lock (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_autovacuum_min_duration ​

Mirrors the PostgreSQL log_autovacuum_min_duration setting, the minimum duration in milliseconds for logging autovacuum actions (-1 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_checkpoints ​

Reflects the PostgreSQL log_checkpoints setting, enabling logging of checkpoint start and end times (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_connections ​

Shows the PostgreSQL log_connections setting, enabling logging of successful client connections (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_destination ​

Represents the PostgreSQL log_destination setting, controlling where server logs are sent (value 1, destinations not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_directory ​

Corresponds to the PostgreSQL log_directory setting, the directory for log files when logging to files (value 1, path not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_disconnections ​

Mirrors the PostgreSQL log_disconnections setting, enabling logging of session disconnections and duration (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_duration ​

Reflects the PostgreSQL log_duration setting, enabling logging of the duration for every completed statement (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_error_verbosity ​

Shows the PostgreSQL log_error_verbosity setting, controlling the detail level of logged messages (numeric representation: 1=default, 2=verbose, 3=terse).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_executor_stats ​

Represents the PostgreSQL log_executor_stats setting, enabling logging of executor performance statistics (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_file_mode ​

Corresponds to the PostgreSQL log_file_mode setting, the file permissions (octal) for newly created log files.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_filename ​

Mirrors the PostgreSQL log_filename setting, the pattern for log file names (value 1, pattern not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_hostname ​

Reflects the PostgreSQL log_hostname setting, including the client hostname in connection logs (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_line_prefix ​

Shows the PostgreSQL log_line_prefix setting, a format string defining the prefix for each log line (value 1, format not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_lock_waits ​

Represents the PostgreSQL log_lock_waits setting, enabling logging when a session waits longer than deadlock_timeout for a lock (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_min_duration_sample ​

Corresponds to the PostgreSQL log_min_duration_sample setting, the minimum duration (ms) for sampled statement logging (-1 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_min_duration_statement ​

Mirrors the PostgreSQL log_min_duration_statement setting, the minimum statement duration (ms) to log unconditionally (-1 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_min_error_statement ​

Reflects the PostgreSQL log_min_error_statement, the minimum error severity level that causes the statement text to be logged (numeric representation).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_min_messages ​

Shows the PostgreSQL log_min_messages setting, the minimum message severity level written to the server log (numeric representation).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_parameter_max_length ​

Represents the PostgreSQL log_parameter_max_length, the maximum length (bytes) of bind parameters logged with statements (-1 unlimited, 0 disable).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_parameter_max_length_on_error ​

Corresponds to the PostgreSQL log_parameter_max_length_on_error, the maximum length (bytes) of bind parameters logged on error (-1 unlimited, 0 disable).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_parser_stats ​

Mirrors the PostgreSQL log_parser_stats setting, enabling logging of parser performance statistics (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_planner_stats ​

Reflects the PostgreSQL log_planner_stats setting, enabling logging of planner performance statistics (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_recovery_conflict_waits ​

Shows the PostgreSQL log_recovery_conflict_waits setting, enabling logging of waits due to recovery conflicts on standby (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_replication_commands ​

Represents the PostgreSQL log_replication_commands setting, enabling logging of each replication command (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_rotation_age ​

Corresponds to the PostgreSQL log_rotation_age setting, the maximum age (minutes) of a log file before rotation (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_rotation_size ​

Mirrors the PostgreSQL log_rotation_size setting, the maximum size (kB) of a log file before rotation (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_startup_progress_interval ​

Reflects the PostgreSQL log_startup_progress_interval setting, the interval (ms) for logging long-running startup operation progress (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_statement ​

Shows the PostgreSQL log_statement setting, controlling which SQL statements are logged (numeric representation: 1=none, 2=ddl, 3=mod, 4=all).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_statement_sample_rate ​

Represents the PostgreSQL log_statement_sample_rate, the fraction (0-1) of long statements (above sample threshold) to log.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_statement_stats ​

Corresponds to the PostgreSQL log_statement_stats setting, enabling logging of cumulative statement performance statistics (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_temp_files ​

Mirrors the PostgreSQL log_temp_files setting, logging temporary files larger than this size in kB (-1 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_timezone ​

Reflects the PostgreSQL log_timezone setting, the time zone used for timestamps in server logs (value 1, zone name not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_transaction_sample_rate ​

Shows the PostgreSQL log_transaction_sample_rate, the fraction (0-1) of transactions for which all statements are logged (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_log_truncate_on_rotation ​

Represents the PostgreSQL log_truncate_on_rotation setting, controlling whether log files are truncated or appended upon rotation (0=off/append, 1=on/truncate).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_logging_collector ​

Corresponds to the PostgreSQL logging_collector setting, enabling a dedicated process to capture log output (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_logical_decoding_work_mem ​

Mirrors the PostgreSQL logical_decoding_work_mem setting, the maximum memory in kB used for logical decoding operations.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_maintenance_io_concurrency ​

Reflects the PostgreSQL maintenance_io_concurrency setting, the effective_io_concurrency value used specifically for maintenance tasks.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_maintenance_work_mem ​

Shows the PostgreSQL maintenance_work_mem setting, the maximum memory in kB used for maintenance operations like VACUUM and CREATE INDEX.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_connections ​

Represents the PostgreSQL max_connections setting, the maximum number of concurrent client connections allowed.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_files_per_process ​

Corresponds to the PostgreSQL max_files_per_process setting, the maximum number of open files allowed per server process.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_function_args ​

Displays the maximum number of arguments allowed in a function definition (read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_identifier_length ​

Shows the maximum length in bytes allowed for identifiers (e.g., table names, column names) (read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_index_keys ​

Displays the maximum number of columns allowed in an index definition (read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_locks_per_transaction ​

Reflects the PostgreSQL max_locks_per_transaction setting, controlling the average number of object locks allocated per transaction.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_logical_replication_workers ​

Shows the PostgreSQL max_logical_replication_workers setting, the maximum number of logical replication worker processes system-wide.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_parallel_apply_workers_per_subscription ​

Represents the PostgreSQL max_parallel_apply_workers_per_subscription setting, the maximum parallel workers for logical replication apply per subscription.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_parallel_maintenance_workers ​

Corresponds to the PostgreSQL max_parallel_maintenance_workers setting, the maximum parallel workers usable by a single utility command.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_parallel_workers ​

Mirrors the PostgreSQL max_parallel_workers setting, the maximum total number of parallel workers available system-wide.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_parallel_workers_per_gather ​

Reflects the PostgreSQL max_parallel_workers_per_gather setting, the maximum parallel workers usable by a single Gather or Gather Merge node.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_pred_locks_per_page ​

Shows the PostgreSQL max_pred_locks_per_page setting, controlling predicate lock allocation per page for serializable transactions.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_pred_locks_per_relation ​

Represents the PostgreSQL max_pred_locks_per_relation setting, controlling predicate lock allocation per relation for serializable transactions.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_pred_locks_per_transaction ​

Corresponds to the PostgreSQL max_pred_locks_per_transaction setting, controlling predicate lock allocation per transaction for serializable transactions.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_prepared_transactions ​

Mirrors the PostgreSQL max_prepared_transactions setting, the maximum number of transactions that can be in the prepared state simultaneously (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_replication_slots ​

Reflects the PostgreSQL max_replication_slots setting, the maximum number of replication slots that can exist concurrently.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_slot_wal_keep_size ​

Shows the PostgreSQL max_slot_wal_keep_size setting, the maximum total size in MB of WAL files retained by replication slots (-1 unlimited).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_stack_depth ​

Represents the PostgreSQL max_stack_depth setting, the maximum safe stack depth in kilobytes for server processes.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_standby_archive_delay ​

Corresponds to the PostgreSQL max_standby_archive_delay, the maximum delay (ms) for canceling standby queries conflicting with WAL archive processing (-1 indefinite).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_standby_streaming_delay ​

Mirrors the PostgreSQL max_standby_streaming_delay, the maximum delay (ms) for canceling standby queries conflicting with WAL streaming (-1 indefinite).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_sync_workers_per_subscription ​

Reflects the PostgreSQL max_sync_workers_per_subscription setting, the maximum number of synchronization workers per logical replication subscription.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_wal_senders ​

Shows the PostgreSQL max_wal_senders setting, the maximum number of concurrent WAL sender processes.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_wal_size ​

Represents the PostgreSQL max_wal_size setting, the target maximum total WAL size in MB that triggers a checkpoint.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_max_worker_processes ​

Corresponds to the PostgreSQL max_worker_processes setting, the maximum number of background worker processes the system can support.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_min_dynamic_shared_memory ​

Mirrors the PostgreSQL min_dynamic_shared_memory setting, the amount of dynamic shared memory in MB reserved at startup (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_min_parallel_index_scan_size ​

Reflects the PostgreSQL min_parallel_index_scan_size, the minimum index size (in 8kB blocks) to consider for a parallel scan.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_min_parallel_table_scan_size ​

Shows the PostgreSQL min_parallel_table_scan_size, the minimum table size (in 8kB blocks) to consider for a parallel scan.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_min_wal_size ​

Represents the PostgreSQL min_wal_size setting, the minimum total WAL size in MB to maintain.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_old_snapshot_threshold ​

Corresponds to the PostgreSQL old_snapshot_threshold, the minimum time (minutes) a snapshot can be used without risk of snapshot too old errors (-1 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_parallel_leader_participation ​

Mirrors the PostgreSQL parallel_leader_participation setting, allowing the leader process to execute parallel plan nodes (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_parallel_setup_cost ​

Reflects the PostgreSQL parallel_setup_cost, the planner's estimated cost of launching parallel worker processes.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_parallel_tuple_cost ​

Shows the PostgreSQL parallel_tuple_cost, the planner's estimated cost of transferring one tuple between parallel workers.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_password_encryption ​

Represents the PostgreSQL password_encryption algorithm used for CREATE/ALTER USER (numeric representation: 1=scram-sha-256, 2=md5).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_pg_stat_statements_max ​

Reflects the PostgreSQL pg_stat_statements.max setting, the maximum number of statements tracked by pg_stat_statements extension.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_pg_stat_statements_save ​

Reflects the PostgreSQL pg_stat_statements.save setting, whether pg_stat_statements saves statistics across server shutdowns.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_pg_stat_statements_track ​

Reflects the PostgreSQL pg_stat_statements.track setting, which statements are tracked by pg_stat_statements.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_pg_stat_statements_track_planning ​

Reflects the PostgreSQL pg_stat_statements.track_planning setting, whether planning statistics are collected.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_pg_stat_statements_track_utility ​

Reflects the PostgreSQL pg_stat_statements.track_utility setting, whether utility commands are tracked.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_plan_cache_mode ​

Corresponds to the PostgreSQL plan_cache_mode, influencing when generic vs. custom plans are used for prepared statements (numeric representation: 1=auto, 2=force_custom, 3=force_generic).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_port ​

Displays the TCP port number the PostgreSQL server is listening on.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_post_auth_delay ​

Mirrors the PostgreSQL post_auth_delay setting, an artificial delay in seconds introduced after successful authentication.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_pre_auth_delay ​

Reflects the PostgreSQL pre_auth_delay setting, an artificial delay in seconds introduced before authentication begins.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_primary_conninfo ​

Shows the PostgreSQL primary_conninfo setting, the connection string used by a standby to connect to the primary (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_primary_slot_name ​

Represents the PostgreSQL primary_slot_name setting, the replication slot name used on the primary by a standby (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_quote_all_identifiers ​

Corresponds to the PostgreSQL quote_all_identifiers setting, forcing all identifiers to be quoted in SQL output, e.g., by pg_dump (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_random_page_cost ​

Mirrors the PostgreSQL random_page_cost, the planner's estimated cost of fetching a disk page non-sequentially.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_recovery_end_command ​

Reflects the PostgreSQL recovery_end_command, a shell command executed once at the successful completion of recovery (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_recovery_init_sync_method ​

Shows the PostgreSQL recovery_init_sync_method, how data files are synced before recovery starts (numeric representation: 1=fsync, 2=syncfs).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_recovery_min_apply_delay ​

Represents the PostgreSQL recovery_min_apply_delay, a minimum delay in milliseconds applied before replaying WAL records during recovery (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_recovery_prefetch ​

Corresponds to the PostgreSQL recovery_prefetch setting, enabling block prefetching during recovery (0=off, 1=on, 2=try).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_recovery_target ​

Mirrors the PostgreSQL recovery_target setting, currently only supports 'immediate' to stop recovery upon reaching consistency (value 1 if set to 'immediate', 0 otherwise).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_recovery_target_action ​

Reflects the PostgreSQL recovery_target_action, the server action upon reaching the recovery target (numeric representation: 1=pause, 2=promote, 3=shutdown).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_recovery_target_inclusive ​

Shows the PostgreSQL recovery_target_inclusive setting, controlling whether recovery stops just before (0=off) or just after (1=on) the target.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_recovery_target_lsn ​

Represents the PostgreSQL recovery_target_lsn, the LSN determining the recovery stop point (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_recovery_target_name ​

Corresponds to the PostgreSQL recovery_target_name, a named restore point determining the recovery stop point (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_recovery_target_time ​

Mirrors the PostgreSQL recovery_target_time, a timestamp determining the recovery stop point (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_recovery_target_timeline ​

Reflects the PostgreSQL recovery_target_timeline, specifying the timeline to recover into (numeric representation: 1=current, 2=latest).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_recovery_target_xid ​

Shows the PostgreSQL recovery_target_xid, a transaction ID determining the recovery stop point (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_recursive_worktable_factor ​

Represents the PostgreSQL recursive_worktable_factor, the planner's estimate of recursive query working table size relative to non-recursive term size.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_remove_temp_files_after_crash ​

Corresponds to the PostgreSQL remove_temp_files_after_crash setting, controlling automatic cleanup of temporary files post-crash (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_reserved_connections ​

Mirrors the PostgreSQL reserved_connections setting, the number of connection slots reserved for roles having pg_use_reserved_connections.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_restart_after_crash ​

Reflects the PostgreSQL restart_after_crash setting, determining if the server automatically restarts after a backend crash (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_restore_command ​

Shows the PostgreSQL restore_command, the shell command used to fetch archived WAL files during recovery (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_restrict_nonsystem_relation_kind ​

Represents the PostgreSQL restrict_nonsystem_relation_kind setting, prohibiting access to specific non-system relation types (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_row_security ​

Corresponds to the PostgreSQL row_security setting, enabling row-level security policy enforcement (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_scram_iterations ​

Mirrors the PostgreSQL scram_iterations setting, the iteration count used for SCRAM password hashing.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_search_path ​

Reflects the PostgreSQL search_path setting, the order of schemas searched for unqualified object names (value 1, path not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_segment_size ​

Displays the number of blocks constituting a single disk file segment (read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_send_abort_for_crash ​

Shows the PostgreSQL send_abort_for_crash setting, sending SIGABRT instead of SIGQUIT to children after a crash (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_send_abort_for_kill ​

Represents the PostgreSQL send_abort_for_kill setting, sending SIGABRT instead of SIGKILL to stuck children (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_seq_page_cost ​

Corresponds to the PostgreSQL seq_page_cost, the planner's estimated cost of fetching a disk page sequentially.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_server_encoding ​

Displays the character set encoding of the database server (value 1, encoding name not in metric, read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_server_version ​

Shows the PostgreSQL server version string (value 1, version string not in metric, read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_server_version_num ​

Displays the PostgreSQL server version as a numeric integer (read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_session_preload_libraries ​

Reflects the PostgreSQL session_preload_libraries setting, libraries preloaded at the start of each session (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_session_replication_role ​

Shows the PostgreSQL session_replication_role setting, controlling trigger and rule firing behavior (numeric representation: 1=origin, 2=replica, 3=local).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_shared_buffers ​

Represents the PostgreSQL shared_buffers setting, indicating the amount of memory dedicated to the shared buffer cache (in 8kB blocks).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_shared_memory_size ​

Displays the total size in MB of the server's main shared memory area (read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_shared_memory_size_in_huge_pages ​

Shows the estimated number of huge pages required for the main shared memory area (read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_shared_memory_type ​

Corresponds to the PostgreSQL shared_memory_type setting for the main shared memory region (numeric representation: 1=mmap, 2=sysv, 3=windows).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_shared_preload_libraries ​

Mirrors the PostgreSQL shared_preload_libraries setting, libraries preloaded at server start (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl ​

Reflects the PostgreSQL ssl setting, enabling SSL/TLS encrypted connections (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_ca_file ​

Shows the PostgreSQL ssl_ca_file setting, the path to the SSL Certificate Authority file (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_cert_file ​

Represents the PostgreSQL ssl_cert_file setting, the path to the server's SSL certificate file (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_ciphers ​

Corresponds to the PostgreSQL ssl_ciphers setting, the list of allowed SSL/TLS cipher suites (value 1, list not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_crl_dir ​

Mirrors the PostgreSQL ssl_crl_dir setting, the path to the directory containing SSL Certificate Revocation Lists (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_crl_file ​

Reflects the PostgreSQL ssl_crl_file setting, the path to the SSL Certificate Revocation List file (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_dh_params_file ​

Shows the PostgreSQL ssl_dh_params_file setting, the path to the Diffie-Hellman parameters file for SSL (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_ecdh_curve ​

Represents the PostgreSQL ssl_ecdh_curve setting, the curve used for ECDH key exchange (value 1, curve name not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_key_file ​

Corresponds to the PostgreSQL ssl_key_file setting, the path to the server's SSL private key file (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_library ​

Displays the name of the underlying SSL library being used (e.g., OpenSSL) (value 1, name not in metric, read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_max_protocol_version ​

Mirrors the PostgreSQL ssl_max_protocol_version setting, the maximum allowed SSL/TLS protocol version (numeric representation, 0=default).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_min_protocol_version ​

Reflects the PostgreSQL ssl_min_protocol_version setting, the minimum allowed SSL/TLS protocol version (numeric representation, 0=default).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_passphrase_command ​

Shows the PostgreSQL ssl_passphrase_command setting, an external command to retrieve SSL key passphrases (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_passphrase_command_supports_reload ​

Represents the PostgreSQL ssl_passphrase_command_supports_reload setting, indicating if the passphrase command is re-run on reload (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_ssl_prefer_server_ciphers ​

Corresponds to the PostgreSQL ssl_prefer_server_ciphers setting, preferring the server's cipher order during SSL negotiation (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_standard_conforming_strings ​

Mirrors the PostgreSQL standard_conforming_strings setting, controlling whether backslashes are treated literally in standard strings (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_statement_timeout ​

Reflects the PostgreSQL statement_timeout setting, the maximum execution time in milliseconds for any single statement (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_stats_fetch_consistency ​

Shows the PostgreSQL stats_fetch_consistency setting, controlling consistency guarantees when fetching statistics (numeric representation: 1=none, 2=cache, 3=snapshot).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_superuser_reserved_connections ​

Represents the PostgreSQL superuser_reserved_connections setting, the number of connection slots reserved exclusively for superusers.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_synchronize_seqscans ​

Corresponds to the PostgreSQL synchronize_seqscans setting, enabling synchronized sequential scans to potentially start reads at the same block (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_synchronous_commit ​

Mirrors the PostgreSQL synchronous_commit setting, the level of transaction commit synchronization (numeric representation, e.g., 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_synchronous_standby_names ​

Reflects the PostgreSQL synchronous_standby_names setting, the list defining synchronous standby servers (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_syslog_facility ​

Shows the PostgreSQL syslog_facility setting used when logging to syslog (numeric representation of facility).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_syslog_ident ​

Represents the PostgreSQL syslog_ident setting, the program identification string used in syslog messages (value 1, ident name not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_syslog_sequence_numbers ​

Corresponds to the PostgreSQL syslog_sequence_numbers setting, adding sequence numbers to syslog messages (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_syslog_split_messages ​

Mirrors the PostgreSQL syslog_split_messages setting, splitting long syslog messages into multiple lines (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_tcp_keepalives_count ​

Reflects the PostgreSQL tcp_keepalives_count setting, the number of TCP keepalive retransmits before considering the connection dead (0 uses system default).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_tcp_keepalives_idle ​

Shows the PostgreSQL tcp_keepalives_idle setting, the idle time in seconds before sending a TCP keepalive probe (0 uses system default).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_tcp_keepalives_interval ​

Represents the PostgreSQL tcp_keepalives_interval setting, the time in seconds between TCP keepalive retransmits (0 uses system default).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_tcp_user_timeout ​

Corresponds to the PostgreSQL tcp_user_timeout setting, the TCP user timeout in milliseconds (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_temp_buffers ​

Mirrors the PostgreSQL temp_buffers setting, the maximum amount of memory (in 8kB blocks) used for temporary buffers per session.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_temp_file_limit ​

Reflects the PostgreSQL temp_file_limit setting, the maximum total size in kB of temporary files usable per process (-1 unlimited).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_temp_tablespaces ​

Shows the PostgreSQL temp_tablespaces setting, the list of tablespaces used for temporary objects (value 1 if set, 0 if empty/default).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_auto_sparse_indexes ​

Reflects the TimescaleDB timescaledb.auto_sparse_indexes setting, automatically creating sparse indexes on compressed chunks (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_bgw_launcher_poll_time ​

Represents the TimescaleDB timescaledb.bgw_launcher_poll_time setting, the polling interval in milliseconds for the background worker launcher.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_bgw_log_level ​

Corresponds to the TimescaleDB timescaledb.bgw_log_level setting, the log level for TimescaleDB background workers (numeric representation).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_bgw_scheduler_restart_time ​

Mirrors the TimescaleDB timescaledb.bgw_scheduler_restart_time setting, the restart delay in seconds for the job scheduler if it crashes.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_compress_truncate_behaviour ​

Reflects the TimescaleDB timescaledb.compress_truncate_behaviour setting for compression truncation behavior.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_compression_batch_size_limit ​

Reflects the TimescaleDB timescaledb.compression_batch_size_limit setting for compression batch size limits.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_compression_orderby_default_function ​

Reflects the TimescaleDB timescaledb.compression_orderby_default_function setting, the function defining default ORDER BY columns for compression (value 1, function name not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_compression_segmentby_default_function ​

Shows the TimescaleDB timescaledb.compression_segmentby_default_function setting, the function defining default SEGMENT BY columns for compression (value 1, function name not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_debug_bgw_scheduler_exit_status ​

Represents the TimescaleDB timescaledb.debug_bgw_scheduler_exit_status setting, a debug parameter controlling the scheduler's exit code.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_debug_compression_path_info ​

Corresponds to the TimescaleDB timescaledb.debug_compression_path_info setting, enabling debug output for compression planning (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_default_hypercore_use_access_method ​

Mirrors the TimescaleDB timescaledb.default_hypercore_use_access_method setting, forcing usage of Hypercore TAM for compression (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_disable_load ​

Reflects the TimescaleDB timescaledb.disable_load setting, preventing the TimescaleDB extension from loading (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_bool_compression ​

Reflects the TimescaleDB timescaledb.enable_bool_compression setting for boolean compression.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_bulk_decompression ​

Shows the TimescaleDB timescaledb.enable_bulk_decompression setting, enabling optimized decompression of entire batches (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_cagg_create ​

Represents the TimescaleDB timescaledb.enable_cagg_create setting, allowing the creation of continuous aggregates (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_cagg_reorder_groupby ​

Corresponds to the TimescaleDB timescaledb.enable_cagg_reorder_groupby setting, enabling GROUP BY clause reordering optimization for CAGGs (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_cagg_sort_pushdown ​

Mirrors the TimescaleDB timescaledb.enable_cagg_sort_pushdown setting, enabling sort pushdown optimization for continuous aggregates (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_cagg_watermark_constify ​

Reflects the TimescaleDB timescaledb.enable_cagg_watermark_constify setting, enabling optimization of CAGG watermarks (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_cagg_window_functions ​

Reflects the TimescaleDB timescaledb.enable_cagg_window_functions setting for continuous aggregate window functions.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_chunk_append ​

Shows the TimescaleDB timescaledb.enable_chunk_append setting, enabling the custom ChunkAppend plan node (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_chunk_skipping ​

Represents the TimescaleDB timescaledb.enable_chunk_skipping setting, enabling skipping of unnecessary chunks during scans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_chunkwise_aggregation ​

Corresponds to the TimescaleDB timescaledb.enable_chunkwise_aggregation setting, enabling aggregation performed per-chunk (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_columnarscan ​

Mirrors the TimescaleDB timescaledb.enable_columnarscan setting, enabling columnar-optimized scans when applicable (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_compressed_direct_batch_delete ​

Reflects the TimescaleDB timescaledb.enable_compressed_direct_batch_delete setting, enabling optimized deletion of entire compressed batches (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_compressed_skipscan ​

Reflects the TimescaleDB timescaledb.enable_compressed_skipscan setting for compressed skip scan optimization.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_compression_indexscan ​

Shows the TimescaleDB timescaledb.enable_compression_indexscan setting, allowing index scans during compression operations (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_compression_ratio_warnings ​

Reflects the TimescaleDB timescaledb.enable_compression_ratio_warnings setting for compression ratio warnings.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_compression_wal_markers ​

Represents the TimescaleDB timescaledb.enable_compression_wal_markers setting, adding WAL markers for compression operations (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_compressor_batch_limit ​

Reflects the TimescaleDB timescaledb.enable_compressor_batch_limit setting for compressor batch limits.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_constraint_aware_append ​

Corresponds to the TimescaleDB timescaledb.enable_constraint_aware_append setting, enabling append plans that use constraints for pruning (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_constraint_exclusion ​

Mirrors the TimescaleDB timescaledb.enable_constraint_exclusion setting, enabling TimescaleDB-specific constraint exclusion (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_custom_hashagg ​

Reflects the TimescaleDB timescaledb.enable_custom_hashagg setting, enabling custom hash aggregation optimizations (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_decompression_sorted_merge ​

Shows the TimescaleDB timescaledb.enable_decompression_sorted_merge setting, enabling sorted merge for decompressed batches (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_delete_after_compression ​

Represents the TimescaleDB timescaledb.enable_delete_after_compression setting, using DELETE instead of TRUNCATE after compressing a chunk (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_deprecation_warnings ​

Corresponds to the TimescaleDB timescaledb.enable_deprecation_warnings setting, issuing warnings for deprecated features (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_dml_decompression ​

Mirrors the TimescaleDB timescaledb.enable_dml_decompression setting, enabling on-the-fly decompression for DML operations on compressed chunks (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_dml_decompression_tuple_filtering ​

Reflects the TimescaleDB timescaledb.enable_dml_decompression_tuple_filtering setting, enabling tuple filtering during DML decompression (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_event_triggers ​

Reflects the TimescaleDB timescaledb.enable_event_triggers setting for event triggers.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_exclusive_locking_recompression ​

Reflects the TimescaleDB timescaledb.enable_exclusive_locking_recompression setting for exclusive locking during recompression.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_foreign_key_propagation ​

Shows the TimescaleDB timescaledb.enable_foreign_key_propagation setting, enabling propagation of foreign key constraints to chunks (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_hypercore_scankey_pushdown ​

Represents the TimescaleDB timescaledb.enable_hypercore_scankey_pushdown setting, pushing down qualifiers to Hypercore TAM scans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_hypertable_compression ​

Corresponds to the TimescaleDB timescaledb.enable_hypertable_compression setting, allowing compression features to be used (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_hypertable_create ​

Mirrors the TimescaleDB timescaledb.enable_hypertable_create setting, allowing the creation of new hypertables (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_job_execution_logging ​

Reflects the TimescaleDB timescaledb.enable_job_execution_logging setting, enabling logging for background job executions (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_merge_on_cagg_refresh ​

Shows the TimescaleDB timescaledb.enable_merge_on_cagg_refresh setting, enabling use of MERGE statements during CAGG refresh (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_now_constify ​

Represents the TimescaleDB timescaledb.enable_now_constify setting, enabling optimization of now() calls in queries (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_optimizations ​

Corresponds to the TimescaleDB timescaledb.enable_optimizations setting, the master switch for enabling most TimescaleDB query optimizations (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_ordered_append ​

Mirrors the TimescaleDB timescaledb.enable_ordered_append setting, enabling optimized append plans that preserve sort order (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_parallel_chunk_append ​

Reflects the TimescaleDB timescaledb.enable_parallel_chunk_append setting, enabling parallel execution of ChunkAppend nodes (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_policy_create ​

Shows the TimescaleDB timescaledb.enable_policy_create setting, allowing creation of automation policies (e.g., compression, retention) (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_qual_propagation ​

Represents the TimescaleDB timescaledb.enable_qual_propagation setting, enabling propagation of query qualifiers down plan trees (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_rowlevel_compression_locking ​

Corresponds to the TimescaleDB timescaledb.enable_rowlevel_compression_locking setting, using row-level locks during compression (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_runtime_exclusion ​

Mirrors the TimescaleDB timescaledb.enable_runtime_exclusion setting, enabling chunk exclusion based on runtime parameters (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_segmentwise_recompression ​

Reflects the TimescaleDB timescaledb.enable_segmentwise_recompression setting, enabling recompression of individual segments (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_skipscan ​

Shows the TimescaleDB timescaledb.enable_skipscan setting, enabling SkipScan optimization for certain index scans (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_skipscan_for_distinct_aggregates ​

Reflects the TimescaleDB timescaledb.enable_skipscan_for_distinct_aggregates setting for skip scan optimization in distinct aggregates.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_sparse_index_bloom ​

Reflects the TimescaleDB timescaledb.enable_sparse_index_bloom setting for sparse index bloom filters.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_tiered_reads ​

Represents the TimescaleDB timescaledb.enable_tiered_reads setting, enabling queries against tiered storage (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_transparent_decompression ​

Corresponds to the TimescaleDB timescaledb.enable_transparent_decompression setting, automatically decompressing data during SELECT queries (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_tss_callbacks ​

Mirrors the TimescaleDB timescaledb.enable_tss_callbacks setting, enabling callbacks for ts_stat_statements (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_enable_vectorized_aggregation ​

Reflects the TimescaleDB timescaledb.enable_vectorized_aggregation setting, enabling vectorized aggregation optimizations (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_hypercore_arrow_cache_max_entries ​

Reflects the TimescaleDB timescaledb.hypercore_arrow_cache_max_entries setting for Arrow cache size.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_hypercore_copy_to_behavior ​

Shows the TimescaleDB timescaledb.hypercore_copy_to_behavior setting, controlling COPY TO behavior for Hypercore tables (numeric representation).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_hypercore_indexam_whitelist ​

Represents the TimescaleDB timescaledb.hypercore_indexam_whitelist, a list of index access methods compatible with Hypercore (value 1, list not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_last_tuned ​

Corresponds to the TimescaleDB timescaledb.last_tuned setting, the timestamp of the last timescaledb-tune execution (value 1, timestamp not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_last_tuned_version ​

Mirrors the TimescaleDB timescaledb.last_tuned_version setting, the version of timescaledb-tune last used (value 1, version not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_license ​

Reflects the TimescaleDB timescaledb.license key currently active (value 1, key type not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_materializations_per_refresh_window ​

Shows the TimescaleDB timescaledb.materializations_per_refresh_window setting, the maximum number of materializations per CAGG refresh window.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_max_background_workers ​

Represents the TimescaleDB timescaledb.max_background_workers setting, the maximum number of background workers TimescaleDB can use.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_max_cached_chunks_per_hypertable ​

Corresponds to the TimescaleDB timescaledb.max_cached_chunks_per_hypertable setting, the limit on cached chunk metadata per hypertable.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_max_open_chunks_per_insert ​

Mirrors the TimescaleDB timescaledb.max_open_chunks_per_insert setting, the maximum number of chunks kept open concurrently during inserts.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_max_tuples_decompressed_per_dml_transaction ​

Reflects the TimescaleDB timescaledb.max_tuples_decompressed_per_dml_transaction setting, the limit on tuples decompressed per DML transaction.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_restoring ​

Shows the TimescaleDB timescaledb.restoring setting, indicating if the extension is operating in restore mode (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_skip_scan_run_cost_multiplier ​

Reflects the TimescaleDB timescaledb.skip_scan_run_cost_multiplier setting for skip scan cost calculation.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_telemetry_level ​

Represents the TimescaleDB timescaledb.telemetry_level setting, controlling the level of telemetry data sent (numeric representation: 1=basic, 2=off).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_lake_disable_load ​

Reflects the TimescaleDB timescaledb.lake_disable_load setting for disabling lake loading.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_osm_disable_load ​

Reflects the TimescaleDB OpenStreetMap timescaledb_osm.disable_load setting, preventing the OSM extension from loading (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timescaledb_telemetry_cloud ​

Corresponds to the TimescaleDB timescaledb.telemetry.cloud setting, identifying the cloud provider environment if applicable (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_TimeZone ​

Mirrors the PostgreSQL TimeZone setting, the time zone used for displaying and interpreting timestamps (value 1, zone name not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_timezone_abbreviations ​

Reflects the PostgreSQL timezone_abbreviations setting, specifying the file containing time zone abbreviations (value 1, file name not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_trace_notify ​

Shows the PostgreSQL trace_notify setting, enabling debug output for LISTEN/NOTIFY operations (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_trace_recovery_messages ​

Represents the PostgreSQL trace_recovery_messages setting, the minimum severity level for logging recovery-related debug messages (numeric representation).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_trace_sort ​

Corresponds to the PostgreSQL trace_sort setting, enabling logging of resource usage during sort operations (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_track_activities ​

Mirrors the PostgreSQL track_activities setting, enabling collection of current command information for active sessions (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_track_activity_query_size ​

Reflects the PostgreSQL track_activity_query_size setting, the size in bytes reserved for storing active query text in pg_stat_activity.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_track_commit_timestamp ​

Shows the PostgreSQL track_commit_timestamp setting, enabling tracking of transaction commit timestamps (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_track_counts ​

Represents the PostgreSQL track_counts setting, enabling collection of table and index access statistics (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_track_functions ​

Corresponds to the PostgreSQL track_functions setting, controlling the level of function execution statistics tracking (numeric representation: 1=none, 2=pl, 3=all).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_track_io_timing ​

Mirrors the PostgreSQL track_io_timing setting, enabling collection of timing data for block I/O operations (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_track_wal_io_timing ​

Reflects the PostgreSQL track_wal_io_timing setting, enabling collection of timing data for WAL I/O operations (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_transaction_deferrable ​

Shows the PostgreSQL transaction_deferrable setting for the current transaction, allowing deferral of serializable read-only transactions (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_transaction_isolation ​

Represents the PostgreSQL transaction_isolation level for the current transaction (numeric representation, e.g., 1=read committed).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_transaction_read_only ​

Corresponds to the PostgreSQL transaction_read_only status for the current transaction (0=off/read write, 1=on/read only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_transform_null_equals ​

Mirrors the PostgreSQL transform_null_equals setting, treating expr = NULL as expr IS NULL (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_unix_socket_directories ​

Reflects the PostgreSQL unix_socket_directories setting, the directory paths for Unix-domain sockets (value 1, paths not in metric).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_unix_socket_group ​

Shows the PostgreSQL unix_socket_group setting, the group owner for Unix-domain sockets (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_unix_socket_permissions ​

Represents the PostgreSQL unix_socket_permissions setting, the access permissions (octal) for Unix-domain sockets.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_update_process_title ​

Corresponds to the PostgreSQL update_process_title setting, enabling updates to the process title to show the active command (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_vacuum_buffer_usage_limit ​

Mirrors the PostgreSQL vacuum_buffer_usage_limit setting, the size in kB of the special buffer pool used by VACUUM/ANALYZE.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_vacuum_cost_delay ​

Reflects the PostgreSQL vacuum_cost_delay, the duration in milliseconds that VACUUM pauses when its cost limit is reached.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_vacuum_cost_limit ​

Shows the PostgreSQL vacuum_cost_limit, the accumulated cost that causes VACUUM to pause.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_vacuum_cost_page_dirty ​

Represents the PostgreSQL vacuum_cost_page_dirty, the estimated cost for vacuuming a block that requires modification.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_vacuum_cost_page_hit ​

Corresponds to the PostgreSQL vacuum_cost_page_hit, the estimated cost for vacuuming a block already in shared buffers.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_vacuum_cost_page_miss ​

Mirrors the PostgreSQL vacuum_cost_page_miss, the estimated cost for vacuuming a block that must be read from disk.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_vacuum_failsafe_age ​

Reflects the PostgreSQL vacuum_failsafe_age, the transaction age triggering an emergency VACUUM to prevent wraparound.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_vacuum_freeze_min_age ​

Shows the PostgreSQL vacuum_freeze_min_age, the minimum transaction age before VACUUM considers freezing a tuple.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_vacuum_freeze_table_age ​

Represents the PostgreSQL vacuum_freeze_table_age, the transaction age triggering a full table scan by VACUUM to freeze tuples.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_vacuum_multixact_failsafe_age ​

Corresponds to the PostgreSQL vacuum_multixact_failsafe_age, the multixact age triggering an emergency VACUUM to prevent wraparound.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_vacuum_multixact_freeze_min_age ​

Mirrors the PostgreSQL vacuum_multixact_freeze_min_age, the minimum multixact age before VACUUM considers freezing a tuple's multixact ID.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_vacuum_multixact_freeze_table_age ​

Reflects the PostgreSQL vacuum_multixact_freeze_table_age, the multixact age triggering a full table scan by VACUUM to freeze multixact IDs.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_block_size ​

Displays the block size in bytes used within WAL files (read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_buffers ​

Shows the PostgreSQL wal_buffers setting, the amount of shared memory (in 8kB blocks) used for WAL data before writing to disk (-1 auto-tuned).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_compression ​

Represents the PostgreSQL wal_compression setting, enabling compression of full-page images written to WAL (0=off, 1=pglz, 2=lz4, 3=zstd).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_consistency_checking ​

Corresponds to the PostgreSQL wal_consistency_checking setting, enabling checks for specific WAL record types (value 1 if set, 0 if empty).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_decode_buffer_size ​

Mirrors the PostgreSQL wal_decode_buffer_size setting, the buffer size in bytes for WAL reading during recovery.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_init_zero ​

Reflects the PostgreSQL wal_init_zero setting, controlling whether new WAL files are pre-filled with zeros (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_keep_size ​

Shows the PostgreSQL wal_keep_size setting, the minimum total size in MB of past WAL files kept for standby servers.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_level ​

Represents the PostgreSQL wal_level setting, the amount of information written to WAL (numeric representation: 1=minimal, 2=replica, 3=logical).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_log_hints ​

Corresponds to the PostgreSQL wal_log_hints setting, forcing full-page writes for hint bit updates after checkpoints (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_receiver_create_temp_slot ​

Mirrors the PostgreSQL wal_receiver_create_temp_slot setting, allowing WAL receivers to create temporary slots if none is specified (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_receiver_status_interval ​

Reflects the PostgreSQL wal_receiver_status_interval, the maximum interval in seconds for standby status reports to the primary (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_receiver_timeout ​

Shows the PostgreSQL wal_receiver_timeout, the maximum time in milliseconds to wait for communication from the primary before disconnecting (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_recycle ​

Represents the PostgreSQL wal_recycle setting, enabling recycling (renaming) of WAL files instead of deleting them (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_retrieve_retry_interval ​

Corresponds to the PostgreSQL wal_retrieve_retry_interval, the delay in milliseconds before retrying failed WAL fetches during recovery.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_segment_size ​

Displays the size in bytes of individual WAL segment files (read-only).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_sender_timeout ​

Mirrors the PostgreSQL wal_sender_timeout, the maximum time in milliseconds to wait for activity on replication connections before disconnecting (0 disables).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_skip_threshold ​

Reflects the PostgreSQL wal_skip_threshold, the minimum file size in kB to skip WAL logging and use fsync instead for certain operations.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_sync_method ​

Shows the PostgreSQL wal_sync_method used to force WAL writes to disk (numeric representation, e.g., 1=fsync).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_writer_delay ​

Represents the PostgreSQL wal_writer_delay, the sleep time in milliseconds between WAL flushes performed by the WAL writer process.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_wal_writer_flush_after ​

Corresponds to the PostgreSQL wal_writer_flush_after, the amount of WAL (in 8kB blocks) that triggers a flush by the WAL writer.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_work_mem ​

Mirrors the PostgreSQL work_mem setting, the maximum amount of memory in kB used for internal sort operations and hash tables per query operation.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_xmlbinary ​

Reflects the PostgreSQL xmlbinary setting, controlling how binary values are encoded in XML (numeric representation: 1=base64, 2=hex).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_xmloption ​

Shows the PostgreSQL xmloption setting, determining if XML data is treated as documents or content fragments (numeric representation: 1=content, 2=document).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_settings_zero_damaged_pages ​

Represents the PostgreSQL zero_damaged_pages setting, allowing processing to continue past damaged page headers (use with extreme caution) (0=off, 1=on).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_postgresql_extension_info ​

Exposes information about installed PostgreSQL extensions, including their version and comment. The metric value is always 1.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
extensionThe name of the installed extension (e.g., "pg_stat_statements").
versionThe version string of the installed extension.
commentThe comment or description associated with the extension.

pgexporter_postgresql_primary ​

Identifies if the monitored PostgreSQL instance is operating as a primary (1, not in recovery) or a standby/replica (0, in recovery).

AttributeDescriptionValues
serverThe configured name/identifier for the PostgreSQL server.1: This server is the primary (not in recovery)., 0: This server is a replica/standby (in recovery).

pgexporter_pg_database_size ​

Reports the total disk space used by each database, measured in bytes.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database being measured.

pgexporter_pg_locks_count ​

Counts the current number of active locks, broken down by database and lock mode (e.g., AccessShareLock, RowExclusiveLock).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database being monitored.
modeThe lock mode (accesssharelock, rowsharelock, rowexclusivelock, etc.).

pgexporter_pg_replication_slots_active ​

Shows the activity status of defined replication slots.

AttributeDescriptionValues
serverThe configured name/identifier for the PostgreSQL server.1: Slot is active and being used by a connection., 0: Slot is inactive.
slot_nameThe name of the replication slot.
slot_typeThe type of replication (physical or logical).
databaseThe database associated with the slot (for logical slots).

pgexporter_pg_replication_slots_temporary ​

Indicates whether a defined replication slot is temporary or permanent.

AttributeDescriptionValues
serverThe configured name/identifier for the PostgreSQL server.1: Slot is temporary and will be removed on session exit or if unused., 0: Slot is permanent.
slot_nameThe name of the replication slot.
slot_typeThe type of replication (physical or logical).
databaseThe database associated with the slot (for logical slots).

pgexporter_pg_stat_bgwriter_buffers_alloc ​

Reflects buffers_alloc from pg_stat_bgwriter: the total number of buffers allocated directly by backend processes.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_bgwriter_buffers_backend ​

Reflects buffers_backend from pg_stat_bgwriter: the number of buffers written out directly by backend processes.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_bgwriter_buffers_backend_fsync ​

Reflects buffers_backend_fsync from pg_stat_bgwriter: the number of times backends had to execute their own fsync calls.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_bgwriter_buffers_checkpoint ​

Reflects buffers_checkpoint from pg_stat_bgwriter: the number of buffers written out during checkpoint processes.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_bgwriter_buffers_clean ​

Reflects buffers_clean from pg_stat_bgwriter: the number of buffers successfully written out by the background writer process.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_bgwriter_checkpoint_sync_time ​

Reflects checkpoint_sync_time from pg_stat_bgwriter: total time (ms) spent syncing files to disk during checkpoints.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_bgwriter_checkpoint_write_time ​

Reflects checkpoint_write_time from pg_stat_bgwriter: total time (ms) spent writing files to disk during checkpoints.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_bgwriter_checkpoints_req ​

Reflects checkpoints_req from pg_stat_bgwriter: the number of checkpoints initiated by explicit requests (e.g., CHECKPOINT command).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_bgwriter_checkpoints_timed ​

Reflects checkpoints_timed from pg_stat_bgwriter: the number of checkpoints initiated automatically based on time (checkpoint_timeout).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_bgwriter_maxwritten_clean ​

Reflects maxwritten_clean from pg_stat_bgwriter: the count of times the background writer stopped cleaning due to writing its limit (bgwriter_lru_maxpages).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_process_idle_seconds ​

Provides a histogram distribution of the duration (in seconds) that backend processes have been idle.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
application_nameThe application name reported by the idle process.
leThe upper bound of the histogram bucket (in seconds).

pgexporter_pg_available_extensions ​

Shows the total count of extensions available for installation in the current PostgreSQL instance.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_installed_extensions ​

Reports the total count of extensions currently installed in the connected database, with names listed in a label.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
extensionsComma-separated list of installed extension names (as a label).

pgexporter_pg_indexes ​

Counts the number of indexes defined on each table within each schema.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
schemanameThe name of the schema.
tablenameThe name of the table.

pgexporter_pg_matviews ​

Reports the count of materialized views that are currently populated (data is present).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
ispopulatedHardcoded to 't' in the query, indicating populated views.

pgexporter_pg_role ​

Provides the total number of roles (users and groups) defined within the PostgreSQL cluster.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_rule ​

Counts the number of rewrite rules defined for each table.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
tablenameThe name of the table associated with the rule(s).

pgexporter_pg_db_conn ​

Shows the current number of active backend connections established to each specific database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_db_conn_ssl ​

SSL connection status for database connections

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_statio_all_tables_heap_blks_read ​

Aggregates heap_blks_read from pg_statio_all_tables: total disk blocks read for all table heaps in the database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_statio_all_tables_heap_blks_hit ​

Aggregates heap_blks_hit from pg_statio_all_tables: total buffer cache hits for all table heaps in the database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_statio_all_tables_idx_blks_read ​

Aggregates idx_blks_read from pg_statio_all_tables: total disk blocks read for all table indexes in the database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_statio_all_tables_idx_blks_hit ​

Aggregates idx_blks_hit from pg_statio_all_tables: total buffer cache hits for all table indexes in the database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_statio_all_tables_toast_blks_read ​

Aggregates toast_blks_read from pg_statio_all_tables: total disk blocks read for all TOAST tables in the database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_statio_all_tables_toast_blks_hit ​

Aggregates toast_blks_hit from pg_statio_all_tables: total buffer cache hits for all TOAST tables in the database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_statio_all_tables_tidx_blks_read ​

Aggregates tidx_blks_read from pg_statio_all_tables: total disk blocks read for all TOAST table indexes in the database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_statio_all_tables_tidx_blks_hit ​

Aggregates tidx_blks_hit from pg_statio_all_tables: total buffer cache hits for all TOAST table indexes in the database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_statio_all_sequences_blks_read ​

Aggregates blks_read from pg_statio_all_sequences: total disk blocks read for all sequences in the database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_statio_all_sequences_blks_hit ​

Aggregates blks_hit from pg_statio_all_sequences: total buffer cache hits for all sequences in the database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_user_functions_calls ​

Reflects calls from pg_stat_user_functions: the number of times this specific user-defined function has been called.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
funcnameThe name of the user-defined function.

pgexporter_pg_stat_user_functions_self_time ​

Reflects self_time from pg_stat_user_functions: total time (ms) spent executing within the function itself (excludes time in called functions).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
funcnameThe name of the user-defined function.

pgexporter_pg_stat_user_functions_total_time ​

Reflects total_time from pg_stat_user_functions: total time (ms) spent executing the function, including time spent in functions it called.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
funcnameThe name of the user-defined function.

pgexporter_pg_stat_replication ​

Counts active WAL streaming replication connections, grouped by the application_name reported by the standby.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
application_nameThe application name reported by the replication connection.
stateHardcoded to 'streaming' in the query.

pgexporter_pg_stat_archiver_archived_count ​

Reflects archived_count from pg_stat_archiver: the total number of WAL files successfully archived since server start.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_archiver_success_time_elapsed_ms ​

Time elapsed (in milliseconds) since the last successful WAL file archival operation, based on pg_stat_archiver.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_archiver_failed_count ​

Reflects failed_count from pg_stat_archiver: the total number of failed WAL file archival attempts since server start.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_archiver_failure_time_elapsed_ms ​

Time elapsed (in milliseconds) since the last failed WAL file archival operation, based on pg_stat_archiver.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_db_vacuum_age ​

Represents the age (number of transactions) of the oldest unfrozen transaction ID (datfrozenxid) within each database. Useful for monitoring autovacuum progress and wraparound risk.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
datnameThe name of the database.

pgexporter_pg_view_vacuum_age ​

Reports the age (number of transactions) of the oldest unfrozen transaction ID (relfrozenxid) for each table or materialized view (including TOAST tables). Indicates need for vacuuming.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
datnameThe name of the relation (table or materialized view).

pgexporter_pg_blocked_vacuum_blocked_duration_seconds ​

Duration in seconds that vacuum operations have been blocked

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_blocked_vacuum_blocking_duration_seconds ​

Duration in seconds that operations are blocking vacuum

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_gss_auth ​

Counts the number of currently active database connections that authenticated using GSSAPI.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_encrypted_conn ​

Counts the number of currently active database connections that are encrypted using SSL/TLS.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_shmem_allocations ​

Provides a histogram distribution of shared memory allocation sizes made by the connected backend.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
leThe upper bound of the histogram bucket (derived from size calculation).

pgexporter_pg_stat_progress_vacuum_heap_blks_total ​

Total number of heap blocks to scan during vacuum operation

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
pidProcess ID of the vacuum operation.
datnameDatabase name being vacuumed.
usenameUsername running the vacuum.

pgexporter_pg_stat_progress_vacuum_heap_blks_scanned ​

Number of heap blocks scanned during vacuum operation

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
pidProcess ID of the vacuum operation.
datnameDatabase name being vacuumed.
usenameUsername running the vacuum.

pgexporter_pg_stat_progress_vacuum_heap_blks_vacuumed ​

Number of heap blocks vacuumed during vacuum operation

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
pidProcess ID of the vacuum operation.
datnameDatabase name being vacuumed.
usenameUsername running the vacuum.

pgexporter_pg_stat_progress_vacuum_index_vacuum_count ​

Number of index vacuum cycles completed

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
pidProcess ID of the vacuum operation.
datnameDatabase name being vacuumed.
usenameUsername running the vacuum.

pgexporter_pg_stat_progress_vacuum_max_dead_tuples ​

Maximum dead tuples that can be stored before vacuum must process indexes

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
pidProcess ID of the vacuum operation.
datnameDatabase name being vacuumed.
usenameUsername running the vacuum.

pgexporter_pg_stat_progress_vacuum_num_dead_tuples ​

Current number of dead tuples collected during vacuum

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
pidProcess ID of the vacuum operation.
datnameDatabase name being vacuumed.
usenameUsername running the vacuum.

pgexporter_pg_stat_progress_vacuum_pct_scan_completed ​

Percentage of heap scan completed during vacuum operation

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
pidProcess ID of the vacuum operation.
datnameDatabase name being vacuumed.
usenameUsername running the vacuum.

pgexporter_pg_stat_user_tables_vacuum_seq_scan ​

Reflects seq_scan from pg_stat_user_tables: the number of sequential scans initiated on this table.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_last_seq_scan_seconds ​

Time elapsed in seconds since the last sequential scan on this table. Based on last_seq_scan. -1 if never.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_seq_tup_read ​

Reflects seq_tup_read from pg_stat_user_tables: the number of live rows fetched by sequential scans.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_idx_scan ​

Reflects idx_scan from pg_stat_user_tables: the number of index scans initiated on this table.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_last_idx_scan_seconds ​

Time elapsed in seconds since the last index scan on this table. Based on last_idx_scan. -1 if never.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_idx_tup_fetch ​

Reflects idx_tup_fetch from pg_stat_user_tables: the number of live rows fetched by index scans.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_n_tup_ins ​

Reflects n_tup_ins from pg_stat_user_tables: the number of rows inserted in this table.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_n_tup_upd ​

Reflects n_tup_upd from pg_stat_user_tables: the number of rows updated in this table.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_n_tup_del ​

Reflects n_tup_del from pg_stat_user_tables: the number of rows deleted in this table.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_n_tup_hot_upd ​

Reflects n_tup_hot_upd from pg_stat_user_tables: the number of rows HOT updated in this table.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_n_tup_newpage_upd ​

Reflects n_tup_newpage_upd from pg_stat_user_tables: the number of rows updated to a new page in this table.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_n_live_tup ​

Reflects n_live_tup from pg_stat_user_tables: the estimated number of live rows in this table.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_n_dead_tup ​

Reflects n_dead_tup from pg_stat_user_tables: the estimated number of dead rows in this table.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_dead_rows_pct ​

A derived metric showing the percentage of dead rows relative to the total estimated rows in the table.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_n_mod_since_analyze ​

Reflects n_mod_since_analyze from pg_stat_user_tables: the estimated number of rows modified since this table was last analyzed.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_n_ins_since_vacuum ​

Reflects n_ins_since_vacuum from pg_stat_user_tables: the estimated number of rows inserted since this table was last vacuumed.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_last_vacuum_seconds ​

Time elapsed in seconds since this table was last manually vacuumed. Based on last_vacuum. -1 if never.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_last_autovacuum_seconds ​

Time elapsed in seconds since this table was last vacuumed by the autovacuum daemon. Based on last_autovacuum. -1 if never.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_last_analyze_seconds ​

Time elapsed in seconds since this table was last manually analyzed. Based on last_analyze. -1 if never.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_last_autoanalyze_seconds ​

Time elapsed in seconds since this table was last analyzed by the autovacuum daemon. Based on last_autoanalyze. -1 if never.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_vacuum_count ​

Reflects vacuum_count from pg_stat_user_tables: the number of times this table has been manually vacuumed.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_autovacuum_count ​

Reflects autovacuum_count from pg_stat_user_tables: the number of times this table has been vacuumed by the autovacuum daemon.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_analyze_count ​

Reflects analyze_count from pg_stat_user_tables: the number of times this table has been manually analyzed.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_stat_user_tables_vacuum_autoanalyze_count ​

Reflects autoanalyze_count from pg_stat_user_tables: the number of times this table has been analyzed by the autovacuum daemon.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe database containing the table.
schemanameThe schema containing the table.
relnameThe table name.

pgexporter_pg_table_bloat_table_size ​

Reports the actual total size of a table on disk, in bytes, including the main relation, TOAST table, and all indexes.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
schemanameThe name of the schema containing the table.
tblnameThe name of the table.

pgexporter_pg_table_bloat_bloat_size ​

Estimates the amount of wasted space (bloat) in a table, in bytes. A negative value may indicate a table that is smaller than estimated, which is normal.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
schemanameThe name of the schema containing the table.
tblnameThe name of the table.

pgexporter_pg_table_bloat_bloat_ratio_pct ​

The estimated bloat as a percentage of the total table size. High values suggest that a VACUUM or REINDEX could reclaim space.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
schemanameThe name of the schema containing the table.
tblnameThe name of the table.

pgexporter_pg_table_bloat_tblpages ​

The actual number of disk pages used by the table's main heap.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
schemanameThe name of the schema containing the table.
tblnameThe name of the table.

pgexporter_pg_table_bloat_est_tblpages ​

The estimated number of disk pages that the table should require, based on its contents and fillfactor.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
schemanameThe name of the schema containing the table.
tblnameThe name of the table.

pgexporter_pg_table_bloat_block_size ​

The server's block size in bytes, provided for context with page counts.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
schemanameThe name of the schema containing the table.
tblnameThe name of the table.

pgexporter_pg_mem_ctx_contexts ​

Reports the count of memory contexts, grouped by parent context name, within the backend pgexporter connects to.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
parentThe name of the parent memory context.

pgexporter_pg_mem_ctx_free_bytes ​

Reports the total amount of free space (in bytes) within memory contexts, grouped by parent context name, for the connected backend.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
parentThe name of the parent memory context.

pgexporter_pg_mem_ctx_used_bytes ​

Reports the total amount of used space (in bytes) within memory contexts, grouped by parent context name, for the connected backend.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
parentThe name of the parent memory context.

pgexporter_pg_mem_ctx_total_bytes ​

Reports the total allocated size (in bytes) of memory contexts, grouped by parent context name, for the connected backend.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
parentThe name of the parent memory context.

pgexporter_pg_stat_wal_wal_records ​

Reflects wal_records from pg_stat_wal: the total number of WAL records generated since the last statistics reset.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_wal_wal_fpi ​

Reflects wal_fpi from pg_stat_wal: the total number of WAL full-page images generated since the last statistics reset.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_wal_wal_bytes ​

Reflects wal_bytes from pg_stat_wal: the total volume of WAL generated in bytes since the last statistics reset.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_wal_wal_buffers_full ​

Reflects wal_buffers_full from pg_stat_wal: the number of times WAL writes occurred because the WAL buffers were full.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_wal_wal_write ​

Reflects wal_write from pg_stat_wal: the number of times WAL buffers were written to disk via explicit WAL write requests.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_wal_wal_sync ​

Reflects wal_sync from pg_stat_wal: the number of times WAL files were explicitly synced to disk.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_wal_wal_write_time ​

Reflects wal_write_time from pg_stat_wal: total time (ms) spent writing WAL buffers to disk (requires track_wal_io_timing).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_wal_wal_sync_time ​

Reflects wal_sync_time from pg_stat_wal: total time (ms) spent syncing WAL files to disk (requires track_wal_io_timing).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_database_blk_read_time ​

Reflects blk_read_time from pg_stat_database: total time (ms) backends spent reading data blocks in this database (requires track_io_timing).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_blk_write_time ​

Reflects blk_write_time from pg_stat_database: total time (ms) backends spent writing data blocks in this database (requires track_io_timing).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_blks_hit ​

Reflects blks_hit from pg_stat_database: total number of buffer cache hits (reads satisfied from cache) in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_blks_read ​

Reflects blks_read from pg_stat_database: total number of data blocks read from disk (cache misses) in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_deadlocks ​

Reflects deadlocks from pg_stat_database: total number of deadlocks detected within this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_temp_files ​

Reflects temp_files from pg_stat_database: total number of temporary files created by queries in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_temp_bytes ​

Reflects temp_bytes from pg_stat_database: total amount of data (bytes) written to temporary files by queries in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_tup_returned ​

Reflects tup_returned from pg_stat_database: total number of rows returned (yielded) by queries executed in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_tup_fetched ​

Reflects tup_fetched from pg_stat_database: total number of rows fetched (read from tables) by queries executed in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_tup_inserted ​

Reflects tup_inserted from pg_stat_database: total number of rows inserted by queries executed in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_tup_updated ​

Reflects tup_updated from pg_stat_database: total number of rows updated by queries executed in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_tup_deleted ​

Reflects tup_deleted from pg_stat_database: total number of rows deleted by queries executed in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_xact_commit ​

Reflects xact_commit from pg_stat_database: total number of transactions committed in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_xact_rollback ​

Reflects xact_rollback from pg_stat_database: total number of transactions rolled back in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_conflicts ​

Reflects conflicts from pg_stat_database: total number of queries canceled due to recovery conflicts in this database (sum of specific conflict types).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_numbackends ​

Shows the current number of active backend processes connected to this specific database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_checksum_failures ​

Reflects checksum_failures from pg_stat_database: total number of data block checksum failures detected in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_session_time ​

Reflects session_time from pg_stat_database: total time (ms) spent by all sessions connected to this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_active_time ​

Reflects active_time from pg_stat_database: total time (ms) sessions spent actively executing SQL statements in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_idle_in_transaction_time ​

Reflects idle_in_transaction_time from pg_stat_database: total time (ms) sessions spent idle within an open transaction in this database.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_sessions ​

Reflects sessions from pg_stat_database: total cumulative number of sessions established to this database since statistics were reset.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_sessions_abandoned ​

Reflects sessions_abandoned from pg_stat_database: total number of sessions to this database terminated due to client connection failures.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_sessions_fatal ​

Reflects sessions_fatal from pg_stat_database: total number of sessions to this database terminated by unrecoverable errors.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_sessions_killed ​

Reflects sessions_killed from pg_stat_database: total number of sessions to this database terminated by administrator command.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_wal_prefetch_reset ​

Time elapsed (in seconds) since WAL prefetch statistics (pg_stat_get_wal_prefetch()) were last reset.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_gssapi_credentials_delegated ​

Counts the number of currently active database connections that have delegated GSSAPI credentials.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.

pgexporter_pg_stat_io_reads ​

Counts the total read operations performed, sourced from pg_stat_io and aggregated by backend type (e.g., client backend, autovacuum worker).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend (e.g., client backend, autovacuum worker, checkpointer).

pgexporter_pg_stat_io_read_time ​

Aggregates total time (ms) spent by backend types performing read I/O operations (from pg_stat_io, requires track_io_timing).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend.

pgexporter_pg_stat_io_writes ​

Counts the total write operations performed, sourced from pg_stat_io and aggregated by backend type.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend.

pgexporter_pg_stat_io_write_time ​

Aggregates total time (ms) spent by backend types performing write I/O operations (from pg_stat_io, requires track_io_timing).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend.

pgexporter_pg_stat_io_writebacks ​

Counts the total OS-level writeback requests initiated, sourced from pg_stat_io and aggregated by backend type.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend.

pgexporter_pg_stat_io_writeback_time ​

Aggregates total time (ms) spent by backend types performing writeback operations (from pg_stat_io, requires track_io_timing).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend.

pgexporter_pg_stat_io_extends ​

Counts the total relation file extension operations performed, sourced from pg_stat_io and aggregated by backend type.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend.

pgexporter_pg_stat_io_extend_time ​

Aggregates total time (ms) spent by backend types performing relation extension operations (from pg_stat_io, requires track_io_timing).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend.

pgexporter_pg_stat_io_op_bytes ​

Reports the size (typically 8192 bytes) associated with I/O operations tracked by pg_stat_io, per backend type.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend.

pgexporter_pg_stat_io_hits ​

Counts the total number of shared buffer cache hits, sourced from pg_stat_io and aggregated by backend type.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend.

pgexporter_pg_stat_io_evictions ​

Counts the total number of buffer blocks evicted from caches, sourced from pg_stat_io and aggregated by backend type.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend.

pgexporter_pg_stat_io_reuses ​

Counts the total number of times buffers in I/O ring buffers were reused, sourced from pg_stat_io and aggregated by backend type.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend.

pgexporter_pg_stat_io_fsyncs ​

Counts the total number of fsync calls made, sourced from pg_stat_io and aggregated by backend type.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend.

pgexporter_pg_stat_io_fsync_time ​

Aggregates total time (ms) spent by backend types performing fsync operations (from pg_stat_io, requires track_io_timing).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
backend_typeType of backend.

pgexporter_pg_stat_database_conflicts_confl_tablespace ​

Reflects confl_tablespace from pg_stat_database_conflicts: number of queries canceled due to dropped tablespaces during recovery.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_conflicts_confl_lock ​

Reflects confl_lock from pg_stat_database_conflicts: number of queries canceled due to lock timeouts during recovery.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_conflicts_confl_snapshot ​

Reflects confl_snapshot from pg_stat_database_conflicts: number of queries canceled due to old snapshots during recovery.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_conflicts_confl_bufferpin ​

Reflects confl_bufferpin from pg_stat_database_conflicts: number of queries canceled due to pinned buffers during recovery.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_conflicts_confl_deadlock ​

Reflects confl_deadlock from pg_stat_database_conflicts: number of queries canceled due to deadlocks during recovery.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_database_conflicts_confl_active_logicalslot ​

Reflects confl_active_logicalslot from pg_stat_database_conflicts: number of queries canceled due to active logical replication slots during recovery.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
databaseThe name of the database.

pgexporter_pg_stat_all_indexes_idx_scans ​

Aggregates idx_scan from pg_stat_all_indexes: total number of index scans initiated on all indexes for this relation.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
relnameThe name of the table or materialized view the index belongs to.

pgexporter_pg_stat_all_indexes_idx_tup_reads ​

Aggregates idx_tup_read from pg_stat_all_indexes: total number of index entries returned by scans on all indexes for this relation.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
relnameThe name of the table or materialized view the index belongs to.

pgexporter_pg_stat_all_indexes_idx_tup_fetchs ​

Aggregates idx_tup_fetch from pg_stat_all_indexes: total number of live table rows fetched by index scans using this relation's indexes.

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
relnameThe name of the table or materialized view the index belongs to.

pgexporter_pg_stat_all_indexes_time_elapsed_ms ​

Time elapsed (in milliseconds) since the last index scan occurred on any index of this relation (based on pg_stat_get_last_idx_scan_time).

AttributeDescription
serverThe configured name/identifier for the PostgreSQL server.
relnameThe name of the table or materialized view the index belongs to.

Custom Metrics ​

pgexporter supports user-defined custom metrics through YAML configuration files. These allow you to create tailored metrics for your specific PostgreSQL monitoring needs.

For detailed information about custom metrics, including schema definitions, configuration examples, and usage instructions, see the Custom Metrics Guide.