Re: Performance issue: index not used on GROUP BY...

From: Victor Yegorov <vyegorov(at)gmail(dot)com>
To: gmb <gmbouwer(at)gmail(dot)com>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Performance issue: index not used on GROUP BY...
Date: 2014-08-28 08:57:09
Message-ID: CAGnEbogEvqqdwGA_jrrdt_8S3dMvvSNdT=sna8jC87nRmAW+cA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

2014-08-28 11:50 GMT+03:00 gmb <gmbouwer(at)gmail(dot)com>:

> It seems as if the planner is not using the PRIMARY KEY as index which was
> my assumption.
>

Can you send `EXPLAIN (analyze, buffers)` for your query instead?
It'll show exactly what's going on.

--
Victor Y. Yegorov

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message gmb 2014-08-28 09:08:59 Re: Performance issue: index not used on GROUP BY...
Previous Message gmb 2014-08-28 08:50:40 Performance issue: index not used on GROUP BY...