Postgres FM cover image

auto_explain

Postgres FM

CHAPTER

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.
App store bannerPlay store banner