explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cWd4

Settings
# exclusive inclusive rows x rows loops node
1. 0.216 6,908.671 ↑ 1.0 1,000 1

Limit (cost=2,545.95..6,018.50 rows=1,000 width=63) (actual time=77.100..6,908.671 rows=1,000 loops=1)

2. 6,838.434 6,908.455 ↑ 10.0 1,000 1

Hash Right Join (cost=2,545.95..37,236.73 rows=9,990 width=63) (actual time=77.097..6,908.455 rows=1,000 loops=1)

  • Hash Cond: (interface.elementid = element.elementid)
  • Join Filter: ((interface.ifalias)::text ~* "substring"((wlanaplookup.apname)::text, '(.*).nms.admin.ch'::text))
  • Rows Removed by Join Filter: 169831
3. 24.586 24.586 ↑ 7.3 78,109 1

Seq Scan on interface (cost=0.00..21,715.91 rows=567,591 width=18) (actual time=0.012..24.586 rows=78,109 loops=1)

4. 3.848 45.435 ↑ 1.0 9,990 1

Hash (cost=2,421.08..2,421.08 rows=9,990 width=53) (actual time=45.435..45.435 rows=9,990 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 838kB
5. 8.953 41.587 ↑ 1.0 9,990 1

Hash Left Join (cost=1,796.99..2,421.08 rows=9,990 width=53) (actual time=30.241..41.587 rows=9,990 loops=1)

  • Hash Cond: ((wlanaplookup.wlc)::text = (element.name)::text)
6. 2.440 2.440 ↑ 1.0 9,990 1

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

7. 13.988 30.194 ↑ 1.0 19,066 1

Hash (cost=1,558.66..1,558.66 rows=19,066 width=30) (actual time=30.194..30.194 rows=19,066 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 1191kB
8. 16.206 16.206 ↑ 1.0 19,066 1

Seq Scan on element (cost=0.00..1,558.66 rows=19,066 width=30) (actual time=0.011..16.206 rows=19,066 loops=1)

Planning time : 2.038 ms
Execution time : 6,908.974 ms