explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EnJS

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

Unique (cost=11.42..11.42 rows=1 width=116) (actual time=0.031..0.033 rows=0 loops=1)

2. 0.011 0.032 ↓ 0.0 0 1

Sort (cost=11.42..11.42 rows=1 width=116) (actual time=0.030..0.032 rows=0 loops=1)

  • Sort Key: qmanage_device_macs.fatap_mac, l.session_duration DESC
  • Sort Method: quicksort Memory: 17kB
3. 0.002 0.021 ↓ 0.0 0 1

Nested Loop (cost=2.28..11.41 rows=1 width=116) (actual time=0.019..0.021 rows=0 loops=1)

4. 0.001 0.019 ↓ 0.0 0 1

Nested Loop (cost=0.15..9.18 rows=1 width=110) (actual time=0.018..0.019 rows=0 loops=1)

5. 0.018 0.018 ↓ 0.0 0 1

Seq Scan on qmanage_devices d (cost=0.00..1.00 rows=1 width=72) (actual time=0.018..0.018 rows=0 loops=1)

6. 0.000 0.000 ↓ 0.0 0

Index Scan using "port_current$ip_vlan_port_uid_tagged" on port_current l (cost=0.15..8.17 rows=1 width=70) (never executed)

  • Index Cond: (q_ip = d.ip)
7. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "qmanage_device_macs$pk$fatap_mac" on qmanage_device_macs (cost=2.13..2.18 rows=1 width=6) (never executed)

  • Index Cond: (fatap_mac = l.q_mac)
  • Filter: ((NOT (hashed SubPlan 1)) AND (NOT (hashed SubPlan 2)))
  • Heap Fetches: 0
8.          

SubPlan (for Index Only Scan)

9. 0.000 0.000 ↓ 0.0 0

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

10. 0.000 0.000 ↓ 0.0 0

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

Planning time : 0.773 ms
Execution time : 0.162 ms