Re: D in top results for checkpoint

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Yambu <hyambu(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: D in top results for checkpoint
Date: 2021-07-07 20:12:41
Message-ID: CAMkU=1y6czmz6cqZxRqUQS9cL3TcXCib8n6D-bmT_=pmB5BwWw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Jul 6, 2021 at 8:12 AM Yambu <hyambu(at)gmail(dot)com> wrote:

> Hello
>
> May i know if its ok to see D under S column when i run top command for
> checkpoint process?
>
> this has been like this for 1.30hr
>

That means it is in an uninterruptible sleep, which generally means it is
waiting for the disk to do something. If it never leaves this state, it
might mean your disk storage is failing. If it rapidly cycles through
states, but spends most of its time in D, that might just mean your system
is spending a lot of time on disk access, which is not necessarily a
problem. But just looking at `top` will have a hard time distinguishing
these scenarios.

What do you see if you try to 'strace -ttt -T -p <pid>' the process?

Also, what version is this, and what is the OS flavor and version?

Cheers,

Jeff

>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Vijaykumar Jain 2021-07-07 20:14:05 Re: WALWriteLock
Previous Message Jeff Janes 2021-07-07 19:52:27 Re: WALWriteLock