Request a Demo
Home   >   mailing lists

Re: Troubleshooting a brief spike in active sessions - Mailing list pgsql-performance

From Nikolay Samokhvalov
Subject Re: Troubleshooting a brief spike in active sessions
Date
Msg-id CAM527d-y5aQ2Qu0Dp8Ns8pK6Zpm0HdCk5NKn2M+JtFwqo_L4ow@mail.gmail.com
Whole thread Raw
In response to Re: Troubleshooting a brief spike in active sessions  (Nikolay Samokhvalov <nik@postgres.ai>)
List pgsql-performance
Tree view
BTW, what are you logging settings for slow queries?
(log_min_duration_statement, auto_explain.log_min_duration)

On Fri, Jan 9, 2026 at 2:27 PM Nikolay Samokhvalov <nik@postgres.ai> wrote:
On Fri, Jan 9, 2026 at 1:41 PM Dirschel, Steve-CW <Steve.Dirschel@bestbuy.com> wrote:
>
> Aurora Postgres version 17.4
>
> ...
>
> The app sessions will show as wait_event_type and wait_event as null which I understand means they are on CPU
>
> ...


Not necessarily. It also might be an uninstrumented wait event.

Do the spikes of "CPU" AAS (I prefer to call them "CPU*") correspond well to the spikes of high usage?

If you have N active sessions marked as CPU in ASH, does it match to the CPU load of similar scale?

If the VM has much less than 400 vCPUs and you see overall CPU load far from 100%, then we should suspect some missing wait event.

Nik

pgsql-performance by date:

Previous
From: Nikolay Samokhvalov
Date:
Subject: Re: Troubleshooting a brief spike in active sessions