From: Julien Rouhaud <rjuju123@gmail.com>
To: Ishan joshi <ishanjoshi@live.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Can we extract CPU usage by table/query level
Date: Fri, 3 Apr 2020 09:03:16 +0200
Message-ID: <20200403070316.GA95652@nol> (raw)
In-Reply-To: <BN6PR10MB20190DAD9AE28C1ABA055D6CA9C70@BN6PR10MB2019.namprd10.prod.outlook.com>
References: <BN6PR10MB20190DAD9AE28C1ABA055D6CA9C70@BN6PR10MB2019.namprd10.prod.outlook.com>
On Fri, Apr 03, 2020 at 06:19:56AM +0000, Ishan joshi wrote:
> 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?
This isn't possible with core postgres, but pg_stat_kcache extension
(https://github.com/powa-team/pg_stat_kcache) brings this feature (per-query).
> Question 2 : Can we extract transaction details of last 24 hrs on PG server.
What level of details do you exactly need?
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-admin@postgresql.org
Cc: rjuju123@gmail.com, ishanjoshi@live.com
Subject: Re: Can we extract CPU usage by table/query level
In-Reply-To: <20200403070316.GA95652@nol>
* 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