explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M309

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 0.034 ↑ 324.0 2 1

Hash Join (cost=18.10..55.28 rows=648 width=210) (actual time=0.033..0.034 rows=2 loops=1)

  • Hash Cond: ((weather.city)::text = (cities.name)::text)
2. 0.006 0.006 ↑ 120.0 3 1

Seq Scan on weather (cost=0.00..13.60 rows=360 width=194) (actual time=0.006..0.006 rows=3 loops=1)

3. 0.008 0.012 ↑ 360.0 1 1

Hash (cost=13.60..13.60 rows=360 width=194) (actual time=0.012..0.012 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
4. 0.004 0.004 ↑ 360.0 1 1

Seq Scan on cities (cost=0.00..13.60 rows=360 width=194) (actual time=0.003..0.004 rows=1 loops=1)

Planning time : 0.072 ms
Execution time : 0.053 ms