Hi,
We've started to observe instances of one of our databases stalling for a
few seconds.
We see a spike in wal write locks then nothing for a few seconds. After
which we have spike latency as processes waiting to get to the db can do
so.
There is nothing in the postgres logs that give us any c
On Mon, Jan 30, 2023 at 05:47:49PM +, Mok wrote:
> Hi,
>
> We've started to observe instances of one of our databases stalling for a
> few seconds.
>
> We see a spike in wal write locks then nothing for a few seconds. After
> which we have spike latency as processes waiting to get to the db c
On Mon, Jan 30, 2023 at 2:51 PM Justin Pryzby wrote:
> On Mon, Jan 30, 2023 at 05:47:49PM +, Mok wrote:
> > Hi,
> >
> > We've started to observe instances of one of our databases stalling for a
> > few seconds.
> >
> > We see a spike in wal write locks then nothing for a few seconds. After
>
Hi Burmokh,
Please take a look at this article copied below and ping me for further
guidance. Thanks!
How expensive SQLs can impact PostgreSQL Performance? -
https://minervadb.xyz/how-expensive-sqls-can-impact-postgresql-performance/
—
Best
Shiv
> On 30-Jan-2023, at 11:17 PM, Mok wrot
Hi,
Unfortunately there is no pg_stat_activity data available as we are unaware
of the issue until it has already happened.
The version we are on is 12.11.
I don't think it is due to locks as there are none in the logs. Vacuums are
logged also and none occur before or after this event. Checkpoin
On Mon, Jan 30, 2023 at 4:32 PM Mok wrote:
> Hi,
>
> Unfortunately there is no pg_stat_activity data available as we are
> unaware of the issue until it has already happened.
>
> The version we are on is 12.11.
>
> I don't think it is due to locks as there are none in the logs. Vacuums
> are logg
