track_activity_query_size
A configuration parameter determining the maximum query length to display in pg_stat_activity's query column
track_activity_query_size
is a configuration parameter determining the maximum query length to display in pg_stat_activity
's query
column.
track_activity_query_size
was added in PostgreSQL 8.4.
Default value
The default value for track_activity_query_size
is: 1024 bytes
.
Change history
- PostgreSQL 13
- maximum value raised to 1MB (commit 81472785)
- PostgreSQL 8.2
- added (commit 995fb742)
References
- PostgreSQL documentation: track_activity_query_size
Useful links
- Fixing track_activity_query_size in postgresql.conf - October 2019 blog article by CyberTec