explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qbGZ

Settings
# exclusive inclusive rows x rows loops node
1. 1,548.402 4,917.271 ↓ 5.1 186,434 1

HashAggregate (cost=2,278,923.50..2,279,286.81 rows=36,331 width=18) (actual time=4,848.439..4,917.271 rows=186,434 loops=1)

  • Group Key: vcligne_tag
2. 2,852.072 3,368.869 ↓ 1.0 3,028,553 1

Bitmap Heap Scan on vcligne (cost=186,913.57..2,264,058.19 rows=2,973,063 width=18) (actual time=531.330..3,368.869 rows=3,028,553 loops=1)

  • Recheck Cond: ((vcligne_dossier_id = 15) AND (vcligne_date >= '2019-06-29 00:00:00'::timestamp without time zone) AND (vcligne_date <= '2020-06-29 23:59:59.999999'::timestamp without time zone))
  • Rows Removed by Index Recheck: 1,911,525
  • Filter: ((vcligne_typelotcalc)::text = ANY ('{"Article simple","Article lot détail","Article assemblé détail"}'::text[]))
  • Rows Removed by Filter: 470
  • Heap Blocks: exact=78,652 lossy=397,113
3. 516.797 516.797 ↓ 1.0 3,029,024 1

Bitmap Index Scan on vcligne_date_sk (cost=0.00..186,170.30 rows=2,975,179 width=0) (actual time=516.797..516.797 rows=3,029,024 loops=1)

  • Index Cond: ((vcligne_dossier_id = 15) AND (vcligne_date >= '2019-06-29 00:00:00'::timestamp without time zone) AND (vcligne_date <= '2020-06-29 23:59:59.999999'::timestamp without time zone))