explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w8ic

Settings
# exclusive inclusive rows x rows loops node
1. 3,265.221 11,113.695 ↓ 1.0 187,600 1

Hash Right Join (cost=50,963.65..198,643.69 rows=185,256 width=164) (actual time=2,057.071..11,113.695 rows=187,600 loops=1)

  • Hash Cond: (attr.bo_instance_id = i.id)
2. 5,791.594 5,791.594 ↓ 1.0 188,138 1

Seq Scan on attrib_touchstone attr (cost=0.00..100,594.90 rows=187,690 width=863) (actual time=0.008..5,791.594 rows=188,138 loops=1)

3. 122.447 2,056.880 ↓ 1.0 187,600 1

Hash (cost=46,476.95..46,476.95 rows=185,256 width=69) (actual time=2,056.880..2,056.880 rows=187,600 loops=1)

  • Buckets: 65536 Batches: 8 Memory Usage: 2983kB
4. 1,934.433 1,934.433 ↓ 1.0 187,600 1

Seq Scan on bo_instance i (cost=0.00..46,476.95 rows=185,256 width=69) (actual time=2.790..1,934.433 rows=187,600 loops=1)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 103))
  • Rows Removed by Filter: 51873
Planning time : 0.308 ms
Execution time : 11,182.590 ms