explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 91wZ

Settings

Optimization(s) for this plan:

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

Hash Join (cost=2.30..3.78 rows=1 width=8) (actual rows= loops=)

  • Hash Cond: (dc.id = ai.datacenter_id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on datacenter dc (cost=0.00..1.34 rows=34 width=16) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=2.29..2.29 rows=1 width=8) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using application_instance_pkey on application_instance ai (cost=0.27..2.29 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = 152)