explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6UFW

Settings
# exclusive inclusive rows x rows loops node
1. 3,042.866 29,342.526 ↓ 1.0 187,600 1

Group (cost=261,127.28..285,044.57 rows=185,256 width=988) (actual time=23,152.788..29,342.526 rows=187,600 loops=1)

  • Group Key: i.id, attr.data_norm, attr.r_ref, attr.data, attr.frequency_hz, attr.num_ports, attr.frequency
2. 0.000 26,299.660 ↓ 1.2 187,600 1

Gather Merge (cost=261,127.28..280,490.36 rows=154,380 width=924) (actual time=23,152.762..26,299.660 rows=187,600 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 277.212 69,853.419 ↑ 1.2 62,533 3

Group (cost=260,127.25..261,671.05 rows=77,190 width=924) (actual time=23,102.338..23,284.473 rows=62,533 loops=3)

  • Group Key: i.id, attr.data_norm, attr.r_ref, attr.data, attr.frequency_hz, attr.num_ports, attr.frequency
4. 959.607 69,576.207 ↑ 1.2 62,533 3

Sort (cost=260,127.25..260,320.23 rows=77,190 width=924) (actual time=23,102.333..23,192.069 rows=62,533 loops=3)

  • Sort Key: i.id DESC, attr.data_norm, attr.r_ref, attr.data, attr.frequency_hz, attr.num_ports, attr.frequency
  • Sort Method: external merge Disk: 59088kB
5. 16,007.169 68,616.600 ↑ 1.2 62,533 3

Hash Left Join (cost=123,287.02..191,063.92 rows=77,190 width=924) (actual time=13,326.423..22,872.200 rows=62,533 loops=3)

  • Hash Cond: (i.id = attr.bo_instance_id)
6. 12,682.146 12,682.146 ↑ 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=2.244..4,227.382 rows=62,533 loops=3)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 103))
  • Rows Removed by Filter: 17291
7. 1,554.087 39,927.285 ↓ 1.0 188,138 3

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

  • Buckets: 8192 Batches: 64 Memory Usage: 2699kB
8. 38,373.198 38,373.198 ↓ 1.0 188,138 3

Seq Scan on attrib_touchstone attr (cost=0.00..100,594.90 rows=187,690 width=863) (actual time=4,844.046..12,791.066 rows=188,138 loops=3)

Planning time : 0.431 ms
Execution time : 29,433.727 ms