explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 92mV

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

Aggregate (cost=390,548.44..390,548.45 rows=1 width=32) (actual time=630.107..630.107 rows=1 loops=1)

2. 6.219 632.920 ↓ 1.5 3 1

Gather (cost=390,548.22..390,548.43 rows=2 width=32) (actual time=629.307..632.92 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 28.679 626.701 ↑ 1.0 1 3 / 3

Aggregate (cost=389,548.22..389,548.23 rows=1 width=32) (actual time=626.701..626.701 rows=1 loops=3)

4. 520.840 598.022 ↑ 1.2 76,053 3 / 3

Bitmap Heap Scan on lineitem lineitem (cost=67,689.02..389,074.48 rows=94,748 width=12) (actual time=244.768..598.022 rows=76,053 loops=3)

  • Heap Blocks: exact=31,702 lossy=33,686
5. 77.182 77.182 ↓ 1.0 228,160 1 / 3

Bitmap Index Scan on lineitem_date_disc_quant_price (cost=0..67,632.17 rows=227,396 width=0) (actual time=231.547..231.547 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.14 ms
Execution time : 632.968 ms