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 <gurm...@gmail.com> 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 can do so. > > There is nothing in the postgres logs that give us any clues to what could be > happening, no locks, unusually high/long running transactions, just a pause > and resume. > > Could anyone give me any advice as to what to look for when it comes to > checking the underlying disk that the db is on? > > Thanks, > > Gurmokh > >
