Postgres Pro
Downloads
Home   >   mailing lists

Re: Monitoring Parallel Queries - Mailing list pgsql-novice

From ndaley .
Subject Re: Monitoring Parallel Queries
Date
Msg-id CAH8En5G3eCZm63O7S2mN9R-n-HFmnhosxq0yupE5ooQNmmJU1A@mail.gmail.com
Whole thread Raw
In response to Monitoring Parallel Queries  (Chloe Dives <Chloe.Dives@cantabcapital.com>)
List pgsql-novice
Tree view
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 by date:

Previous
From: Chloe Dives
Date:
Subject: Monitoring Parallel Queries
Next
From: Andrea spanu
Date:
Subject: 'PG_PRINTF_ATTRIBUTE' is an unrecognized format function type