explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WEsp

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 2.120 ↑ 1.3 9 1

Nested Loop Left Join (cost=80.77..120.82 rows=12 width=62) (actual time=2.007..2.120 rows=9 loops=1)

  • Join Filter: (((nwvlan.owningentityid)::text = portinfo.owningentityid) AND (nwvlan.vlanid = portinfo.accessvlan))
  • Rows Removed by Join Filter: 16
2.          

CTE vlanportinfo

3. 1.388 1.833 ↓ 1.1 70 1

HashAggregate (cost=79.66..80.48 rows=66 width=68) (actual time=1.782..1.833 rows=70 loops=1)

  • Group Key: device.accessvlan
4. 0.445 0.445 ↓ 1.3 1,707 1

Seq Scan on vlanswitchportsettings device (cost=0.00..69.52 rows=1,352 width=38) (actual time=0.016..0.445 rows=1,707 loops=1)

5. 0.078 0.078 ↑ 1.3 9 1

Index Scan using networkvlan_bk on networkvlan nwvlan (cost=0.28..38.56 rows=12 width=30) (actual time=0.073..0.078 rows=9 loops=1)

  • Index Cond: ((owningentityid)::text = '135156_135156'::text)
6. 2.025 2.025 ↓ 2.0 2 9

CTE Scan on vlanportinfo portinfo (cost=0.00..1.48 rows=1 width=68) (actual time=0.221..0.225 rows=2 loops=9)

  • Filter: (owningentityid = '135156_135156'::text)
  • Rows Removed by Filter: 68
Planning time : 1.681 ms
Execution time : 2.614 ms