| From: | "ndaley (dot)" <ndaley(at)omniti(dot)com> |
|---|---|
| To: | Chloe Dives <Chloe(dot)Dives(at)cantabcapital(dot)com> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: Monitoring Parallel Queries |
| Date: | 2016-12-01 17:21:31 |
| Message-ID: | CAH8En5G3eCZm63O7S2mN9R-n-HFmnhosxq0yupE5ooQNmmJU1A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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: -
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(dot)Dives(at)cantabcapital(dot)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(at)omniti(dot)com
skype: ndaley.omniti
phone: 240-646-0770 ext 283
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrea spanu | 2016-12-05 11:19:54 | 'PG_PRINTF_ATTRIBUTE' is an unrecognized format function type |
| Previous Message | Chloe Dives | 2016-12-01 11:32:01 | Monitoring Parallel Queries |