explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mbl

Settings
# exclusive inclusive rows x rows loops node
1. 0.111 26,811.801 ↑ 1.0 150 1

Limit (cost=261,127.28..261,150.02 rows=150 width=172) (actual time=26,811.456..26,811.801 rows=150 loops=1)

2. 1,102.952 26,811.690 ↑ 1,235.0 150 1

WindowAgg (cost=261,127.28..289,212.83 rows=185,256 width=172) (actual time=26,811.453..26,811.690 rows=150 loops=1)

3. 3,213.252 25,708.738 ↓ 1.0 187,600 1

Group (cost=261,127.28..285,044.57 rows=185,256 width=988) (actual time=19,312.981..25,708.738 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
4. 0.000 22,495.486 ↓ 1.2 187,600 1

Gather Merge (cost=261,127.28..280,490.36 rows=154,380 width=924) (actual time=19,312.932..22,495.486 rows=187,600 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 299.160 58,377.219 ↑ 1.2 62,533 3

Group (cost=260,127.25..261,671.05 rows=77,190 width=924) (actual time=19,260.123..19,459.073 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
6. 975.165 58,078.059 ↑ 1.2 62,533 3

Sort (cost=260,127.25..260,320.23 rows=77,190 width=924) (actual time=19,260.118..19,359.353 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: 58968kB
7. 10,090.458 57,102.894 ↑ 1.2 62,533 3

Hash Left Join (cost=123,287.02..191,063.92 rows=77,190 width=924) (actual time=11,183.869..19,034.298 rows=62,533 loops=3)

  • Hash Cond: (i.id = attr.bo_instance_id)
8. 13,598.076 13,598.076 ↑ 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=11.157..4,532.692 rows=62,533 loops=3)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 103))
  • Rows Removed by Filter: 17291
9. 1,052.502 33,414.360 ↓ 1.0 188,138 3

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

  • Buckets: 8192 Batches: 64 Memory Usage: 2699kB
10. 32,361.858 32,361.858 ↓ 1.0 188,138 3

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