Re: CPU time for pg_stat_statement

Поиск
Список
Период
Сортировка
От Michail Nikolaev
Тема Re: CPU time for pg_stat_statement
Дата
Msg-id CANtu0ojaBhJMxhcOinOcmwuDWUPVaMenZkcLkLVrDDffT2_MqA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: CPU time for pg_stat_statement  (Michail Nikolaev <michail.nikolaev@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: "wangw.fnst@fujitsu.com"
Дата:
Сообщение: RE: Perform streaming logical transactions by background workers and parallel apply
Следующее
От: "shiy.fnst@fujitsu.com"
Дата:
Сообщение: Replica Identity check of partition table on subscriber