We have some pretty large queries in our production postgresql (13.8) database that exceed the default 1024 for
track_activity_query_size (some queries are over 100k). I've bumped this value up to 8192, but it still does not capture quite a few of our queries.
- How high can I reasonably set this (I've read 1MB is the max) without incurring performance issues?
- What metrics can I monitor to track if I've set it too high?
I'd like to set it to 256k, or possibly higher, but that seems like it could be excessive.