explain.depesz.com

PostgreSQL's explain analyze made readable

Result: URjr

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 26,397.458 ↓ 1.2 187,600 1

Gather Merge (cost=205,437.18..223,449.43 rows=154,380 width=164) (actual time=23,621.215..26,397.458 rows=187,600 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 2,661.279 70,790.427 ↑ 1.2 62,533 3

Sort (cost=204,437.15..204,630.13 rows=77,190 width=164) (actual time=23,487.337..23,596.809 rows=62,533 loops=3)

  • Sort Key: i.id DESC
  • Sort Method: external merge Disk: 105152kB
3. 22,146.618 68,129.148 ↑ 1.2 62,533 3

Hash Left Join (cost=123,287.02..191,835.82 rows=77,190 width=164) (actual time=10,566.025..22,709.716 rows=62,533 loops=3)

  • Hash Cond: (i.id = attr.bo_instance_id)
4. 14,464.128 14,464.128 ↑ 1.2 62,533 3

Parallel Seq Scan on bo_instance i (cost=0.00..44,727.56 rows=77,190 width=69) (actual time=3.415..4,821.376 rows=62,533 loops=3)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 103))
  • Rows Removed by Filter: 17291
5. 1,554.399 31,518.402 ↓ 1.0 188,138 3

Hash (cost=100,594.90..100,594.90 rows=187,690 width=863) (actual time=10,506.134..10,506.134 rows=188,138 loops=3)

  • Buckets: 8192 Batches: 64 Memory Usage: 2699kB
6. 29,964.003 29,964.003 ↓ 1.0 188,138 3

Seq Scan on attrib_touchstone attr (cost=0.00..100,594.90 rows=187,690 width=863) (actual time=0.014..9,988.001 rows=188,138 loops=3)

Planning time : 0.359 ms
Execution time : 26,506.376 ms