explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h5V2

Settings
# exclusive inclusive rows x rows loops node
1. 218.338 660.158 ↑ 49,060.0 9 1

HashAggregate (cost=1,475,936.64..1,480,352.04 rows=441,540 width=20) (actual time=659.740..660.158 rows=9 loops=1)

  • Group Key: lease_fact."CLOSING_DATE_DEBUT", lease_fact."CLOSING_DATE_FIN", lease_fact."FLOW", lease_fact."ACCOUNT
  • Planning time: 0.434 ms
  • Execution time: 663.215 ms
2. 354.189 441.820 ↑ 3.3 138,368 1

Bitmap Heap Scan on lease_fact (cost=49,531.07..1,470,262.66 rows=453,919 width=20) (actual time=105.685..441.820 rows=138,368 loops=1)

  • Recheck Cond: (("CLOSING_DATE_DEBUT" <= '2018-12-31'::date) AND ("CLOSING_DATE_FIN" >= '2018-12-31'::date) AND ("MONTH" IS NULL) AND ("FLOW" IS NOT NULL) AND ("CURRENCY_CONVERSION" IS NULL))
  • Filter: ((("TRANSITION_OPTION" IS NULL) OR ("TRANSITION_OPTION" = 2)) AND ("ACCOUNT" = ANY ('{4,3,14,18,5,13,15}'::integer[])))
  • Rows Removed by Filter: 35823
  • Heap Blocks: exact=80113
3. 87.631 87.631 ↑ 10.7 174,796 1

Bitmap Index Scan on idx_lease_fact_date_no_month_flow_no_currency (cost=0.00..49,417.60 rows=1,867,037 width=0) (actual time=87.630..87.631 rows=174,796 loops=1)

  • Index Cond: (("CLOSING_DATE_DEBUT" <= '2018-12-31'::date) AND ("CLOSING_DATE_FIN" >= '2018-12-31'::date))