Postgres Pro
Downloads
Home   >   mailing lists

Re: Performance issue: index not used on GROUP BY... - Mailing list pgsql-performance

From Victor Yegorov
Subject Re: Performance issue: index not used on GROUP BY...
Date
Msg-id CAGnEbogEvqqdwGA_jrrdt_8S3dMvvSNdT=sna8jC87nRmAW+cA@mail.gmail.com
Whole thread Raw
In response to Performance issue: index not used on GROUP BY...  (gmb <gmbouwer@gmail.com>)
Responses Re: Performance issue: index not used on GROUP BY...
List pgsql-performance
Tree view
2014-08-28 11:50 GMT+03:00 gmb <gmbouwer@gmail.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

pgsql-performance by date:

Previous
From: gmb
Date:
Subject: Performance issue: index not used on GROUP BY...
Next
From: gmb
Date:
Subject: Re: Performance issue: index not used on GROUP BY...