Toggle navigation

track_activity_query_size

类型: integer
默认: 1024
最低限度: 100
最大: 102400
单元: B
上下文: postmaster
重新开始: true

为每个活动会话指定存储当前执行命令的文本所保留的内存量,它们被用于pg_stat_activity.query域。 如果指定值时没有单位,则以字节为单位。默认值是 1024字节。这个参数只能在服务器启动时被设置。

建议 [EN]

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.

条评论