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