explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZuVY

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 9,651.748 ↑ 1.0 150 1

Limit (cost=556,961.28..556,972.16 rows=150 width=196) (actual time=9,651.693..9,651.748 rows=150 loops=1)

2. 603.447 9,651.737 ↑ 1,568.3 150 1

WindowAgg (cost=556,961.28..574,016.25 rows=235,241 width=196) (actual time=9,651.692..9,651.737 rows=150 loops=1)

3. 4,638.094 9,048.290 ↓ 1.0 235,348 1

GroupAggregate (cost=556,961.28..568,723.33 rows=235,241 width=781) (actual time=4,325.244..9,048.290 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. 398.114 4,410.196 ↓ 1.0 235,351 1

Sort (cost=556,961.28..557,549.38 rows=235,241 width=777) (actual time=4,325.222..4,410.196 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: 165312kB
5. 2,850.295 4,012.082 ↓ 1.0 235,351 1

Nested Loop Left Join (cost=26,181.25..373,552.34 rows=235,241 width=777) (actual time=117.067..4,012.082 rows=235,351 loops=1)

  • Join Filter: (i.tags @> ARRAY[t.id])
  • Rows Removed by Join Filter: 18592488
6. 251.602 455.743 ↓ 1.0 235,348 1

Hash Right Join (cost=26,181.25..94,789.76 rows=235,241 width=698) (actual time=116.991..455.743 rows=235,348 loops=1)

  • Hash Cond: (attr.bo_instance_id = i.id)
7. 87.270 87.270 ↑ 1.0 235,348 1

Seq Scan on attrib_touchstone attr (cost=0.00..27,051.25 rows=235,525 width=636) (actual time=0.021..87.270 rows=235,348 loops=1)

8. 47.510 116.871 ↓ 1.0 235,348 1

Hash (cost=20,483.74..20,483.74 rows=235,241 width=70) (actual time=116.871..116.871 rows=235,348 loops=1)

  • Buckets: 65536 Batches: 8 Memory Usage: 3521kB
9. 69.361 69.361 ↓ 1.0 235,348 1

Seq Scan on bo_instance i (cost=0.00..20,483.74 rows=235,241 width=70) (actual time=0.017..69.361 rows=235,348 loops=1)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 7))
  • Rows Removed by Filter: 13010
10. 706.001 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)

11. 0.043 0.043 ↑ 1.0 79 1

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

Planning time : 1.066 ms
Execution time : 9,733.502 ms