explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fdy5

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

Aggregate (cost=70,053.62..70,053.63 rows=1 width=32) (actual time=141.44..141.44 rows=1 loops=1)

2. 3.318 142.506 ↓ 1.5 3 1

Gather (cost=70,053.4..70,053.61 rows=2 width=32) (actual time=141.378..142.506 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 24.770 139.188 ↑ 1.0 1 3 / 3

Aggregate (cost=69,053.4..69,053.41 rows=1 width=32) (actual time=139.188..139.188 rows=1 loops=3)

4. 114.418 114.418 ↑ 1.2 76,053 3 / 3

Index Only Scan using lineitem_date_disc_quant_price on lineitem lineitem (cost=0.56..68,579.66 rows=94,748 width=12) (actual time=0.06..114.418 rows=76,053 loops=3)

  • 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.168 ms
Execution time : 142.561 ms