Hi2017-07-03 12:09 GMT+02:00 <pavel.tavoda@gmail.com>:SELECT count(*) FROM contractportfolio cp JOIN contract co ON cp.contract =co.id WHERE validfor between '2017-05-30' AND '2017-05-31'; Time: 0.473
SELECT count(*) FROM contractportfolio cp JOIN contract co ON cp.contract =co.id WHERE validfor between '2017-05-30' AND '2017-05-31'; Time: 0.473
SELECT count(*) FROM contractportfolio cp JOIN contract co ON cp.contract =co.id WHERE validfor between '2017-05-31' AND '2017-05-31'; Time: 19.172
SELECT count(*) FROM contractportfolio cp JOIN contract co ON cp.contract =co.id WHERE validfor = '2017-05-31'; Time: 0.467
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных