On Fri, Aug 22, 2025 at 05:07:09PM +0200, Pavel Stehule wrote:
> > Any idea on what could it be?
> Few years ago I had a similar experience - some sec mystic lags - the
> problem was in virtualization.
While I can't discount this idea, after all it is aws ec2, so virtual
boxes, what makes me wonder is:
in case of this slow situation there is futex call, which takes
a second. But there are no futex calls in any other query processing
logs.
So, while it is obvious that futex "wasted" this time, the question is:
why would pg run futex() for this one query at all?
Best regards,
depesz