Re: index problems (again)

From: Victor Yegorov <vyegorov(at)gmail(dot)com>
To: Geoff Winkless <pgsqladmin(at)geoff(dot)dj>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: index problems (again)
Date: 2016-03-07 11:48:43
Message-ID: CAGnEbohEG36EHeaWFG6Pz4ZqmhBUxYnApULiBspy8s8Jxx4Bvw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2016-03-07 13:38 GMT+02:00 Geoff Winkless <pgsqladmin(at)geoff(dot)dj>:

> # EXPLAIN (ANALYZE,BUFFERS) SELECT MIN(sc_id) FROM legs WHERE scdate
> BETWEEN 20160219 AND 20160221;
>

Will it help if you'll add `count(*)` to your query like this:

SELECT min(sc_id), count(*) FROM legs WHERE scdate BETWEEN 20160219 AND
20160221;

?

--
Victor Y. Yegorov

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoff Winkless 2016-03-07 13:01:17 Re: index problems (again)
Previous Message Geoff Winkless 2016-03-07 11:38:34 index problems (again)