Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] core system is getting unresponsive because over 300cpu load - Mailing list pgsql-general

From Victor Yegorov
Subject Re: [GENERAL] core system is getting unresponsive because over 300cpu load
Date
Msg-id CAGnEboi02r5_Qez4n20WxKqRZq-y1gGrpRUQJ=wz6vZrgP1RQw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] core system is getting unresponsive because over 300 cpu load  (pinker <pinker@onet.eu>)
Responses Re: [GENERAL] core system is getting unresponsive because over 300 cpu load  (pinker <pinker@onet.eu>)
List pgsql-general
Tree view
2017-10-11 0:53 GMT+03:00 pinker <pinker@onet.eu>:
> Can you provide output of `iostat -myx 10` at the “peak” moments, please?

sure, please find it here:
https://pastebin.com/f2Pv6hDL

Looks like `sdg` and `sdm` are the ones used most.
Can you describe what's on those devices? Do you have WAL and DB sitting together?
Where DB log files are stored?


Here you'll find the
full bgwriter stats: https://pastebin.com/VA8pyfXj

Can you, please, provide the output of this query (linked from the article mentioned): https://gist.github.com/lesovsky/4587d70f169739c01d4525027c087d14

And also this query:
SELECT name,version,source FROM pg_settings WHERE source NOT IN ('default','override'); 


--
Victor Yegorov

pgsql-general by date:

Previous
From: pinker
Date:
Subject: Re: [GENERAL] core system is getting unresponsive because over 300 cpu load
Next
From: pinker
Date:
Subject: Re: [GENERAL] core system is getting unresponsive because over 300 cpu load