explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tOxx

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

Hash Anti Join (cost=40.00..167.22 rows=900 width=8) (actual rows= loops=)

  • Hash Cond: ((p1.source = p2.source) AND (p1.target = p2.target))
2. 0.000 0.000 ↓ 0.0

Seq Scan on ptc p1 (cost=0.00..22.00 rows=1,200 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=22.00..22.00 rows=1,200 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on ptc p2 (cost=0.00..22.00 rows=1,200 width=8) (actual rows= loops=)