explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wx8O

Settings
# exclusive inclusive rows x rows loops node
1. 123.872 183.033 ↓ 1.0 189,530 1

Hash Join (cost=702.89..6,545.15 rows=186,845 width=263) (actual time=8.650..183.033 rows=189,530 loops=1)

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

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

3. 4.734 8.622 ↑ 1.0 13,862 1

Hash (cost=529.62..529.62 rows=13,862 width=228) (actual time=8.622..8.622 rows=13,862 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 2523kB
4. 3.888 3.888 ↑ 1.0 13,862 1

Seq Scan on ssrs_batch ssrs (cost=0.00..529.62 rows=13,862 width=228) (actual time=0.003..3.888 rows=13,862 loops=1)