explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Syjo

Settings
# exclusive inclusive rows x rows loops node
1. 154.618 222.222 ↓ 1.0 189,509 1

Hash Join (cost=703.98..6,546.23 rows=186,845 width=263) (actual time=12.378..222.222 rows=189,509 loops=1)

  • Hash Cond: (sbr.ssrs_batch_id = ssrs.id)
2. 55.259 55.259 ↓ 1.0 189,509 1

Seq Scan on ssrs_batch_record sbr (cost=0.00..3,483.45 rows=186,845 width=35) (actual time=0.004..55.259 rows=189,509 loops=1)

3. 6.922 12.345 ↑ 1.0 13,858 1

Hash (cost=530.10..530.10 rows=13,910 width=228) (actual time=12.345..12.345 rows=13,858 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 2522kB
4. 5.423 5.423 ↑ 1.0 13,858 1

Seq Scan on ssrs_batch ssrs (cost=0.00..530.10 rows=13,910 width=228) (actual time=0.004..5.423 rows=13,858 loops=1)