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

From: Yi Sun <yinan81(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to know how much CPU, RAM is used by existing 1 database
Date: 2022-10-25 08:30:02
Message-ID: CABWY_HAKzE8B8n-oOukkYE4LgHFX1U0j7cN4XXudf-HbZTnBRA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rakesh Nashine 2022-10-25 10:47:16 How to remove the partition from table .
Previous Message Julien Rouhaud 2022-10-25 05:58:52 Re: How to get the selectStatement parse tree info?