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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: Performance issue: index not used on GROUP BY...
From: Victor Yegorov <vyegorov@xxxxxxxxx>
Date: Thu, 28 Aug 2014 11:57:09 +0300
Cc: "pgsql-performance@xxxxxxxxxxxxxx" <pgsql-performance@xxxxxxxxxxxxxx>
In-reply-to: <1409215840535-5816702.post@n5.nabble.com>

2014-08-28 11:50 GMT+03:00 gmb <gmbouwer@xxxxxxxxx>:

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

Follow-Ups:
- Re: Performance issue: index not used on GROUP BY...
  - From: gmb

References:
- Performance issue: index not used on GROUP BY...
  - From: gmb

Prev by Date: Performance issue: index not used on GROUP BY...
Next by Date: Re: Performance issue: index not used on GROUP BY...
Previous by thread: Performance issue: index not used on GROUP BY...
Next by thread: Re: Performance issue: index not used on GROUP BY...
Index(es):
- Date
- Thread

[Postgresql General] [Postgresql PHP] [PHP Users] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Yosemite]

Powered by Linux