Wiki / Configuration Parameters
track_activity_query_size
Specifies the amount of memory reserved to store the text of the currently executing command for each active session, for the pg_stat_activity.query field. If this value is specified without units, it is taken as bytes. The default value is 1024 bytes. This parameter can only be set at server start.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- boot val
- 1024
- category
- Statistics / Cumulative Query and Index Statistics
- context
- postmaster
- documented
- true
- enumvals
- Unknown
- extra desc
- Unknown
- lang
- en
- max val
- 1048576
- metadata version
- 18
- min val
- 100
- name
- track_activity_query_size
- short desc
- Sets the size reserved for pg_stat_activity.query, in bytes.
- source
- pg-settings-source-snapshot
- unit
- B
- vartype
- integer
Definition PG 18
Specifies the amount of memory reserved to store the text of the currently executing command for each active session, for the pg_stat_activity.query field. If this value is specified without units, it is taken as bytes. The default value is 1024 bytes. This parameter can only be set at server start.
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · wiki-repair-20261023:a1a299d1b8cef1febce5cdf82c28ed3fa641769d0f7fbc6d55132d0354445de0
Text language: en · wiki-repair-20261023:a1a299d1b8cef1febce5cdf82c28ed3fa641769d0f7fbc6d55132d0354445de0