explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CLzD

Settings
# exclusive inclusive rows x rows loops node
1. 0.646 48,321.331 ↑ 1.0 1 1

Aggregate (cost=845,313.73..845,313.74 rows=1 width=0) (actual time=48,321.33..48,321.331 rows=1 loops=1)

  • Buffers: shared hit=34140 read=316902, temp read=42299 written=42269
2. 10,904.233 48,320.685 ↑ 662.8 1,601 1

Hash Join (cost=330,744.09..842,660.92 rows=1,061,126 width=0) (actual time=20,865.141..48,320.685 rows=1,601 loops=1)

  • Filter: (e2."end" IS NULL)
  • Buffers: shared hit=34140 read=316902, temp read=42299 written=42269
3. 16,675.473 16,675.473 ↑ 1.0 13,600,712 1

Seq Scan on edge e2 (cost=0..311,714.19 rows=13,619,319 width=12) (actual time=0.615..16,675.473 rows=13,600,712 loops=1)

  • Buffers: shared hit=17086 read=158435
4. 617.097 20,740.979 ↓ 1.0 1,189,881 1

Hash (cost=311,714.19..311,714.19 rows=1,159,912 width=4) (actual time=20,740.979..20,740.979 rows=1,189,881 loops=1)

  • Buffers: shared hit=17054 read=158467, temp written=3261
5. 20,123.882 20,123.882 ↓ 1.0 1,189,881 1

Seq Scan on edge e1 (cost=0..311,714.19 rows=1,159,912 width=4) (actual time=0.009..20,123.882 rows=1,189,881 loops=1)

  • Filter: (e1."end" IS NOT NULL)
  • Buffers: shared hit=17054 read=158467