explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VFnu

Settings
# exclusive inclusive rows x rows loops node
1. 0.346 0.346 ↓ 1.2 34 1

Index Scan using index_test_greg_mc on bodet.changement_calendrier changement0_ (cost=0.29..425.34 rows=29 width=25) (actual time=0.039..0.346 rows=34 loops=1)

  • Output: changement_calendrier_, date_changement_, date_fin_, exception_, calendrier_, salarie_, contrat_horaire_
  • Index Cond: ((changement0_.salarie_ = ANY ('{21618,24570,18258,4053,13074,18938,21010,26274,854,6806,30569,30943,30031,5220,4694,19585,24147,11939,8098,2247,19037,7947,4456,11579,26574,17754,2883,235,12096,9399,27525,21479,16182,7702,21851,25911,19644,11269,950,17436,12577,9936,6065,24591,13803,15865,14819,22308,16471,24660}'::integer[])) AND (changement0_.date_changement_ <= '2017-07-23'::date))
  • Filter: ((changement0_.date_fin_ >= '2016-06-20'::date) OR (changement0_.date_fin_ IS NULL))
  • Rows Removed by Filter: 80
Planning time : 0.217 ms