From: Justin Pryzby <pryzby@telsasoft.com>
To: 徐志宇徐 <xuzhiyuster@gmail.com>
Cc: pgsql-performance@lists.postgresql.org
Subject: Re: How to monitor Postgres real memory usage
Date: Tue, 24 May 2022 12:40:50 -0500
Message-ID: <20220524174050.GI19626@telsasoft.com> (raw)
In-Reply-To: <CAOCebi+i=HPofBSdvs1RftcZpAHg81R9jqmr5xTJm0dGSDUMNQ@mail.gmail.com>
References: <CAOCebi+i=HPofBSdvs1RftcZpAHg81R9jqmr5xTJm0dGSDUMNQ@mail.gmail.com>
On Wed, May 25, 2022 at 12:25:28AM +0800, 徐志宇徐 wrote:
> Hi All
>
> I am a Database DBA. I focus on PostgreSQL and DB2.
> Recently. I experience some memory issue. The postgres unable allocate
> memory. I don't know how to monitor Postgres memory usage.
Postgres is just an OS Process, so should be monitored like any other.
What OS are you using ?
Know that the OS may attribute "shared buffers" to different processes, or
multiple processes.
> This server have 16G memory. On that time. The free command display only 3
> G memory used. The share_buffers almost 6G.
>
> On that time. The server have 100 active applications.
> New connection failed. I have to kill some application by os command "kill -9"
It's almost always a bad idea to kill postgres with kill -9.
> The checkpoint command execute very slow. almost need 5-10 seconds.
Do you mean an interactive checkpoint command ?
Or logs from log_checkpoint ?
> Is there any useful command to summary PostgreSQL memory usage ?
You can check memory use of an individual query with "explain (analyze,buffers) .."
https://wiki.postgresql.org/wiki/Slow_Query_Questions
What settings have you used in postgres ?
https://wiki.postgresql.org/wiki/Server_Configuration
What postgres version ?
How was it installed ? From souce? From a package ?
--
Justin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: pryzby@telsasoft.com, xuzhiyuster@gmail.com, pgsql-performance@lists.postgresql.org
Subject: Re: How to monitor Postgres real memory usage
In-Reply-To: <20220524174050.GI19626@telsasoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox