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
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
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
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
>
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
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
