Re: [GENERAL] index problems (again)

[Victor Yegorov]

2016-03-07 13:38 GMT+02:00 Geoff Winkless <pgsqlad...@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