pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Can we extract CPU usage by table/query level 2+ messages / 2 participants [nested] [flat]
* Can we extract CPU usage by table/query level @ 2020-04-03 06:19 Ishan joshi <ishanjoshi@live.com> 0 siblings, 1 reply; 2+ messages in thread From: Ishan joshi @ 2020-04-03 06:19 UTC (permalink / raw) To: pgsql-admin 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Can we extract CPU usage by table/query level @ 2020-04-03 07:03 Julien Rouhaud <rjuju123@gmail.com> parent: Ishan joshi <ishanjoshi@live.com> 0 siblings, 0 replies; 2+ messages in thread From: Julien Rouhaud @ 2020-04-03 07:03 UTC (permalink / raw) To: Ishan joshi <ishanjoshi@live.com>; +Cc: pgsql-admin 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? ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2020-04-03 07:03 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2020-04-03 06:19 Can we extract CPU usage by table/query level Ishan joshi <ishanjoshi@live.com> 2020-04-03 07:03 ` Julien Rouhaud <rjuju123@gmail.com>
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