Public
Authored by Lukas Juhrich

EXPLAIN ANALYZE

EXPLAIN ANALYZE of

SELECT interface.mac AS username,
 host(switch.management_ip) AS nasipaddress,
 switch_port.name AS nasportid,
 current_property.property_name || '_radius' AS groupname,
 20 AS priority 
FROM interface, "user" JOIN host ON "user".id = host.owner_id
 JOIN room ON room.id = host.room_id
 JOIN patch_port ON patch_port.room_id = room.id AND patch_port.switch_port_id IS NOT NULL
 JOIN switch_port ON switch_port.id = patch_port.switch_port_id
 JOIN switch ON switch.host_id = switch_port.switch_id
 JOIN current_property ON current_property.user_id = "user".id
WHERE "user".id>10000;
9.36 KB
Markdown is supported
0% or
You are about to add 0 people to the discussion. Proceed with caution.
Finish editing this message first!
Please register or to comment