explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vCob

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 6,802.466 ↑ 1.5 4 1

GroupAggregate (cost=485,047.51..485,049.58 rows=6 width=236) (actual time=6,802.409..6,802.466 rows=4 loops=1)

  • Group Key: l_returnflag, l_linestatus
2. 3.394 6,803.589 ↑ 1.0 12 1

Gather Merge (cost=485,047.51..485,048.91 rows=12 width=236) (actual time=6,802.37..6,803.589 rows=12 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.032 6,800.195 ↑ 1.5 4 3 / 3

Sort (cost=484,047.49..484,047.5 rows=6 width=236) (actual time=6,800.194..6,800.195 rows=4 loops=3)

  • Sort Key: l_returnflag, l_linestatus
  • Sort Method: quicksort Memory: 27kB
4. 5,826.529 6,800.163 ↑ 1.5 4 3 / 3

HashAggregate (cost=484,047.24..484,047.41 rows=6 width=236) (actual time=6,800.153..6,800.163 rows=4 loops=3)

  • Group Key: l_returnflag, l_linestatus
5. 973.634 973.634 ↑ 1.3 3,924,216 3 / 3

Seq Scan on lineitem lineitem (cost=0..287,409.56 rows=4,915,942 width=25) (actual time=0.007..973.634 rows=3,924,216 loops=3)

  • Filter: (l_shipdate <= '1998-08-19 00:00:00'::timestamp without time zone)
Planning time : 0.259 ms
Execution time : 6,803.743 ms