Postgres Pro
Downloads
Home   >   mailing lists

Re: index problems (again) - Mailing list pgsql-general

From Victor Yegorov
Subject Re: index problems (again)
Date
Msg-id CAGnEbohEG36EHeaWFG6Pz4ZqmhBUxYnApULiBspy8s8Jxx4Bvw@mail.gmail.com
Whole thread Raw
In response to index problems (again)  (Geoff Winkless <pgsqladmin@geoff.dj>)
Responses Re: index problems (again)  (Geoff Winkless <pgsqladmin@geoff.dj>)
List pgsql-general
Tree view
2016-03-07 13:38 GMT+02:00 Geoff Winkless <pgsqladmin@geoff.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

pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: index problems (again)
Next
From: Geoff Winkless
Date:
Subject: Re: index problems (again)