Postgres Pro
Downloads
Home   >   mailing lists

Re: How to know how much CPU, RAM is used by existing 1 database - Mailing list pgsql-general

From jian he
Subject Re: How to know how much CPU, RAM is used by existing 1 database
Date
Msg-id CACJufxHSs4Bd9Bksz-Odhoep9NPk-x_mqbSx=VeNt_bYWW=DRA@mail.gmail.com
Whole thread Raw
In response to Re: How to know how much CPU, RAM is used by existing 1 database  (Yi Sun <yinan81@gmail.com>)
Responses Re: How to know how much CPU, RAM is used by existing 1 database
List pgsql-general
Tree view


On Wed, Oct 26, 2022 at 11:07 AM Yi Sun <yinan81@gmail.com> 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 <yinan81@gmail.com> 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 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 cluster hardware. Thank you

Best regards
Dennis

manual: https://www.postgresql.org/docs/current/runtime-config-resource.html
except min_dynamic_shared_memory (integer)
all other parameters are used to cap the memory. almost all parameters mentioned "database server" which means it's on cluster level.


--
 I recommend David Deutsch's <<The Beginning of Infinity>>

  Jian


pgsql-general by date:

Previous
From: Yi Sun
Date:
Subject: Re: How to know how much CPU, RAM is used by existing 1 database
Next
From: Yi Sun
Date:
Subject: Re: How to know how much CPU, RAM is used by existing 1 database