explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NGLM

Settings
# exclusive inclusive rows x rows loops node
1. 0.133 43,249.446 ↑ 1.0 150 1

Limit (cost=745,167.78..745,178.65 rows=150 width=204) (actual time=43,249.072..43,249.446 rows=150 loops=1)

2. 1,762.647 43,249.313 ↑ 1,235.0 150 1

WindowAgg (cost=745,167.78..758,598.84 rows=185,256 width=204) (actual time=43,249.070..43,249.313 rows=150 loops=1)

3. 3,441.250 41,486.666 ↓ 1.0 187,600 1

GroupAggregate (cost=745,167.78..754,430.58 rows=185,256 width=1,020) (actual time=37,849.419..41,486.666 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. 896.356 38,045.416 ↓ 1.0 187,735 1

Sort (cost=745,167.78..745,630.92 rows=185,256 width=1,009) (actual time=37,849.359..38,045.416 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: 176144kB
5. 15,588.175 37,149.060 ↓ 1.0 187,735 1

Nested Loop Left Join (cost=51,325.65..564,325.66 rows=185,256 width=1,009) (actual time=8,574.301..37,149.060 rows=187,735 loops=1)

  • Join Filter: (i.tags @> ARRAY[t.id])
  • Rows Removed by Join Filter: 26076234
6. 625.726 11,430.485 ↓ 1.0 187,600 1

Hash Right Join (cost=51,325.65..197,515.13 rows=185,256 width=937) (actual time=8,573.978..11,430.485 rows=187,600 loops=1)

  • Hash Cond: (attr.bo_instance_id = i.id)
7. 6,237.601 6,237.601 ↓ 1.0 188,138 1

Seq Scan on attrib_touchstone attr (cost=0.00..100,594.90 rows=187,690 width=863) (actual time=3,478.786..6,237.601 rows=188,138 loops=1)

8. 134.417 4,567.158 ↓ 1.0 187,600 1

Hash (cost=46,476.95..46,476.95 rows=185,256 width=82) (actual time=4,567.158..4,567.158 rows=187,600 loops=1)

  • Buckets: 32768 Batches: 8 Memory Usage: 3050kB
9. 4,432.741 4,432.741 ↓ 1.0 187,600 1

Seq Scan on bo_instance i (cost=0.00..46,476.95 rows=185,256 width=82) (actual time=2.569..4,432.741 rows=187,600 loops=1)

  • Filter: ((NOT is_deleted) AND (bo_class_id = 103))
  • Rows Removed by Filter: 51873
10. 10,130.287 10,130.400 ↓ 1.1 139 187,600

Materialize (cost=0.00..3.98 rows=132 width=93) (actual time=0.000..0.054 rows=139 loops=187,600)

11. 0.113 0.113 ↓ 1.1 139 1

Seq Scan on tag t (cost=0.00..3.32 rows=132 width=93) (actual time=0.018..0.113 rows=139 loops=1)

Planning time : 0.538 ms
Execution time : 43,606.558 ms