explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nFvu

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.028 158.185 ↓ 0.0 0 1

Insert on view_current_wifi_positioning (cost=32.72..33,870.86 rows=10 width=375) (actual time=158.185..158.185 rows=0 loops=1)

2. 0.011 158.157 ↑ 10.0 1 1

Nested Loop Left Join (cost=32.72..33,870.86 rows=10 width=375) (actual time=158.150..158.157 rows=1 loops=1)

3. 0.007 0.809 ↑ 10.0 1 1

Hash Left Join (cost=31.91..85.50 rows=10 width=91) (actual time=0.803..0.809 rows=1 loops=1)

  • Hash Cond: (wifiaeroscouttags.wat_mac = wifiaeroscouttagsassignmenthistory.watah_mac)
4. 0.800 0.800 ↑ 10.0 1 1

Seq Scan on wifiaeroscouttags (cost=0.00..53.54 rows=10 width=11) (actual time=0.795..0.800 rows=1 loops=1)

  • Filter: ((wat_active IS TRUE) AND (((wat_mac)::character varying(17))::text = '22:22:22:22:22:22'::text))
  • Rows Removed by Filter: 2028
5. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=31.81..31.81 rows=8 width=86) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
6. 0.001 0.002 ↓ 0.0 0 1

Nested Loop (cost=14.65..31.81 rows=8 width=86) (actual time=0.002..0.002 rows=0 loops=1)

7. 0.000 0.001 ↓ 0.0 0 1

Hash Join (cost=14.37..26.89 rows=8 width=86) (actual time=0.001..0.001 rows=0 loops=1)

  • Hash Cond: (nodeslogical.nl_id = wifiaeroscouttagsassignmenthistory.watah_nl_id)
8. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on nodeslogical (cost=0.00..12.00 rows=200 width=72) (actual time=0.001..0.001 rows=0 loops=1)

9. 0.000 0.000 ↓ 0.0 0

Hash (cost=14.27..14.27 rows=8 width=18) (never executed)

10. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on wifiaeroscouttagsassignmenthistory (cost=4.13..14.27 rows=8 width=18) (never executed)

  • Recheck Cond: (watah_end IS NULL)
11. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on watah_unique_active_logical (cost=0.00..4.13 rows=8 width=0) (never executed)

12. 0.000 0.000 ↓ 0.0 0

Index Scan using entities_pkey on entities (cost=0.28..0.61 rows=1 width=8) (never executed)

  • Index Cond: (e_id = nodeslogical.nl_e_id)
13. 0.001 157.337 ↓ 0.0 0 1

Limit (cost=0.81..3,378.50 rows=1 width=189) (actual time=157.337..157.337 rows=0 loops=1)

14. 0.001 157.336 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.81..10,805,232.78 rows=3,199 width=189) (actual time=157.336..157.336 rows=0 loops=1)

  • Join Filter: (nodeslogical_1.nl_id = wifiaccesspointsassignmenthistory.wapah_nl_id)
15. 0.000 157.335 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.81..10,795,629.22 rows=3,199 width=35) (actual time=157.335..157.335 rows=0 loops=1)

16. 0.002 157.335 ↓ 0.0 0 1

Nested Loop (cost=0.68..10,795,129.40 rows=3,199 width=37) (actual time=157.335..157.335 rows=0 loops=1)

  • Join Filter: (wifiaccesspoints.wap_basemac = wifiaeroscouttagspositionhistory.watph_wap_basemac)
17. 157.333 157.333 ↓ 0.0 0 1

Index Only Scan using watph_known_position_index on wifiaeroscouttagspositionhistory (cost=0.68..10,746,880.10 rows=3,199 width=22) (actual time=157.333..157.333 rows=0 loops=1)

  • Index Cond: (watph_wat_mac = wifiaeroscouttags.wat_mac)
  • Heap Fetches: 0
18. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..24.09 rows=1,006 width=15) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on wifiaccesspoints (cost=0.00..19.06 rows=1,006 width=15) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Index Scan using wapah_unique_active_mac on wifiaccesspointsassignmenthistory (cost=0.12..0.16 rows=1 width=10) (never executed)

  • Index Cond: (wapah_basemac = wifiaeroscouttagspositionhistory.watph_wap_basemac)
21. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..13.00 rows=200 width=158) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Seq Scan on nodeslogical nodeslogical_1 (cost=0.00..12.00 rows=200 width=158) (never executed)