explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y7XR : Optimization for: test; plan #HoxQ

Settings

Optimization path:

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

Hash Join (cost=1.04..2.13 rows=2 width=3,186) (actual rows= loops=)

  • Hash Cond: (c.id = m.client_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on clients c (cost=0.00..1.05 rows=5 width=1,048) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=1.02..1.02 rows=2 width=2,154) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on matters m (cost=0.00..1.02 rows=2 width=2,154) (actual rows= loops=)