JSON Schema Pgaudit

System-wide settings for the pgaudit extension.

Properties

Property	Type	Required	Description
`feature_enabled`	boolean	no	Enable pgaudit extension. When enabled, pgaudit extension will be automatically installed.Otherwise, extension will be uninstalled but auditing configurations will be preserved. Default: `false`.
`log`	array[string]	no	Specifies which classes of statements will be logged by session audit logging.
`log_catalog`	boolean	no	Specifies that session logging should be enabled in the case where all relations in a statement are in pg_catalog. Default: `true`.
`log_client`	boolean	no	Specifies whether log messages will be visible to a client process such as psql. Default: `false`.
`log_level`	string	no	Specifies the log level that will be used for log entries. Allowed values: `debug1`, `debug2`, `debug3`, `debug4`, `debug5`, `info`, `notice`, `warning`, `log`. Default: `log`.
`log_max_string_length`	integer	no	Crop parameters representation and whole statements if they exceed this threshold. A (default) value of -1 disable the truncation. Min: `-1`. Max: `102400`. Default: `-1`.
`log_nested_statements`	boolean	no	This GUC allows to turn off logging nested statements, that is, statements that are executed as part of another ExecutorRun. Default: `true`.
`log_parameter`	boolean	no	Specifies that audit logging should include the parameters that were passed with the statement. Default: `false`.
`log_parameter_max_size`	integer	no	Specifies that parameter values longer than this setting (in bytes) should not be logged, but replaced with . Default: `0`.
`log_relation`	boolean	no	Specifies whether session audit logging should create a separate log entry for each relation (TABLE, VIEW, etc.) referenced in a SELECT or DML statement. Default: `false`.
`log_rows`	boolean	no	Default: `false`.
`log_statement`	boolean	no	Specifies whether logging will include the statement text and parameters (if enabled). Default: `true`.
`log_statement_once`	boolean	no	Specifies whether logging will include the statement text and parameters with the first log entry for a statement/substatement combination or with every entry. Default: `false`.
`role`	string	no	Specifies the master role to use for object audit logging. Max length: `64`.

Last updated on June 3, 2026