Re: Looking for db statistics report

From: Julien Rouhaud <rjuju123(at)gmail(dot)com>
To: dbatoCloud Solution <dbatocloud17(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Looking for db statistics report
Date: 2021-02-11 12:05:54
Message-ID: CAOBaU_Zm_nHDRrgTu-8oX0fQkrROyzkHNVDskh84PfEDsTLMJA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Feb 11, 2021 at 7:13 PM dbatoCloud Solution
<dbatocloud17(at)gmail(dot)com> wrote:
>
> Dear All,
> Recently I changed memory parameters in PostgreSQL. I want to take the history report and current report to see the load/CPU/memory/ and other statistical reports.
>
> Please let me know how someone do we have any system view is there to check the load of the DB to compare with historyical data

There's no such view available in vanilla postgres. There are however
many tools available to provide this kind of information, whether at
the operating system level or postgres level. You can find a list of
tools in the wiki: https://wiki.postgresql.org/wiki/Monitoring

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Aislan Luiz Wendling 2021-02-11 14:03:33 Re: Looking for db statistics report
Previous Message dbatoCloud Solution 2021-02-11 11:13:20 Looking for db statistics report