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 |
Σχόλια
https://aka.ms/ContentUserFeedback.
Σύντομα διαθέσιμα: Καθ' όλη τη διάρκεια του 2024 θα καταργήσουμε σταδιακά τα ζητήματα GitHub ως μηχανισμό ανάδρασης για το περιεχόμενο και θα το αντικαταστήσουμε με ένα νέο σύστημα ανάδρασης. Για περισσότερες πληροφορίες, ανατρέξτε στο θέμα:Υποβολή και προβολή σχολίων για