| From: | Chris Mair <chris(at)1006(dot)org> |
|---|---|
| To: | Ravi Tammineni <rtammineni(at)partner(dot)aligntech(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Queries are taking way longer in 9.6 than 9.5 |
| Date: | 2017-01-17 20:38:59 |
| Message-ID: | a0680eb9d03df0f54690eb2a7351744e@smtp.hushmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support pgsql-admin pgsql-general |
Hi.
> explain analyze
>
> SELECT count(*)
>
> [...]
> QUERY PLAN
>
> -----------------------------------------------------------------------------------------------------------------------------------------------------
>
> Aggregate (cost=1177.25..1177.26 rows=1 width=0)
>
> [...]
I'm not seeing the "(actual ... )" part here.
THe plan you show is from an explain, not an explain analyze...
Can you provide the explain analyze output?
Bye,
Chris.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2017-01-17 20:47:48 | Re: Queries are taking way longer in 9.6 than 9.5 |
| Previous Message | Melvin Davidson | 2017-01-17 20:21:27 | Re: Queries are taking way longer in 9.6 than 9.5 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2017-01-17 20:47:48 | Re: Queries are taking way longer in 9.6 than 9.5 |
| Previous Message | Melvin Davidson | 2017-01-17 20:21:27 | Re: Queries are taking way longer in 9.6 than 9.5 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2017-01-17 20:47:48 | Re: Queries are taking way longer in 9.6 than 9.5 |
| Previous Message | Melvin Davidson | 2017-01-17 20:21:27 | Re: Queries are taking way longer in 9.6 than 9.5 |