explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KhPo

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=4,881,309,446.31..4,881,309,446.33 rows=1 width=32) (never executed)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=11,741.82..4,881,309,435.46 rows=4,340 width=8) (never executed)

3. 0.000 0.000 ↓ 0.0

Seq Scan on lineitem lineitem (cost=0..344,909.12 rows=11,998,912 width=17) (never executed)

4. 0.000 0.000 ↓ 0.0

Hash (cost=11,736.4..11,736.4 rows=434 width=4) (never executed)

5. 0.000 0.000 ↓ 0.0

Gather (cost=1,000..11,736.4 rows=434 width=4) (never executed)

  • Workers Planned: 2
6. 0.000 0.000 ↓ 0.0

Seq Scan on part part (cost=0..10,693 rows=181 width=4) (never executed)

  • Filter: ((p_brand = 'Brand#35'::bpchar) AND (p_container = 'MED DRUM'::bpchar))
7.          

SubPlan (for Hash Join)

8. 0.000 0.000 ↓ 0.0

Aggregate (cost=374,906.48..374,906.49 rows=1 width=32) (never executed)

9. 0.000 0.000 ↓ 0.0

Seq Scan on lineitem lineitem_1 (cost=0..374,906.4 rows=31 width=5) (never executed)

  • Filter: (l_partkey = part.p_partkey)