explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IqAx

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 30,233.167 ↑ 1.5 4 1

Finalize GroupAggregate (cost=2,484,326.79..2,484,328.59 rows=6 width=68) (actual time=30,233.159..30,233.167 rows=4 loops=1)

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

Gather Merge (cost=2,484,326.79..2,484,328.19 rows=12 width=140) (actual time=30,233.146..30,234.992 rows=12 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.135 90,691.782 ↑ 1.5 4 3

Sort (cost=2,483,326.77..2,483,326.78 rows=6 width=140) (actual time=30,230.593..30,230.594 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. 27,250.722 90,691.647 ↑ 1.5 4 3

Partial HashAggregate (cost=2,483,326.63..2,483,326.69 rows=6 width=140) (actual time=30,230.547..30,230.549 rows=4 loops=3)

  • Group Key: l_returnflag, l_linestatus
5. 63,440.925 63,440.925 ↑ 1.2 19,714,203 3

Parallel Seq Scan on lineitem (cost=0.00..1,498,658.71 rows=24,616,698 width=36) (actual time=2.790..21,146.975 rows=19,714,203 loops=3)

  • Filter: (l_shipdate <= '1998-09-02 00:00:00'::timestamp without time zone)
  • Rows Removed by Filter: 281148