Re: D in top results for checkpoint - Mailing list pgsql-admin

From Jeff Janes
Subject Re: D in top results for checkpoint
Date
Msg-id CAMkU=1y6czmz6cqZxRqUQS9cL3TcXCib8n6D-bmT_=pmB5BwWw@mail.gmail.com
Whole thread Raw
In response to D in top results for checkpoint  (Yambu <hyambu@gmail.com>)
List pgsql-admin
On Tue, Jul 6, 2021 at 8:12 AM Yambu <hyambu@gmail.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

pgsql-admin by date:

Previous
From: Jeff Janes
Date:
Subject: Re: WALWriteLock
Next
From: Vijaykumar Jain
Date:
Subject: Re: WALWriteLock