explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oF5R : Optimization for: plan #nFvu

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.047 152.138 ↓ 0.0 0 1

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

2. 0.009 152.091 ↑ 10.0 1 1

Nested Loop Left Join (cost=32.72..33,871.05 rows=10 width=375) (actual time=152.086..152.091 rows=1 loops=1)

3. 0.011 0.987 ↑ 10.0 1 1

Hash Left Join (cost=31.91..85.54 rows=10 width=91) (actual time=0.982..0.987 rows=1 loops=1)

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

Seq Scan on wifiaeroscouttags (cost=0.00..53.58 rows=10 width=11) (actual time=0.970..0.974 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.000 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.001 0.002 ↓ 0.0 0 1

Hash Join (cost=14.37..26.89 rows=8 width=86) (actual time=0.001..0.002 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 151.095 ↓ 0.0 0 1

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

14. 0.001 151.094 ↓ 0.0 0 1

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

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

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

16. 0.002 151.093 ↓ 0.0 0 1

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

  • Join Filter: (wifiaccesspoints.wap_basemac = wifiaeroscouttagspositionhistory.watph_wap_basemac)
17. 151.091 151.091 ↓ 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=151.091..151.091 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..25.11 rows=1,007 width=15) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on wifiaccesspoints (cost=0.00..20.07 rows=1,007 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)