| From: | Tatsuo Ishii <ishii(at)postgresql(dot)org> |
|---|---|
| To: | laurenz(dot)albe(at)cybertec(dot)at |
| Cc: | jamespang886(at)gmail(dot)com, frits(dot)hoogland(at)gmail(dot)com, pgsql-performance(at)lists(dot)postgresql(dot)org |
| Subject: | Re: many sessions waiting DataFileRead and extend |
| Date: | 2025-06-26 03:25:45 |
| Message-ID: | 20250626.122545.1937425176692913230.ishii@postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> On Thu, 2025-06-26 at 10:32 +0800, James Pang wrote:
>> thans for you suggestions, we have iowait from sar command too, copy here, checking with infra team not found abnormal IO activities either.
>> 02:00:01 PM CPU %usr %nice %sys %iowait %irq %soft %steal %guest %gnice %idle
>> 02:00:03 PM all 15.92 0.00 43.02 0.65 0.76 2.56 0.00 0.00 0.00 37.09
>
> Crazy high system time.
>
> If it is not transparent hugepages, the other suspect is fork().
Can we use starce -S to collect system call statistics to find out
which system call is taking time?
Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Pang | 2025-06-26 03:48:45 | Re: many sessions waiting DataFileRead and extend |
| Previous Message | Laurenz Albe | 2025-06-26 03:03:28 | Re: many sessions waiting DataFileRead and extend |