explain.depesz.com

PostgreSQL's explain analyze made readable

Result: En8F : Optimization for: plan #VYP

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.003 0.074 ↑ 1.0 1 1

Nested Loop (cost=137.51..153.07 rows=1 width=227) (actual time=0.073..0.074 rows=1 loops=1)

2. 0.005 0.066 ↑ 1.0 1 1

Hash Join (cost=137.37..152.84 rows=1 width=329) (actual time=0.065..0.066 rows=1 loops=1)

  • Hash Cond: (nla.nl_id = wifiactivetagsassignmenthistory.watah_nl_id)
3. 0.009 0.048 ↑ 200.0 1 1

Hash Left Join (cost=129.20..144.14 rows=200 width=321) (actual time=0.047..0.048 rows=1 loops=1)

  • Hash Cond: (COALESCE(nlp.nl_perscr_id, nla.nl_perscr_id) = personnelcrews.perscr_id)
4. 0.007 0.038 ↑ 200.0 1 1

Hash Left Join (cost=90.62..105.04 rows=200 width=293) (actual time=0.037..0.038 rows=1 loops=1)

  • Hash Cond: (COALESCE(nlp.nl_persp_id, nla.nl_persp_id) = personnelpositions.persp_id)
5. 0.003 0.030 ↑ 200.0 1 1

Hash Left Join (cost=52.50..66.39 rows=200 width=265) (actual time=0.029..0.030 rows=1 loops=1)

  • Hash Cond: (COALESCE(nlp.nl_persd_id, nla.nl_persd_id) = personneldepartments.persd_id)
6. 0.003 0.014 ↑ 200.0 1 1

Hash Left Join (cost=51.47..64.83 rows=200 width=268) (actual time=0.014..0.014 rows=1 loops=1)

  • Hash Cond: (COALESCE(nlp.nl_persc_id, nla.nl_persc_id) = personnelcompanies.persc_id)
7. 0.003 0.010 ↑ 200.0 1 1

Hash Left Join (cost=27.30..40.13 rows=200 width=240) (actual time=0.010..0.010 rows=1 loops=1)

  • Hash Cond: (nla.nl_id = tagdeviceshistory.tdh_nl_lamp_id)
8. 0.003 0.003 ↑ 200.0 1 1

Seq Scan on nodeslogical nla (cost=0.00..12.00 rows=200 width=120) (actual time=0.003..0.003 rows=1 loops=1)

9. 0.000 0.004 ↓ 0.0 0 1

Hash (cost=27.20..27.20 rows=8 width=124) (actual time=0.004..0.004 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
10. 0.002 0.004 ↓ 0.0 0 1

Hash Right Join (cost=14.37..27.20 rows=8 width=124) (actual time=0.004..0.004 rows=0 loops=1)

  • Hash Cond: (nlp.nl_id = tagdeviceshistory.tdh_nl_personnel_id)
11. 0.000 0.000 ↓ 0.0 0

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

12. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=14.27..14.27 rows=8 width=12) (actual time=0.002..0.002 rows=0 loops=1)

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

Bitmap Heap Scan on tagdeviceshistory (cost=4.13..14.27 rows=8 width=12) (actual time=0.002..0.002 rows=0 loops=1)

  • Recheck Cond: (tdh_date_end IS NULL)
14. 0.001 0.001 ↓ 0.0 0 1

Bitmap Index Scan on tdh_index_active (cost=0.00..4.13 rows=8 width=0) (actual time=0.001..0.001 rows=0 loops=1)

15. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=16.30..16.30 rows=630 width=36) (actual time=0.001..0.001 rows=0 loops=1)

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

Seq Scan on personnelcompanies (cost=0.00..16.30 rows=630 width=36) (actual time=0.001..0.001 rows=0 loops=1)

17. 0.003 0.013 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=5) (actual time=0.013..0.013 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
18. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on personneldepartments (cost=0.00..1.01 rows=1 width=5) (actual time=0.010..0.010 rows=1 loops=1)

19. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=22.50..22.50 rows=1,250 width=36) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
20. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on personnelpositions (cost=0.00..22.50 rows=1,250 width=36) (actual time=0.001..0.001 rows=0 loops=1)

21. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=22.70..22.70 rows=1,270 width=36) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
22. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on personnelcrews (cost=0.00..22.70 rows=1,270 width=36) (actual time=0.001..0.001 rows=0 loops=1)

23. 0.002 0.013 ↑ 1.0 1 1

Hash (cost=8.16..8.16 rows=1 width=12) (actual time=0.013..0.013 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 0.011 0.011 ↑ 1.0 1 1

Index Scan using watah_unique_active_mac on wifiactivetagsassignmenthistory (cost=0.14..8.16 rows=1 width=12) (actual time=0.010..0.011 rows=1 loops=1)

  • Index Cond: (watah_mac = '00:0c:cc:12:ee:9a'::macaddr)
25. 0.005 0.005 ↑ 1.0 1 1

Index Scan using entities_pkey on entities (cost=0.14..0.21 rows=1 width=10) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (e_id = nla.nl_e_id)