Thread: Monitoring Parallel Queries

Monitoring Parallel Queries

From

Chloe Dives

Date:

01 December 2016, 14:32:16

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

From

"ndaley ."

Date:

01 December 2016, 20:22:19

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: -

https://www.postgresql.org/docs/9.6/static/when-can-parallel-query-be-used.html

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

email: ndaley@omniti.com

skype: ndaley.omniti

phone: 240-646-0770 ext 283