explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iYK

Settings
# exclusive inclusive rows x rows loops node
1. 0.188 59,417.842 ↑ 1.0 100 1

Limit (cost=0.00..550.08 rows=100 width=63) (actual time=1,084.912..59,417.842 rows=100 loops=1)

2. 54,577.673 59,417.654 ↑ 283,511.7 100 1

Nested Loop Left Join (cost=0.00..155,954,964.26 rows=28,351,170 width=63) (actual time=1,084.909..59,417.654 rows=100 loops=1)

  • Join Filter: (lower((interface.ifalias)::text) ~~ (('%'::text || lower(replace((wlanaplookup.apname)::text, '.nms.admin.ch'::text, ''::text))) || '%'::text))
  • Rows Removed by Join Filter: 53478769
3. 0.586 0.586 ↑ 105.2 95 1

Seq Scan on wlanaplookup (cost=0.00..391.90 rows=9,990 width=49) (actual time=0.026..0.586 rows=95 loops=1)

4. 4,505.475 4,839.395 ↑ 1.0 562,935 95

Materialize (cost=0.00..24,553.86 rows=567,591 width=14) (actual time=0.001..50.941 rows=562,935 loops=95)

5. 333.920 333.920 ↑ 1.0 567,543 1

Seq Scan on interface (cost=0.00..21,715.91 rows=567,591 width=14) (actual time=0.018..333.920 rows=567,543 loops=1)

Planning time : 1.271 ms
Execution time : 59,439.275 ms