
auto_explain
Postgres FM
How to Set a Log Mean Duration for AutoXplain
The logging overhead is severe, not just in terms of performance, but also in terms of size, sheer volume of logs. I think there are some different like subtle differences that might make it worthwhile, but you are duplicating effort for sure. One example is another bonus parameter we get with AutoXplain, which is the sample rate. Which is not bonus anymore, because a log mean duration statement also has this capability since Postgres 14,. If I'm not mistaken, we can also sample. So what I meant was that if we're sampling, we might want to sample one, but not the other, for example. But unfortunately, in some systems, it's quite low value and
00:00
Transcript
Play full episode
Remember Everything You Learn from Podcasts
Save insights instantly, chat with episodes, and build lasting knowledge - all powered by AI.