explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JD4m

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

Hash Right Join (cost=50,949.84..198,622.45 rows=184,914 width=164) (actual time=340.938..11,263.473 rows=187,600 loops=1)

  • Hash Cond: (attr.bo_instance_id = i.id)
2. 7,506.461 7,506.461 ↓ 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..7,506.461 rows=188,138 loops=1)

3. 114.679 340.741 ↓ 1.0 187,600 1

Hash (cost=46,471.41..46,471.41 rows=184,914 width=69) (actual time=340.741..340.741 rows=187,600 loops=1)

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

Seq Scan on bo_instance i (cost=0.00..46,471.41 rows=184,914 width=69) (actual time=0.318..226.062 rows=187,600 loops=1)

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