1. Home
  2. Documentation
  3. postgresql.conf
  4. Resource Usage
  5. Memory

PostgreSQL version:

track_activity_query_size

Sets the size reserved for pg_stat_activity.query, in bytes

Specifies the number of bytes reserved to track the currently executing command for each active session, for the pg_stat_activity.query field. The default value is 1024. This parameter can only be set at server start.

Official doc

Recommendations

Sets the truncation threshold of queries in pg_stat_activity (and pg_stat_statements). Increase it if you have really long queries which are being cut off, but there is significant extra memory usage for keeping longer queries.
By annotated.conf

Comments

Type: integer
Default: 1024
Min: 100
Max: 102400
Context: postmaster
Restart: true

On StackOverflow

On pgsql-hackers

At postgresqlCO.NF (OnGres) we value your privacy and treat all data very seriously. We're fully GDPR compliant, and we continuously monitor and improve our data storage, retention and compliance mechanisms.

This web page does not, however, store any PII (Personally Identifiable Information). The only service that stores any data is Google Analytics, and we use it to gather analytics of the web page.

This website contains some data from the official documentation of the PostgreSQL.org project, and from Annotated.Conf, used with permission.

If you have any question or concern about our terms of service or privacy policy, please contact us at dataprotection _at_ ongres _dot_ com.

OK