Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
stats_fetch_consistency
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Sets the consistency of accesses to statistics data. | 
| Data type | enumeration | 
| Default value | cache | 
| Allowed values | cache | 
| Parameter type | read-only | 
| Documentation | stats_fetch_consistency | 
track_activities
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Collects information about executing commands for each session. | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_activities | 
track_activity_query_size
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Sets the amount of memory reserved for pg_stat_activity.query, in bytes. | 
| Data type | integer | 
| Default value | 1024 | 
| Allowed values | 100-102400 | 
| Parameter type | static | 
| Documentation | track_activity_query_size | 
track_counts
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables collection of statistics on database activity | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_counts | 
track_functions
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables tracking of function call counts and time used. | 
| Data type | enumeration | 
| Default value | none | 
| Allowed values | none,pl,all | 
| Parameter type | dynamic | 
| Documentation | track_functions | 
track_io_timing
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables timing of database I/O calls. | 
| Data type | boolean | 
| Default value | off | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_io_timing | 
track_wal_io_timing
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Collects timing statistics for WAL I/O activity. | 
| Data type | boolean | 
| Default value | off | 
| Allowed values | off | 
| Parameter type | read-only | 
| Documentation | track_wal_io_timing | 
stats_fetch_consistency
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Sets the consistency of accesses to statistics data. | 
| Data type | enumeration | 
| Default value | cache | 
| Allowed values | cache | 
| Parameter type | read-only | 
| Documentation | stats_fetch_consistency | 
track_activities
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Collects information about executing commands for each session. | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_activities | 
track_activity_query_size
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Sets the amount of memory reserved for pg_stat_activity.query, in bytes. | 
| Data type | integer | 
| Default value | 1024 | 
| Allowed values | 100-102400 | 
| Parameter type | static | 
| Documentation | track_activity_query_size | 
track_counts
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables collection of statistics on database activity | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_counts | 
track_functions
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables tracking of function call counts and time used. | 
| Data type | enumeration | 
| Default value | none | 
| Allowed values | none,pl,all | 
| Parameter type | dynamic | 
| Documentation | track_functions | 
track_io_timing
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables timing of database I/O calls. | 
| Data type | boolean | 
| Default value | off | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_io_timing | 
track_wal_io_timing
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Collects timing statistics for WAL I/O activity. | 
| Data type | boolean | 
| Default value | off | 
| Allowed values | off | 
| Parameter type | read-only | 
| Documentation | track_wal_io_timing | 
stats_fetch_consistency
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Sets the consistency of accesses to statistics data. | 
| Data type | enumeration | 
| Default value | cache | 
| Allowed values | cache | 
| Parameter type | read-only | 
| Documentation | stats_fetch_consistency | 
track_activities
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Collects information about executing commands for each session. | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_activities | 
track_activity_query_size
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Sets the amount of memory reserved for pg_stat_activity.query, in bytes. | 
| Data type | integer | 
| Default value | 1024 | 
| Allowed values | 100-102400 | 
| Parameter type | static | 
| Documentation | track_activity_query_size | 
track_counts
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables collection of statistics on database activity | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_counts | 
track_functions
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables tracking of function call counts and time used. | 
| Data type | enumeration | 
| Default value | none | 
| Allowed values | none,pl,all | 
| Parameter type | dynamic | 
| Documentation | track_functions | 
track_io_timing
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables timing of database I/O calls. | 
| Data type | boolean | 
| Default value | off | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_io_timing | 
track_wal_io_timing
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Collects timing statistics for WAL I/O activity. | 
| Data type | boolean | 
| Default value | off | 
| Allowed values | off | 
| Parameter type | read-only | 
| Documentation | track_wal_io_timing | 
track_activities
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Collects information about executing commands for each session. | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_activities | 
track_activity_query_size
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Sets the amount of memory reserved for pg_stat_activity.query, in bytes. | 
| Data type | integer | 
| Default value | 1024 | 
| Allowed values | 100-102400 | 
| Parameter type | static | 
| Documentation | track_activity_query_size | 
track_counts
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables collection of statistics on database activity | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_counts | 
track_functions
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables tracking of function call counts and time used. | 
| Data type | enumeration | 
| Default value | none | 
| Allowed values | none,pl,all | 
| Parameter type | dynamic | 
| Documentation | track_functions | 
track_io_timing
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables timing of database I/O calls. | 
| Data type | boolean | 
| Default value | off | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_io_timing | 
track_wal_io_timing
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Collects timing statistics for WAL I/O activity. | 
| Data type | boolean | 
| Default value | off | 
| Allowed values | off | 
| Parameter type | read-only | 
| Documentation | track_wal_io_timing | 
track_activities
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Collects information about executing commands for each session. | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_activities | 
track_activity_query_size
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Sets the amount of memory reserved for pg_stat_activity.query, in bytes. | 
| Data type | integer | 
| Default value | 1024 | 
| Allowed values | 100-102400 | 
| Parameter type | static | 
| Documentation | track_activity_query_size | 
track_counts
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables collection of statistics on database activity | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_counts | 
track_functions
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables tracking of function call counts and time used. | 
| Data type | enumeration | 
| Default value | none | 
| Allowed values | none,pl,all | 
| Parameter type | dynamic | 
| Documentation | track_functions | 
track_io_timing
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables timing of database I/O calls. | 
| Data type | boolean | 
| Default value | off | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_io_timing | 
track_activities
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Collects information about executing commands for each session. | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_activities | 
track_activity_query_size
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Sets the amount of memory reserved for pg_stat_activity.query, in bytes. | 
| Data type | integer | 
| Default value | 1024 | 
| Allowed values | 100-102400 | 
| Parameter type | static | 
| Documentation | track_activity_query_size | 
track_counts
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables collection of statistics on database activity | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_counts | 
track_functions
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables tracking of function call counts and time used. | 
| Data type | enumeration | 
| Default value | none | 
| Allowed values | none,pl,all | 
| Parameter type | dynamic | 
| Documentation | track_functions | 
track_io_timing
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables timing of database I/O calls. | 
| Data type | boolean | 
| Default value | off | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_io_timing | 
track_activities
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Collects information about executing commands for each session. | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_activities | 
track_activity_query_size
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Sets the amount of memory reserved for pg_stat_activity.query, in bytes. | 
| Data type | integer | 
| Default value | 1024 | 
| Allowed values | 100-102400 | 
| Parameter type | static | 
| Documentation | track_activity_query_size | 
track_counts
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables collection of statistics on database activity | 
| Data type | boolean | 
| Default value | on | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_counts | 
track_functions
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables tracking of function call counts and time used. | 
| Data type | enumeration | 
| Default value | none | 
| Allowed values | none,pl,all | 
| Parameter type | dynamic | 
| Documentation | track_functions | 
track_io_timing
| Attribute | Value | 
|---|---|
| Category | Statistics / Cumulative Query and Index Statistics | 
| Description | Enables timing of database I/O calls. | 
| Data type | boolean | 
| Default value | off | 
| Allowed values | on,off | 
| Parameter type | dynamic | 
| Documentation | track_io_timing |