Postgres FM cover image

auto_explain

Postgres FM

00:00

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

Transcript
Play full episode

The AI-powered Podcast Player

Save insights by tapping your headphones, chat with episodes, discover the best highlights - and more!
App store bannerPlay store banner
Get the app