explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wekCy

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

Aggregate (cost=316,121.01..316,121.02 rows=1 width=32) (actual time=822.446..822.447 rows=1 loops=1)

2. 4.518 824.076 ↓ 1.5 3 1

Gather (cost=316,120.77..316,120.98 rows=2 width=64) (actual time=821.618..824.076 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 30.180 819.558 ↑ 1.0 1 3 / 3

Aggregate (cost=315,120.77..315,120.78 rows=1 width=64) (actual time=819.558..819.558 rows=1 loops=3)

4. 55.834 789.378 ↑ 1.3 50,163 3 / 3

Hash Join (cost=300,722.82..313,979.28 rows=65,228 width=33) (actual time=715.775..789.378 rows=50,163 loops=3)

5. 18.666 18.666 ↑ 1.3 133,333 3 / 3

Seq Scan on part part (cost=0..9,859.67 rows=166,667 width=25) (actual time=0.006..18.666 rows=133,333 loops=3)

6. 18.189 714.878 ↑ 1.3 50,163 3 / 3

Hash (cost=299,907.47..299,907.47 rows=65,228 width=16) (actual time=714.877..714.878 rows=50,163 loops=3)

7. 696.689 696.689 ↑ 1.3 50,163 3 / 3

Seq Scan on lineitem lineitem (cost=0..299,907.47 rows=65,228 width=16) (actual time=0.02..696.689 rows=50,163 loops=3)

  • Filter: ((l_shipdate >= '1993-11-01'::date) AND (l_shipdate < '1993-12-01'::date))
Planning time : 0.126 ms
Execution time : 824.142 ms