Обсуждение: Monitoring Parallel Queries

Поиск
Список
Период
Сортировка

Monitoring Parallel Queries

От
Chloe Dives
Дата:

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

Re: Monitoring Parallel Queries

От
"ndaley ."
Дата:
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