Postgres Pro
Downloads
Home   >   mailing lists

Re: Looking for db statistics report - Mailing list pgsql-admin

From Aislan Luiz Wendling
Subject Re: Looking for db statistics report
Date
Msg-id DM6PR06MB4937D40536D323DCB88B182EDD8C9@DM6PR06MB4937.namprd06.prod.outlook.com
Whole thread Raw
In response to Looking for db statistics report  (dbatoCloud Solution <dbatocloud17@gmail.com>)
List pgsql-admin
Tree view
Use SAR
From: dbatoCloud Solution <dbatocloud17@gmail.com>
Sent: Thursday, February 11, 2021 6:13 AM
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.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/ | E: dbatocloud17@gmail.com

pgsql-admin by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Looking for db statistics report
Next
From: srinivas oguri
Date:
Subject: XX000: invalid BTree prefetch end_key