Events
Jun 10, 11 PM - Jun 12, 11 PM
The Call-for-Proposals is open until February 9 for this free and virtual developer event.
Get startedThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
Events
Jun 10, 11 PM - Jun 12, 11 PM
The Call-for-Proposals is open until February 9 for this free and virtual developer event.
Get startedTraining
Module
Tune queries in Azure Database for PostgreSQL - Training
Relational databases store many different types of data for many different types of applications. Some databases have thousands of users and some have just one user. Some tables have tens of rows while others have millions of rows. Some data is unique while other data is duplicated. All of these variables mean that database management systems (DBMSs) need systems to understand the data and the queries that are running against this data to ensure optimum performance. When you perform tune a database, it's im