Re: Monitoring Parallel Queries

Поиск
Список
Период
Сортировка
От ndaley .
Тема Re: Monitoring Parallel Queries
Дата
Msg-id CAH8En5G3eCZm63O7S2mN9R-n-HFmnhosxq0yupE5ooQNmmJU1A@mail.gmail.com
обсуждение исходный текст
Ответ на Monitoring Parallel Queries  (Chloe Dives <Chloe.Dives@cantabcapital.com>)
Список pgsql-novice
I have not used 9.6 yet. But explain plans would be able to reflect the number of workers used...but that would have to be done per query.
Maybe this will be helpful: - 



On Thu, Dec 1, 2016 at 6:32 AM, Chloe Dives <Chloe.Dives@cantabcapital.com> wrote:

We have a Postgres 9.6 database and have enabled parallel queries. I would like to look at stats on how often the optimiser is using parallel query and for which tables, but I’ve not been able to find any monitoring views that provide insight into the use of parallel queries. Could anyone point me in the right direction please?

 

Thanks,
Chloe




--
Thanks,
Nicole Daley
DBA at OmniTi
skype: ndaley.omniti
phone: 240-646-0770 ext 283

В списке pgsql-novice по дате отправления:

Предыдущее
От: Chloe Dives
Дата:
Сообщение: Monitoring Parallel Queries
Следующее
От: Andrea spanu
Дата:
Сообщение: 'PG_PRINTF_ATTRIBUTE' is an unrecognized format function type