Statistics / Cumulative Query and Index Statistics
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 |