explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 18Mi

Settings
# exclusive inclusive rows x rows loops node
1. 0.233 1,245.280 ↑ 1.0 1,000 1

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

2. 1,172.087 1,245.047 ↑ 10.0 1,000 1

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

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

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

4. 3.742 46.705 ↑ 1.0 9,990 1

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

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

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

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

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

7. 14.348 30.512 ↑ 1.0 19,066 1

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

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

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

Planning time : 2.033 ms
Execution time : 1,245.575 ms