Postgres Pro
Downloads
Home   >   mailing lists

Can we extract CPU usage by table/query level - Mailing list pgsql-admin

From Ishan joshi
Subject Can we extract CPU usage by table/query level
Date
Msg-id BN6PR10MB20190DAD9AE28C1ABA055D6CA9C70@BN6PR10MB2019.namprd10.prod.outlook.com
Whole thread Raw
Responses Re: Can we extract CPU usage by table/query level  (Julien Rouhaud <rjuju123@gmail.com>)
List pgsql-admin
Tree view
Hi Team,

I have 2 question regarding the CPU usage and transaction details.

I have PG11.5 server with pg_stat_statements extension. I check all pg_stat tables but I am not able to extract details  of CPU usage and transaction histroy along with its transaction time.

Question 1 : Can we extract details of CPU utilization  by query or table in last 24 hrs?
Question 2 : Can  we extract transaction details of last 24 hrs on PG server.

Please help as We are looking to improve our product on Postgres server

Thanks & Regards,
ISHAN JOSHI
8390118502
9979097477

pgsql-admin by date:

Previous
From: postgann2020 s
Date:
Subject: Re: Help to find-the-maximum-length-of-field-in-a-particular-column-in-allthe tables
Next
From: Julien Rouhaud
Date:
Subject: Re: Can we extract CPU usage by table/query level