Re: CPU time for pg_stat_statement - Mailing list pgsql-hackers

From Michail Nikolaev
Subject Re: CPU time for pg_stat_statement
Date
Msg-id CANtu0ojaBhJMxhcOinOcmwuDWUPVaMenZkcLkLVrDDffT2_MqA@mail.gmail.com
Whole thread Raw
In response to Re: CPU time for pg_stat_statement  (Michail Nikolaev <michail.nikolaev@gmail.com>)
List pgsql-hackers
Hello, Tom.

>> This is a pretty broad claim to make on the basis of one undocumented
>> test case on one unmentioned platform.

> I'll try to use pg_stat_kcache to check the difference between Wall
> and CPU for my case.

In my case I see pretty high correlation of pg_stat_kcache and
pg_stat_statement (clock_gettime vs getrusage).
Looks like CPU usage is hidden somewhere else (planning probably, not
measured on postgres 11, but I see really high
*clauselist_selectivity* in perf).

Thanks,
Michail.



pgsql-hackers by date:

Previous
From: "wangw.fnst@fujitsu.com"
Date:
Subject: RE: Perform streaming logical transactions by background workers and parallel apply
Next
From: "shiy.fnst@fujitsu.com"
Date:
Subject: Replica Identity check of partition table on subscriber