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 (commit 995fb742).
Default
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