explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7qsR

Settings
# exclusive inclusive rows x rows loops node
1. 36.034 81.390 ↓ 216.5 5,197 1

Hash Join (cost=1,670.67..3,714.16 rows=24 width=72) (actual time=15.164..81.390 rows=5,197 loops=1)

  • Hash Cond: (mr.unit_space_id = tla.unit_space_id)
2. 32.093 32.093 ↑ 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.008..32.093 rows=71,100 loops=1)

  • Filter: (cid = 13,531)
3. 3.705 13.263 ↓ 216.5 5,197 1

Hash (cost=1,670.38..1,670.38 rows=24 width=8) (actual time=13.262..13.263 rows=5,197 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 268kB
4. 9.558 9.558 ↓ 367.7 8,824 1

Seq Scan on temp_lease_activity tla (cost=0.00..1,670.38 rows=24 width=8) (actual time=0.022..9.558 rows=8,824 loops=1)

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