explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RUDI

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 24,407.291 ↑ 1.0 150 1

Limit (cost=1,565,965.07..1,565,980.44 rows=150 width=292) (actual time=24,407.233..24,407.291 rows=150 loops=1)

2. 651.525 24,407.279 ↑ 1,569.6 150 1

WindowAgg (cost=1,565,965.07..1,590,097.16 rows=235,435 width=292) (actual time=24,407.231..24,407.279 rows=150 loops=1)

3. 5,630.310 23,755.754 ↑ 1.0 235,348 1

GroupAggregate (cost=1,565,965.07..1,584,799.87 rows=235,435 width=877) (actual time=18,034.938..23,755.754 rows=235,348 loops=1)

  • Group Key: i.id, attr.data_norm, attr.r_ref, attr.frequency, attr.num_ports, attr.frequency_hz, attr.data
4. 428.386 18,125.444 ↑ 1.0 235,351 1

Sort (cost=1,565,965.07..1,566,553.66 rows=235,435 width=792) (actual time=18,034.905..18,125.444 rows=235,351 loops=1)

  • Sort Key: i.id DESC, attr.data_norm, attr.r_ref, attr.frequency, attr.num_ports, attr.frequency_hz, attr.data
  • Sort Method: external merge Disk: 167376kB
5. 2,950.805 17,697.058 ↑ 1.0 235,351 1

Nested Loop Left Join (cost=26,180.41..1,380,794.42 rows=235,435 width=792) (actual time=128.010..17,697.058 rows=235,351 loops=1)

  • Join Filter: (i.tags @> ARRAY[t.id])
  • Rows Removed by Join Filter: 18592488
6. 307.450 14,040.209 ↑ 1.0 235,348 1

Hash Right Join (cost=26,180.41..1,101,801.95 rows=235,435 width=713) (actual time=127.966..14,040.209 rows=235,348 loops=1)

  • Hash Cond: (attr.bo_instance_id = i.id)
7. 3,779.517 13,605.544 ↑ 1.0 235,348 1

Nested Loop Left Join (cost=0.00..1,033,171.74 rows=235,348 width=651) (actual time=0.038..13,605.544 rows=235,348 loops=1)

  • Join Filter: (attr.parameter_type32 @> ARRAY[parameter_type32.id])
  • Rows Removed by Join Filter: 22124677
8. 3,808.117 9,119.983 ↑ 1.0 235,348 1

Nested Loop Left Join (cost=0.00..697,797.66 rows=235,348 width=675) (actual time=0.031..9,119.983 rows=235,348 loops=1)

  • Join Filter: (attr.freq_units30 @> ARRAY[freq_units30.id])
  • Rows Removed by Join Filter: 22124677
9. 3,807.103 4,605.822 ↑ 1.0 235,348 1

Nested Loop Left Join (cost=0.00..362,423.57 rows=235,348 width=699) (actual time=0.022..4,605.822 rows=235,348 loops=1)

  • Join Filter: (attr.format33 @> ARRAY[format33.id])
  • Rows Removed by Join Filter: 22124677
10. 92.675 92.675 ↑ 1.0 235,348 1

Seq Scan on attrib_touchstone attr (cost=0.00..27,049.48 rows=235,348 width=723) (actual time=0.008..92.675 rows=235,348 loops=1)

11. 706.035 706.044 ↑ 1.0 95 235,348

Materialize (cost=0.00..3.43 rows=95 width=13) (actual time=0.000..0.003 rows=95 loops=235,348)

12. 0.009 0.009 ↑ 1.0 95 1

Seq Scan on bo_attribute_value format33 (cost=0.00..2.95 rows=95 width=13) (actual time=0.003..0.009 rows=95 loops=1)

13. 706.037 706.044 ↑ 1.0 95 235,348

Materialize (cost=0.00..3.43 rows=95 width=13) (actual time=0.000..0.003 rows=95 loops=235,348)

14. 0.007 0.007 ↑ 1.0 95 1

Seq Scan on bo_attribute_value freq_units30 (cost=0.00..2.95 rows=95 width=13) (actual time=0.001..0.007 rows=95 loops=1)

15. 706.035 706.044 ↑ 1.0 95 235,348

Materialize (cost=0.00..3.43 rows=95 width=13) (actual time=0.000..0.003 rows=95 loops=235,348)

16. 0.009 0.009 ↑ 1.0 95 1

Seq Scan on bo_attribute_value parameter_type32 (cost=0.00..2.95 rows=95 width=13) (actual time=0.002..0.009 rows=95 loops=1)

17. 52.389 127.215 ↑ 1.0 235,348 1

Hash (cost=20,477.47..20,477.47 rows=235,435 width=70) (actual time=127.215..127.215 rows=235,348 loops=1)

  • Buckets: 65536 Batches: 8 Memory Usage: 3521kB
18. 74.826 74.826 ↑ 1.0 235,348 1

Seq Scan on bo_instance i (cost=0.00..20,477.47 rows=235,435 width=70) (actual time=0.015..74.826 rows=235,348 loops=1)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 7))
  • Rows Removed by Filter: 13010
19. 706.022 706.044 ↑ 1.0 79 235,348

Materialize (cost=0.00..2.19 rows=79 width=100) (actual time=0.000..0.003 rows=79 loops=235,348)

20. 0.022 0.022 ↑ 1.0 79 1

Seq Scan on tag t (cost=0.00..1.79 rows=79 width=100) (actual time=0.006..0.022 rows=79 loops=1)

Planning time : 1.903 ms
Execution time : 24,496.522 ms