PostgreSQL Variables

List of PostgreSQL Variables

NOTE: You can click on the variable name to jump to its definition

pgsql-auditlog_filename

Base filename for the PostgreSQL audit log.

Description: The full path and base name for the files where PostgreSQL audit logs will be stored.

pgsql-auditlog_filesize

Maximum size of the PostgreSQL audit log file.

Description: Specifies the size limit for individual PostgreSQL audit log files before they are rotated.

pgsql-aurora_max_lag_ms_only_read_from_replicas

Dynamic integer, default 2, accepted range 0 to 100. When latency-aware routing is active, this is the minimum number of eligible PostgreSQL replicas required before routing considers the lowest-lag subset. Out-of-range values are rejected.

pgsql-authentication_method

Defines the authentication method ProxySQL should use for backend connections.

Description: Configures the authentication protocol used between ProxySQL and backend PostgreSQL servers. Common values: 1 (No Password), 2 (Clear Text), 3 (SASL/SCRAM).

pgsql-auto_increment_delay_multiplex

Number of queries to disable multiplexing after an insert with auto-increment.

Description: Temporarily disables multiplexing for a session after an auto-increment value is generated, ensuring subsequent queries see the new value.

pgsql-auto_increment_delay_multiplex_timeout_ms

Dynamic integer in milliseconds, default 10000, accepted range 0 to 3600000. It bounds how long a PostgreSQL session remains excluded from multiplexing after the delayed-multiplex condition is set; 0 disables the time bound. Out-of-range values are rejected. See Multiplexing.

pgsql-autocommit_false_is_transaction

Dynamic Boolean, default false. This released compatibility variable is accepted, but PostgreSQL transaction state is derived from protocol state and the audited implementation does not apply this MySQL autocommit policy. Invalid Boolean values are rejected.

pgsql-autocommit_false_not_reusable

Dynamic Boolean, default false. This released compatibility variable is accepted, but the audited PostgreSQL pool does not use it to decide connection reuse. Invalid Boolean values are rejected.

pgsql-automatic_detect_sqli

Enables automatic detection of SQL injection attempts for PostgreSQL.

Description: When enabled, ProxySQL analyzes PostgreSQL queries for potential SQL injection patterns and takes action based on configured rules.

pgsql-binlog_reader_connect_retry_msec

Dynamic integer in milliseconds, default 3000, accepted range 200 to 120000. PostgreSQL has no binlog reader, so the setting is a released compatibility surface with no PostgreSQL runtime effect. Out-of-range values are rejected.

pgsql-client_host_cache_size

Size of the cache for PostgreSQL client host information.

Description: Configures the maximum number of entries in the client host cache, used for tracking client-specific errors and connection attempts.

pgsql-client_host_error_counts

Threshold for consecutive errors from a client host before taking action.

Description: Specifies the number of connection errors allowed from a specific client host before ProxySQL begins blocking or limiting further connections from that source.

pgsql-commands_stats

Enables collection of command-level statistics for PostgreSQL.

Description: Controls whether ProxySQL tracks performance metrics for individual PostgreSQL command types.

pgsql-connect_retries_delay

Delay in milliseconds between connection retry attempts.

Description: Sets the pause time between consecutive attempts to connect to a PostgreSQL backend server.

pgsql-connect_retries_on_failure

The number of times ProxySQL will retry connecting to a backend server before giving up.

Description: Defines the maximum number of retry attempts for establishing a new connection to a backend server.

pgsql-connect_timeout_client

Timeout in milliseconds for client connections to ProxySQL during PostgreSQL protocol handshake establishment.

Description: The maximum time ProxySQL will wait for a client to complete the PostgreSQL protocol handshake and establish a connection. This timeout is enforced when a client connection is in CONNECTING_CLIENT status and encompasses the entire connection establishment process, including SSL negotiation if enabled.

pgsql-connect_timeout_server

Default timeout in milliseconds for connecting to PostgreSQL backend servers.

Description: The default timeout for establishing connections from ProxySQL to PostgreSQL backend servers. This timeout applies to all new connections initiated by ProxySQL and can be overridden per-hostgroup or per-server configuration.

pgsql-connect_timeout_server_max

Maximum timeout in milliseconds for connecting to PostgreSQL backend servers. This variable enforces an absolute upper limit on connection attempts to prevent indefinite blocking.

Description: The maximum timeout for connecting from ProxySQL to PostgreSQL backends in a hostgroup. When ProxySQL tries to establish a connection to a backend, individual attempts can timeout after pgsql-connect_timeout_server milliseconds, and ProxySQL will retry according to pgsql-connect_retries_on_failure and pgsql-connect_retries_delay. However, when the cumulative time reaches pgsql-connect_timeout_server_max milliseconds, all retry attempts cease and an error is returned to the client with the message “Max connect timeout reached while reaching hostgroup…”.

pgsql-connection_delay_multiplex_ms

Delay in milliseconds before enabling multiplexing for a new connection.

Description: Specifies a delay (in milliseconds) after a connection is established before it can be used for multiplexing. This can be useful for applications that set session variables immediately after connecting.

pgsql-connection_max_age_ms

Maximum age in milliseconds for a backend connection.

Description: The maximum time (in milliseconds) a backend connection can stay open. Once this limit is reached, the connection is closed and a new one is established. A value of 0 disables this feature. Connections are only checked and removed when they become idle; active connections are not interrupted regardless of age.

pgsql-connection_warming

Enables background connection establishment to keep the connection pool “warm”.

Description: When enabled, ProxySQL will proactively open connections to backend servers to ensure a minimum number of connections are always ready for incoming requests.

pgsql-default_max_latency_ms

Default maximum latency for backend PostgreSQL servers.

Description: The default maximum latency allowed for a PostgreSQL backend server before it is considered too far and excluded from the routing pool.

pgsql-default_query_delay

Dynamic integer in milliseconds, default 0, accepted range 0 to 3600000. It delays PostgreSQL queries when no query rule supplies another delay; 0 disables the delay. Out-of-range values are rejected. See PostgreSQL query rules.

pgsql-default_query_timeout

Default timeout in milliseconds for PostgreSQL queries.

Description: The default maximum time ProxySQL will wait for a query to complete if no timeout is specified in the query rules. When exceeded, the running query is terminated on the backend server and the client receives a query error. This limit applies per-query, measured from when the query is sent to the backend.

pgsql-default_reconnect

Dynamic Boolean, default true. It is exposed for configuration compatibility; the audited PostgreSQL session path does not use it as a client reconnect policy. Invalid Boolean values are rejected.

pgsql-default_schema

Dynamic non-empty string, default information_schema. The released setter stores the value, but propagation to PostgreSQL worker session defaults is disabled in the audited implementation, so it does not select PostgreSQL search_path. Empty values are rejected; use pgsql-default_search_path for tracked backend state.

pgsql-enforce_autocommit_on_reads

Dynamic Boolean, default false. This MySQL-compatible policy name is accepted but is not applied by the audited PostgreSQL query path. PostgreSQL transaction state follows protocol commands. Invalid Boolean values are rejected.

pgsql-eventslog_default_log

Dynamic integer enum, default 0, accepted values 0 and 1. Value 1 logs PostgreSQL statements by default when no query rule makes a different event-log decision; 0 requires an explicit logging decision. Other values are rejected. See Query Logging.

pgsql-eventslog_filename

Base filename for the PostgreSQL events log.

Description: The full path and base name for the files where PostgreSQL event logs will be stored.

pgsql-eventslog_filesize

Maximum size of the PostgreSQL events log file.

Description: Defines the maximum size allowed for PostgreSQL event log files before rotation.

pgsql-eventslog_format

Format of the PostgreSQL events log.

Description: Sets the logging format for PostgreSQL events. Currently, only format 1 (Binary) is supported.

pgsql-firewall_whitelist_enabled

Enables the firewall whitelist for PostgreSQL.

Description: When enabled, ProxySQL enforces a whitelist of allowed PostgreSQL queries, blocking any that are not explicitly permitted.

pgsql-free_connections_pct

The percentage of open idle connections to keep in the connection pool.

Description: Controls the percentage of idle connections that ProxySQL maintains in the connection pool relative to max_connections. This helps in managing resource usage while keeping enough connections ready for new requests. ProxySQL will remove excess free connections when the idle pool exceeds this percentage threshold, ensuring that backend connections are available for reuse without consuming unnecessary resources.

pgsql-handle_unknown_charset

Dynamic integer enum, default 1, accepted range 0 through the released HANDLE_UNKNOWN_CHARSET maximum. This MySQL character-set compatibility policy is not consulted by PostgreSQL encoding negotiation in the audited implementation; invalid enum values are rejected.

pgsql-have_compress

Dynamic Boolean, default true, accepting true/1 and false/0. PostgreSQL protocol compression is not implemented in the audited release, so this compatibility flag does not enable wire compression. Other values are rejected.

pgsql-have_ssl

Indicates PostgreSQL SSL support availability and configuration status.

Description: Read-only variable indicating whether ProxySQL was compiled with SSL support for PostgreSQL connections. This variable serves as a gateway indicator that must be true for all PostgreSQL SSL functionality to operate, including client-to-proxy and proxy-to-server encryption.

pgsql-hostgroup_manager_verbose

Enables verbose logging for the PostgreSQL hostgroup manager.

Description: Controls the verbosity of logs generated by the PostgreSQL hostgroup management module. Higher values provide more detailed information.

pgsql-init_connect

SQL strings to be executed when a new backend connection is established.

Description: A string of one or more SQL statements to be executed by ProxySQL for each PostgreSQL client that connects.

pgsql-interfaces

Network interfaces to listen on for PostgreSQL client connections.

Description: Comma-separated list of IP addresses and ports that ProxySQL should listen on for PostgreSQL client connections. This variable controls the PostgreSQL protocol listener interfaces and is dynamic, meaning changes take effect immediately without requiring a ProxySQL restart.

pgsql-kill_backend_connection_when_disconnect

Kills the backend connection immediately upon client disconnect.

Description: If enabled, ProxySQL will close the associated backend connection as soon as the client disconnects, rather than returning it to the pool. When disabled (default), backend connections remain available in the pool for reuse by other clients, which improves performance through connection reuse. When enabled, each client gets a fresh backend connection, which may increase connection overhead to the backend servers.

pgsql-log_unhealthy_connections

Controls whether ProxySQL logs unhealthy connections to PostgreSQL backends.

Description: When enabled, ProxySQL logs details about connection attempts to backend servers that fail or are deemed unhealthy.

pgsql-long_query_time

Threshold in milliseconds for slow query logging.

Description: If a query takes longer than this value to execute, it is considered a slow query and the slow query counter is incremented. This only affects statistics collection visible in stats_pgsql_query_digest; queries are NOT terminated based on this threshold. Use pgsql-default_query_timeout or query rule timeouts to terminate long-running queries.

pgsql-max_allowed_packet

Maximum size of a single network packet for PostgreSQL.

Description: Sets the upper limit for the size of a single PostgreSQL protocol packet that ProxySQL will handle.

pgsql-max_connections

Maximum number of concurrent client connections for PostgreSQL protocol.

Description: Maximum number of concurrent PostgreSQL client connections that ProxySQL will accept and maintain. This critical limit protects both ProxySQL and backend PostgreSQL servers from resource exhaustion while providing predictable system capacity.

pgsql-max_stmts_cache

Maximum number of prepared statements to cache per thread.

Description: Limits the total number of PostgreSQL prepared statements that can be cached across all backend connections within a single thread.

pgsql-max_stmts_per_connection

Maximum number of prepared statements per backend connection.

Description: Limits how many unique prepared statements a single backend connection can maintain simultaneously.

pgsql-max_transaction_idle_time

Maximum time a transaction can be idle in PostgreSQL.

Description: Specifies the maximum duration (in milliseconds) a PostgreSQL transaction can remain idle before ProxySQL terminates the connection. When a transaction is idle longer than this threshold, the client connection is terminated to prevent resource leaks. Only applies to sessions with active transactions; sessions without active transactions are controlled by pgsql-wait_timeout instead.

pgsql-max_transaction_time

Maximum duration for a PostgreSQL transaction.

Description: Sets the absolute maximum time (in milliseconds) a PostgreSQL transaction is allowed to run before being terminated. This is a hard limit that applies to the total duration of a transaction, measured from when the first statement begins. When exceeded, the client connection is terminated regardless of whether the transaction is currently active or idle.

pgsql-min_num_servers_lantency_awareness

Dynamic integer (the published name retains the historical lantency spelling), default 1000, accepted range 0 to 10000. Latency-aware PostgreSQL server selection is used only when at least this many candidates exist; 0 disables the minimum gate. Out-of-range values are rejected.

pgsql-mirror_max_concurrency

Maximum concurrent requests for mirrored sessions.

Description: Limits the number of simultaneous mirrored sessions to prevent resource exhaustion during traffic mirroring.

pgsql-mirror_max_queue_length

Maximum number of queries queued for mirroring.

Description: Sets the upper limit for the number of PostgreSQL queries waiting in the mirror queue. New mirroring requests are dropped if this limit is reached.

pgsql-multiplexing

Global switch for PostgreSQL connection multiplexing.

Description: Master toggle for PostgreSQL multiplexing. When enabled, ProxySQL can reuse backend connections for different client sessions when they are in an idle state.

pgsql-ping_interval_server_msec

Interval in milliseconds for sending ping checks to PostgreSQL backends.

Description: The frequency at which ProxySQL sends internal pings to PostgreSQL backend servers to maintain connection health.

pgsql-ping_timeout_server

Timeout in milliseconds for internal PostgreSQL backend pings.

Description: The maximum time ProxySQL will wait for a response to an internal ping before considering the backend connection timed out.

pgsql-poll_timeout

Description: Controls how frequently the worker thread checks for network activity on client and backend connections. This is the maximum time the thread will wait for new events before processing queued tasks and performing maintenance. Lower values reduce latency at the cost of increased CPU usage; higher values improve CPU efficiency but may delay response to network events.

pgsql-poll_timeout_on_failure

Wait time in milliseconds after a polling error.

Description: The duration ProxySQL will wait before re-polling after a connection or network failure occurs during PostgreSQL traffic handling. When backend connections cannot be established, the poll timeout is temporarily reduced to this value to detect connection establishment or failure more quickly. Once connections are established, the normal pgsql-poll_timeout is restored.

pgsql-query_cache_handle_warnings

Controls whether queries that generate warnings are cached.

Description: When set to 1, ProxySQL will cache query results even if they include warnings. If set to 0, queries with warnings are not cached.

pgsql-query_cache_size_mb

Size of the PostgreSQL query cache in megabytes.

Description: Configures the total amount of memory allocated for caching PostgreSQL query results.

pgsql-query_cache_soft_ttl_pct

Defines the percentage of a cache entry’s hard TTL after which ProxySQL may serve the still-valid value while one request performs a single-flight refresh. 0 disables soft-TTL refresh. Invalid values are rejected. See Query Cache.

pgsql-query_cache_stores_empty_result

Controls whether the PostgreSQL query cache should store empty resultsets.

Description: When enabled, ProxySQL will cache query results that return zero rows. This can be beneficial for reducing backend load for queries that frequently return no data.

pgsql-query_digests

Enables or disables PostgreSQL query digest collection.

Description: When enabled, ProxySQL collects query digests for PostgreSQL traffic, which are visible in the stats_pgsql_query_digest table.

pgsql-query_digests_grouping_limit

Limit for the number of parameters to group in a single query digest.

Description: Controls the maximum number of parameters ProxySQL will consolidate when generating a normalized query digest for PostgreSQL.

pgsql-query_digests_keep_comment

Boolean, dynamic, default false. When enabled, ProxySQL retains the first SQL comment in PostgreSQL digest text; invalid Boolean values are rejected. See the stats_pgsql_query_digest table in PostgreSQL statistics.

pgsql-query_digests_lowercase

Converts queries to lowercase before digest calculation.

Description: If set to true, PostgreSQL queries are normalized to lowercase before generating their digest.

pgsql-query_digests_max_digest_length

Maximum length of the generated query digest text.

Description: Defines the maximum number of characters ProxySQL will store for a normalized PostgreSQL query digest.

pgsql-query_digests_max_query_length

Maximum query length to be considered for digest calculation.

Description: Queries longer than this value will be truncated before being processed for digest generation.

pgsql-query_digests_no_digits

Boolean, dynamic, default false. When enabled, numeric digits are removed as part of PostgreSQL digest normalization. Invalid Boolean values are rejected.

pgsql-query_digests_normalize_digest_text

Boolean, dynamic, default false. Enables normalized digest-text storage for PostgreSQL query statistics. Invalid Boolean values are rejected.

pgsql-query_digests_replace_null

Boolean, dynamic, default false. Enables replacement of NULL literals during PostgreSQL digest normalization. Invalid Boolean values are rejected.

pgsql-query_digests_track_hostname

Boolean, dynamic, default false. Adds the client hostname dimension to PostgreSQL digest tracking. Invalid Boolean values are rejected; enabling it can increase digest cardinality.

pgsql-query_processor_iterations

Dynamic integer, default 0, accepted range 0 to 1000000. It limits repeated passes through PostgreSQL query rules; 0 uses the normal single pass. Out-of-range values are rejected. See PostgreSQL query rules.

pgsql-query_processor_regex

Dynamic integer enum, default 1, accepted values 1 and 2. It selects the regular-expression engine used by PostgreSQL query rules. Other values are rejected.

pgsql-query_retries_on_failure

The number of times a query is retried upon failure.

Description: Defines how many times ProxySQL will attempt to re-execute a query if it fails due to a connection error with the backend. When a query fails on a connection error, ProxySQL automatically retries the query on a new backend connection up to this many times before returning an error to the client. Query rules can override this default value by specifying a custom retry count.

pgsql-server_encoding

The default encoding that ProxySQL assumes for the server.

Description: Sets the default server encoding. ProxySQL uses UTF8 by default.

pgsql-server_version

The PostgreSQL server version that ProxySQL will report to clients.

Description: This variable sets the version string that ProxySQL reports to clients during the handshake. It defaults to 16.1.

pgsql-sessions_sort

Enables sorting of PostgreSQL sessions for processing.

Description: When enabled, ProxySQL sorts active PostgreSQL sessions before processing them, which can optimize performance by improving CPU cache locality on systems with many concurrent connections. Sessions are sorted by their connection timeout status to prioritize sessions that are closer to their timeout limits. This does not affect routing behavior or query execution order.

pgsql-set_parser_algorithm

Dynamic integer enum, default 2, accepted values 1, 2, and 3. It selects the parser used for PostgreSQL SET statements and session-variable tracking. Other values are rejected. See Multiplexing.

pgsql-set_query_lock_on_hostgroup

Controls routing locks when a session variable is set.

Description: When enabled (1), setting a session variable will “lock” the session to the current hostgroup to ensure consistency for subsequent queries.

pgsql-shun_on_failures

The number of connection failures allowed before a backend server is shunned.

Description: If a backend server fails to respond to connection attempts this many times consecutively, it will be temporarily shunned (marked as OFFLINE) to prevent further traffic from being sent to it. During the shun period, new connections are automatically directed to other healthy backends in the same hostgroup. The server will be automatically returned to service after pgsql-shun_recovery_time_sec seconds.

pgsql-shun_recovery_time_sec

The duration in seconds a backend server remains shunned.

Description: The time in seconds that a backend server will remain in the shunned state before ProxySQL attempts to use it again. After this time elapses, the server is automatically returned to ONLINE status and new connections will be directed to it again. Existing connections to the server are allowed to complete naturally during the shun period.

pgsql-stats_time_backend_query

Dynamic Boolean, default false. Enables timing collection around PostgreSQL backend-query work. Invalid Boolean values are rejected; timing data is exposed through PostgreSQL statistics.

pgsql-stats_time_query_processor

Dynamic Boolean, default false. Enables timing collection around PostgreSQL query-processor work. Invalid Boolean values are rejected; timing data is exposed through PostgreSQL statistics.

pgsql-tcp_keepalive_time

Sets the TCP keepalive idle time for PostgreSQL client connections.

Description: Defines the time (in seconds) the connection must be idle before TCP starts sending keepalive probes.

pgsql-threshold_query_length

Dynamic integer in bytes, default 524288, accepted range 1024 to 1073741824. Queries above the threshold are handled using the large-query path to bound intermediate buffering. Out-of-range values are rejected.

pgsql-threshold_resultset_size

Threshold in bytes for PostgreSQL resultset buffering.

Description: Determines the maximum amount of data (in bytes) that ProxySQL will buffer for a single PostgreSQL resultset before it begins streaming results to the client.

pgsql-throttle_connections_per_sec_to_hostgroup

Limits the number of new backend connections per second per hostgroup.

Description: Controls the rate at which ProxySQL opens new connections to PostgreSQL backends in a specific hostgroup to prevent connection storms.

pgsql-throttle_max_bytes_per_second_to_client

Maximum network bandwidth per second for a client connection.

Description: Limits the outgoing traffic rate (bytes per second) from ProxySQL to each PostgreSQL client. A value of 0 disables throttling.

pgsql-throttle_ratio_server_to_client

Ratio for network bandwidth throttling between backend and client.

Description: Defines the bandwidth allocation ratio between backend connections and client connections when throttling is active.

pgsql-unshun_algorithm

Defines the algorithm used to decide when a shunned server should be moved back ONLINE.

Description: Determines the recovery logic for backend servers that were previously shunned due to errors.

pgsql-use_tcp_keepalive

Enables TCP keepalive for PostgreSQL client connections.

Description: Enables the SO_KEEPALIVE socket option for PostgreSQL frontend connections.

pgsql-verbose_query_error

Provides detailed PostgreSQL error messages to the client.

Description: When enabled, ProxySQL returns more descriptive error information to PostgreSQL clients when a query fails.

pgsql-wait_timeout

Timeout in milliseconds for idle client connections.

Description: The maximum time (in milliseconds) a PostgreSQL client connection can remain idle before ProxySQL closes it. This limit only applies to connections with no active transaction. Connections with idle transactions are controlled by pgsql-max_transaction_idle_time instead.

Additional released PostgreSQL variables

These protocol-specific variables are present in every audited release line beginning with Stable v3.0.10 (and also v3.1.10 and v4.0.10). They are dynamic unless stated otherwise. Run LOAD PGSQL VARIABLES TO RUNTIME after changing them and SAVE PGSQL VARIABLES TO DISK to persist them. Invalid values are rejected and leave the current runtime value unchanged unless an entry documents a different failure mode.

pgsql-auditlog_flush_size

Flushes PostgreSQL audit output at the configured buffered size; 0 disables size-triggered flushing. Values above 10485760 are accepted with a warning. See Audit Log.

pgsql-auditlog_flush_timeout

Flushes buffered PostgreSQL audit records after the interval; 0 disables timeout-triggered flushing. Values above 300000 are accepted with a warning. See Audit Log.

pgsql-eventslog_buffer_history_size

Sets the circular history buffer used by advanced PostgreSQL event logging. 0 disables it. See Query Logging.

pgsql-eventslog_table_memory_size

Limits rows retained in the in-memory PostgreSQL query-events table; 0 disables retention there. See PostgreSQL statistics.

pgsql-eventslog_buffer_max_query_length

Caps query text copied into a circular-buffer event. See Query Logging.

pgsql-eventslog_flush_size

Flushes PostgreSQL event output at the configured buffered size; 0 disables size-triggered flushing. Values above 10485760 are accepted with a warning. See Query Logging.

pgsql-eventslog_flush_timeout

Flushes buffered PostgreSQL events after the interval; 0 disables timeout-triggered flushing. Values above 300000 are accepted with a warning. See Query Logging.

pgsql-eventslog_rate_limit

Logs every event at 1; larger values sample approximately one event per configured number. See Query Logging.

pgsql-data_packets_history_size

Controls retained packet-history entries used for protocol diagnostics; 0 disables retention. Invalid values are rejected. This can consume memory and is intended for focused troubleshooting.

pgsql-firewall_whitelist_errormsg

Sets the client-facing error text when the PostgreSQL firewall whitelist blocks a query. See Firewall Whitelist.

pgsql-keep_multiplexing_variables

Lists session variables that do not by themselves disable connection multiplexing. Empty input is rejected. Incorrect entries can make backend session state unsafe to reuse; see Multiplexing.

pgsql-preserve_client_on_broken_backend_in_tx

Preserves the frontend PostgreSQL connection when a backend connection breaks during a transaction, allowing the client to receive the transaction error and decide whether to continue. When false, ProxySQL also closes the client connection. Invalid Boolean values are rejected.

pgsql-processlist_max_query_length

Caps the query text exposed in the PostgreSQL process list. Invalid values are rejected. See PostgreSQL process list.

pgsql-show_processlist_extended

Controls the extra detail returned for PostgreSQL process-list inspection. 0 is the compact form and higher values expose progressively extended session details. Other values are rejected.

pgsql-query_processor_first_comment_parsing

Selects first-comment parsing behavior used by the PostgreSQL query processor. Out-of-range values are rejected; see Query Annotations.

pgsql-query_processor_parser

Selects the parser used for PostgreSQL command classification and digest generation. Other values are rejected. Compare query-rule and digest behavior before broad rollout. See PostgreSQL query rules.

pgsql-query_digests_groups_grouping_limit

Limits digest grouping of repeated value groups; 0 disables this secondary grouping limit. Out-of-range values are rejected. See PostgreSQL statistics.

pgsql-query_rules_fast_routing_algorithm

Selects the lookup algorithm for pgsql_query_rules_fast_routing. Invalid values are rejected. See PostgreSQL tables.

pgsql-parse_failure_logs_digest

Enables digest logging for statements whose PostgreSQL parsing fails. Invalid Boolean values are rejected; the additional records are visible in PostgreSQL query-digest statistics.

pgsql-servers_stats

Enables collection of PostgreSQL backend server statistics. Invalid Boolean values are rejected. See PostgreSQL statistics.

pgsql-ssl_p2s_ca

Sets the default CA certificate file for backend TLS verification. Empty or (null) clears the setting; any other string is accepted at assignment, so missing, unreadable, or invalid files fail when a TLS backend connection is created. Configure a trusted CA to authenticate the backend certificate; clearing it removes that CA trust source. The ProxySQL process must be able to read the file. Per-server values override this default. See PostgreSQL TLS settings and SSL Support.

pgsql-ssl_p2s_capath

Sets the default directory of trusted CA certificates for backend TLS verification. Empty or (null) clears the setting. The directory and its certificate files must be readable by the ProxySQL process and prepared in the format expected by the TLS library. Invalid or unreadable paths fail at backend TLS connection time. Clearing the directory removes this trust source. Per-server values override this default. See PostgreSQL TLS settings and SSL Support.

pgsql-ssl_p2s_cert

Sets the default client certificate presented to TLS-enabled PostgreSQL backends. Empty or (null) clears it. The ProxySQL process must be able to read the certificate; an unreadable, invalid, or key-mismatched file causes backend TLS connection failure. Clearing it disables certificate presentation and therefore breaks backends that require client-certificate authentication. Per-server values override this default. See PostgreSQL TLS settings and SSL Support.

pgsql-ssl_p2s_key

Sets the private key paired with pgsql-ssl_p2s_cert. Empty or (null) clears it. The ProxySQL process must be able to read the key, but ownership and permissions should restrict it to the ProxySQL service account because disclosure permits client impersonation. Unreadable, invalid, or mismatched keys fail at backend TLS connection time; clearing the key breaks certificate authentication when a client certificate is configured. Per-server values override this default. See PostgreSQL TLS settings and SSL Support.

pgsql-ssl_p2s_cipher

Sets the default TLS cipher list for PostgreSQL backend connections. Empty or (null) restores the TLS library default. The value is accepted at assignment; an invalid cipher expression or no mutually supported cipher causes backend TLS connection failure. Per-server values override this default. See PostgreSQL TLS settings and SSL Support.

pgsql-ssl_p2s_crl

Sets the default CRL file used to reject revoked backend certificates. Empty or (null) clears it, disabling revocation checks supplied by this file. The ProxySQL process must be able to read the CRL; missing, unreadable, or invalid data fails at backend TLS connection time. Per-server values override this default. See PostgreSQL TLS settings and SSL Support.

pgsql-ssl_p2s_crlpath

Sets the default directory of CRLs used to reject revoked backend certificates. Empty or (null) clears it, disabling revocation checks supplied by that directory. The directory and CRL files must be readable by the ProxySQL process and prepared for the TLS library; path or CRL errors fail at backend TLS connection time. Per-server values override this default. See PostgreSQL TLS settings and SSL Support.

pgsql-stacksize

Sets the stack size for PostgreSQL worker threads. Out-of-range values are rejected. The value appears in all audited release tiers but changing it after workers exist does not resize their stacks.

pgsql-threads

Sets the PostgreSQL worker count. Attempts to change it after worker initialization are rejected. All audited release tiers expose the setting.

Tracked PostgreSQL defaults

The following dynamic variables set ProxySQL’s initial tracked state for new PostgreSQL sessions. They are present in every audited release tier beginning with v3.0.10. Valid assignments take effect after LOAD PGSQL VARIABLES TO RUNTIME; invalid values leave the current value unchanged. See PostgreSQL tables and multiplexing.

pgsql-default_client_encoding

String, default UTF8. Accepts PostgreSQL client encodings recognized by ProxySQL (the names alias is also tracked) and normalizes the value to uppercase; an unknown encoding is rejected.

pgsql-default_datestyle

String, default ISO, MDY. Accepts a complete PostgreSQL date output style (ISO, Postgres, SQL, or German) and date order (DMY, MDY, or YMD); incomplete or invalid combinations are rejected.

pgsql-default_intervalstyle

String, default postgres. Accepted values are postgres, sql_standard, postgres_verbose, and iso_8601 (case-insensitive and normalized to the listed spelling).

pgsql-default_standard_conforming_strings

Boolean, default on. Accepts 0, f, false, off, or no for off and 1, t, true, on, or yes for on (case-insensitive), normalized to off or on.

pgsql-default_timezone

String, default GMT. The released setter accepts any string without local validation; PostgreSQL reports an invalid time-zone value when it is applied. TIME ZONE is tracked as an alias of this canonical variable.

pgsql-default_allow_in_place_tablespaces

Boolean, default off. Accepts the Boolean spellings documented for pgsql-default_standard_conforming_strings and normalizes them to off or on.

pgsql-default_bytea_output

String, default hex. Accepted values are hex and escape (case-insensitive and normalized).

pgsql-default_client_min_messages

String, default notice. Accepted values are debug5, debug4, debug3, debug2, debug1, log, notice, warning, and error (case-insensitive and normalized).

pgsql-default_enable_bitmapscan

Boolean, default on. Accepts and normalizes the Boolean spellings documented for pgsql-default_standard_conforming_strings.

pgsql-default_enable_hashjoin

Boolean, default on. Accepts and normalizes the Boolean spellings documented for pgsql-default_standard_conforming_strings.

pgsql-default_enable_indexscan

Boolean, default on. Accepts and normalizes the Boolean spellings documented for pgsql-default_standard_conforming_strings.

pgsql-default_enable_nestloop

Boolean, default on. Accepts and normalizes the Boolean spellings documented for pgsql-default_standard_conforming_strings.

pgsql-default_enable_seqscan

Boolean, default on. Accepts and normalizes the Boolean spellings documented for pgsql-default_standard_conforming_strings.

pgsql-default_enable_sort

Boolean, default on. Accepts and normalizes the Boolean spellings documented for pgsql-default_standard_conforming_strings.

pgsql-default_escape_string_warning

Boolean, default on. Accepts and normalizes the Boolean spellings documented for pgsql-default_standard_conforming_strings.

pgsql-default_extra_float_digits

Floating-point number, default 1, accepted range -15 through 3 inclusive. Non-numeric and out-of-range values are rejected.

pgsql-default_maintenance_work_mem

Memory size, default 64MB, accepted range 1024 through 2147483647 kB inclusive. Positive integer or decimal values may use B, kB, MB, GB, or TB; no suffix means kB. Invalid units and out-of-range sizes are rejected.

pgsql-default_search_path

String, default "$user", public. Accepts comma-separated quoted or unquoted identifiers of at most 63 characters each and removes surrounding whitespace; malformed quoting, invalid identifiers, and overlength components are rejected.

pgsql-default_synchronous_commit

String, default on. Accepted values are local, remote_write, remote_apply, on, and off (case-insensitive and normalized).

Apply your changes: Remember to use the appropriate LOAD and SAVE commands to activate and persist your configuration. See the complete Admin Commands reference.