explain.depesz.com

PostgreSQL's explain analyze made readable

Result: STGB

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 546.474 ↑ 1.5 4 1

Finalize GroupAggregate (cost=42,414.13..42,415.94 rows=6 width=68) (actual time=546.456..546.474 rows=4 loops=1)

  • Group Key: l_returnflag, l_linestatus
2. 0.000 549.137 ↑ 1.0 12 1

Gather Merge (cost=42,414.13..42,415.53 rows=12 width=140) (actual time=546.427..549.137 rows=12 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.219 1,617.000 ↑ 1.5 4 3

Sort (cost=41,414.11..41,414.13 rows=6 width=140) (actual time=538.999..539.000 rows=4 loops=3)

  • Sort Key: l_returnflag, l_linestatus
  • Sort Method: quicksort Memory: 26kB
  • Worker 0: Sort Method: quicksort Memory: 26kB
  • Worker 1: Sort Method: quicksort Memory: 26kB
4. 1,202.439 1,616.781 ↑ 1.5 4 3

Partial HashAggregate (cost=41,413.97..41,414.03 rows=6 width=140) (actual time=538.924..538.927 rows=4 loops=3)

  • Group Key: l_returnflag, l_linestatus
5. 414.342 414.342 ↑ 1.2 328,615 3

Parallel Seq Scan on lineitem (cost=0.00..24,986.33 rows=410,691 width=36) (actual time=0.074..138.114 rows=328,615 loops=3)

  • Filter: (l_shipdate <= '1998-09-02 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 4719
Planning time : 0.487 ms
Execution time : 549.387 ms