explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mwg2

Settings
# exclusive inclusive rows x rows loops node
1. 40.305 128.070 ↑ 1.0 71,100 1

Hash Right Join (cost=2,754.25..4,149.88 rows=71,100 width=72) (actual time=92.346..128.070 rows=71,100 loops=1)

  • Hash Cond: ((tla.cid = mr.unit_space_id) AND (tla.unit_space_id = mr.unit_space_id))
2. 8.588 8.588 ↓ 2.2 8,824 1

Seq Scan on temp_lease_activity tla (cost=0.00..1,365.78 rows=3,978 width=8) (actual time=0.037..8.588 rows=8,824 loops=1)

3. 37.208 79.177 ↑ 1.0 71,100 1

Hash (cost=1,687.75..1,687.75 rows=71,100 width=16) (actual time=79.176..79.177 rows=71,100 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 4,493kB
4. 41.969 41.969 ↑ 1.0 71,100 1

Seq Scan on market_rents mr (cost=0.00..1,687.75 rows=71,100 width=16) (actual time=0.010..41.969 rows=71,100 loops=1)

  • Filter: (cid = 13,531)
Planning time : 0.162 ms