explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SNTV

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=2.15..18.38 rows=1 width=78) (actual time=0.011..0.013 rows=0 loops=1)

  • Join Filter: (port_current.q_ip = d.ip)
2. 0.001 0.012 ↓ 0.0 0 1

Nested Loop (cost=2.15..17.37 rows=1 width=38) (actual time=0.011..0.012 rows=0 loops=1)

3. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on qmanage_device_macs (cost=2.00..3.00 rows=1 width=6) (actual time=0.011..0.011 rows=0 loops=1)

  • Filter: ((NOT (hashed SubPlan 1)) AND (NOT (hashed SubPlan 2)))
4.          

SubPlan (for Seq Scan)

5. 0.000 0.000 ↓ 0.0 0

Seq Scan on qmanage_registrations (cost=0.00..1.00 rows=1 width=6) (never executed)

6. 0.000 0.000 ↓ 0.0 0

Seq Scan on other_hard_ware (cost=0.00..1.00 rows=1 width=6) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Limit (cost=0.15..14.34 rows=1 width=32) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Index Scan using "port_current$ip_vlan_port_uid_tagged" on port_current (cost=0.15..14.34 rows=1 width=32) (never executed)

  • Index Cond: (q_mac = qmanage_device_macs.fatap_mac)
  • Filter: (COALESCE(upper(session_duration), 'infinity'::timestamp with time zone) > now())
9. 0.000 0.000 ↓ 0.0 0

Seq Scan on qmanage_devices d (cost=0.00..1.00 rows=1 width=72) (never executed)

Planning time : 0.444 ms
Execution time : 0.084 ms