explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EtTB

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

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

2. 4.433 826.689 ↓ 1.5 3 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 28.038 822.256 ↑ 1.0 1 3 / 3

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

4. 53.829 794.218 ↑ 1.3 50,163 3 / 3

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

5. 17.608 17.608 ↑ 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..17.608 rows=133,333 loops=3)

6. 18.598 722.781 ↑ 1.3 50,163 3 / 3

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

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

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

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