explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lwfz

Settings
# exclusive inclusive rows x rows loops node
1. 0.111 114,227.208 ↑ 1.0 150 1

Limit (cost=2,356,886.86..2,356,902.23 rows=150 width=300) (actual time=114,224.907..114,227.208 rows=150 loops=1)

2. 7,860.985 114,227.097 ↑ 3,874.0 150 1

WindowAgg (cost=2,356,886.86..2,416,448.99 rows=581,094 width=300) (actual time=114,224.903..114,227.097 rows=150 loops=1)

3. 11,406.027 106,366.112 ↑ 3.1 187,600 1

GroupAggregate (cost=2,356,886.86..2,403,374.38 rows=581,094 width=1,101) (actual time=94,847.705..106,366.112 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. 2,175.871 94,960.085 ↑ 3.1 187,735 1

Sort (cost=2,356,886.86..2,358,339.59 rows=581,094 width=1,009) (actual time=94,725.664..94,960.085 rows=187,735 loops=1)

  • 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: 177808kB
5. 0.000 92,784.214 ↑ 3.1 187,735 1

Gather (cost=1,000.42..1,784,847.72 rows=581,094 width=1,009) (actual time=7.980..92,784.214 rows=187,735 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 59,308.355 93,055.731 ↑ 3.9 62,578 3

Nested Loop Left Join (cost=0.42..1,725,738.32 rows=242,122 width=1,009) (actual time=4.728..93,055.731 rows=62,578 loops=3)

7. 32,450.732 33,746.434 ↑ 1.2 62,578 3

Nested Loop Left Join (cost=0.00..428,361.86 rows=77,190 width=154) (actual time=3.576..33,746.434 rows=62,578 loops=3)

  • Join Filter: (i.tags @> ARRAY[t.id])
  • Rows Removed by Join Filter: 8692078
8. 1,295.419 1,295.419 ↑ 1.2 62,533 3

Parallel Seq Scan on bo_instance i (cost=0.00..44,727.56 rows=77,190 width=82) (actual time=1.778..1,295.419 rows=62,533 loops=3)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 103))
  • Rows Removed by Filter: 17291
9. 0.283 0.283 ↓ 1.1 139 187,600

Seq Scan on tag t (cost=0.00..3.32 rows=132 width=93) (actual time=0.007..0.283 rows=139 loops=187,600)

10. 0.169 0.942 ↑ 1.0 1 187,735

Nested Loop Left Join (cost=0.42..16.80 rows=1 width=863) (actual time=0.256..0.942 rows=1 loops=187,735)

  • Join Filter: (attr.parameter_type208 @> ARRAY[parameter_type208.id])
  • Rows Removed by Join Filter: 94
11. 0.174 0.654 ↑ 1.0 1 187,735

Nested Loop Left Join (cost=0.42..12.05 rows=1 width=890) (actual time=0.163..0.654 rows=1 loops=187,735)

  • Join Filter: (attr.freq_units206 @> ARRAY[freq_units206.id])
  • Rows Removed by Join Filter: 94
12. 0.173 0.360 ↑ 1.0 1 187,735

Nested Loop Left Join (cost=0.42..7.31 rows=1 width=917) (actual time=0.108..0.360 rows=1 loops=187,735)

  • Join Filter: (attr.format204 @> ARRAY[format204.id])
  • Rows Removed by Join Filter: 94
13. 0.065 0.065 ↑ 1.0 1 187,735

Index Scan using idx_attrib_touchstone_bo_instance_id on attrib_touchstone attr (cost=0.42..2.56 rows=1 width=944) (actual time=0.062..0.065 rows=1 loops=187,735)

  • Index Cond: (i.id = bo_instance_id)
14. 0.122 0.122 ↑ 1.3 95 187,735

Seq Scan on bo_attribute_value format204 (cost=0.00..3.22 rows=122 width=13) (actual time=0.006..0.122 rows=95 loops=187,735)

15. 0.120 0.120 ↑ 1.3 95 187,735

Seq Scan on bo_attribute_value freq_units206 (cost=0.00..3.22 rows=122 width=13) (actual time=0.006..0.120 rows=95 loops=187,735)

16. 0.119 0.119 ↑ 1.3 95 187,735

Seq Scan on bo_attribute_value parameter_type208 (cost=0.00..3.22 rows=122 width=13) (actual time=0.005..0.119 rows=95 loops=187,735)

Planning time : 70.620 ms
Execution time : 114,438.389 ms