Re: How to know how much CPU, RAM is used by existing 1 database

2022-10-26 Thread Laurenz Albe
On Wed, 2022-10-26 at 13:37 +0800, Yi Sun wrote: > Who can help me with this please? I researched but still no result yet, thank > you > > On Tue, 25 Oct 2022 at 16:30, Yi Sun wrote: > > Hi, > > > > There are many databases in our production patroni cluster and it seems it > > is overloaded, >

Re: How to know how much CPU, RAM is used by existing 1 database

2022-10-26 Thread Atul Kumar
I hope the below link helps... https://www.enterprisedb.com/blog/monitor-cpu-and-memory-percentage-used-each-process-postgresqlppas-91 On 10/26/22, Rob Sargent wrote: > On 10/26/22 08:26, Yi Sun wrote: >> >> >> On Wed, 26 Oct 2022 at 18:10, jian he >> wrote: >> >> >> >> On Wed, Oct 26, 2022

Re: How to know how much CPU, RAM is used by existing 1 database

2022-10-26 Thread Rob Sargent
On 10/26/22 08:26, Yi Sun wrote: On Wed, 26 Oct 2022 at 18:10, jian he wrote: On Wed, Oct 26, 2022 at 11:07 AM Yi Sun wrote: Hi Guys, Who can help me with this please? I researched but still no result yet, thank you On Tue, 25 Oct 2022 at 16:30, Yi Su

Re: How to know how much CPU, RAM is used by existing 1 database

2022-10-26 Thread Yi Sun
On Wed, 26 Oct 2022 at 18:10, jian he wrote: > > > On Wed, Oct 26, 2022 at 11:07 AM Yi Sun wrote: > >> Hi Guys, >> >> Who can help me with this please? I researched but still no result yet, >> thank you >> >> On Tue, 25 Oct 2022 at 16:30, Yi Sun wrote: >> >>> Hi, >>> >>> There are many database

Re: How to know how much CPU, RAM is used by existing 1 database

2022-10-26 Thread jian he
On Wed, Oct 26, 2022 at 11:07 AM Yi Sun wrote: > Hi Guys, > > Who can help me with this please? I researched but still no result yet, > thank you > > On Tue, 25 Oct 2022 at 16:30, Yi Sun wrote: > >> Hi, >> >> There are many databases in our production patroni cluster and it seems >> it is overlo

Re: How to know how much CPU, RAM is used by existing 1 database

2022-10-25 Thread Yi Sun
Hi Guys, Who can help me with this please? I researched but still no result yet, thank you On Tue, 25 Oct 2022 at 16:30, Yi Sun wrote: > Hi, > > There are many databases in our production patroni cluster and it seems it > is overloaded, so we decide to migrate the busiest database to a new > pa

How to know how much CPU, RAM is used by existing 1 database

2022-10-25 Thread Yi Sun
Hi, There are many databases in our production patroni cluster and it seems it is overloaded, so we decide to migrate the busiest database to a new patroni cluster. pgwatch2 is implemented, how to know how much CPU, RAM is used by the database please? Then we can use it to prepare the new patroni