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 |
Feedback
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați: https://aka.ms/ContentUserFeedback.
Trimiteți și vizualizați feedback pentru