Re: Looking for db statistics report

From: Aislan Luiz Wendling <aislanluiz(at)hotmail(dot)com>
To: dbatoCloud Solution <dbatocloud17(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Looking for db statistics report
Date: 2021-02-11 14:03:33
Message-ID: DM6PR06MB4937D40536D323DCB88B182EDD8C9@DM6PR06MB4937.namprd06.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Use SAR
________________________________
From: dbatoCloud Solution <dbatocloud17(at)gmail(dot)com>
Sent: Thursday, February 11, 2021 6:13 AM
To: pgsql-admin(at)postgresql(dot)org <pgsql-admin(at)postgresql(dot)org>
Subject: Looking for db statistics report

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

Thanks & Best Wishes,

Ashok

---------------------------------------------------------------------------------------------------------------------

Ashokkumar Mani (OCP12c/11g/10g/9i, AWS SAA, M103)

Dubai , UAE | BLR , INDIA

M: +971 54 723 0075 | +91 90086 70302 | WApp : +91 81975 99922

W: https://dbatocloudsolution.blogspot.in/<http://dbatocloudsolution.blogspot.in/> | E: dbatocloud17(at)gmail(dot)com<mailto:dbatocloud17(at)gmail(dot)com>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message srinivas oguri 2021-02-11 16:01:15 XX000: invalid BTree prefetch end_key
Previous Message Julien Rouhaud 2021-02-11 12:05:54 Re: Looking for db statistics report