explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9sZe

Settings
# exclusive inclusive rows x rows loops node
1. 218.177 661.140 ↑ 49,060.0 9 1

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

  • Group Key: lease_fact."ACCOUNT", lease_fact."CLOSING_DATE_DEBUT", lease_fact."CLOSING_DATE_FIN", lease_fact."FLOW
  • Planning time: 0.429 ms
  • Execution time: 663.801 ms
2. 355.587 442.963 ↑ 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=106.031..442.963 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.376 87.376 ↑ 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.376..87.376 rows=174,796 loops=1)

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