explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bJMg

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 614.366 ↑ 1.0 1 1

Aggregate (cost=382,528.44..382,528.45 rows=1 width=32) (actual time=614.366..614.366 rows=1 loops=1)

2. 6.657 617.548 ↓ 1.5 3 1

Gather (cost=382,528.22..382,528.43 rows=2 width=32) (actual time=613.562..617.548 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 28.986 610.891 ↑ 1.0 1 3 / 3

Aggregate (cost=381,528.22..381,528.23 rows=1 width=32) (actual time=610.89..610.891 rows=1 loops=3)

4. 510.011 581.905 ↑ 1.2 76,053 3 / 3

Bitmap Heap Scan on lineitem lineitem (cost=59,669.02..381,054.48 rows=94,748 width=12) (actual time=227.599..581.905 rows=76,053 loops=3)

  • Heap Blocks: exact=17,478 lossy=18,506
5. 71.894 71.894 ↓ 1.0 228,160 1 / 3

Bitmap Index Scan on lineitem_date_disc_quant (cost=0..59,612.17 rows=227,396 width=0) (actual time=215.681..215.681 rows=228,160 loops=1)

  • Index Cond: ((l_shipdate >= '1996-01-01'::date) AND (l_shipdate < '1997-01-01'::date) AND (l_discount >= 0.05) AND (l_discount <= 0.07) AND (l_quantity < '24'::numeric))
Planning time : 0.106 ms
Execution time : 617.602 ms