explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VYP

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 0.044 ↑ 1.0 1 1

Nested Loop (cost=28.16..42.50 rows=1 width=227) (actual time=0.042..0.044 rows=1 loops=1)

2. 0.001 0.034 ↑ 1.0 1 1

Nested Loop (cost=28.02..42.26 rows=1 width=329) (actual time=0.033..0.034 rows=1 loops=1)

3. 0.001 0.027 ↑ 1.0 1 1

Nested Loop Left Join (cost=27.88..41.60 rows=1 width=321) (actual time=0.026..0.027 rows=1 loops=1)

4. 0.001 0.026 ↑ 1.0 1 1

Nested Loop Left Join (cost=27.73..41.21 rows=1 width=293) (actual time=0.025..0.026 rows=1 loops=1)

5. 0.001 0.024 ↑ 1.0 1 1

Nested Loop Left Join (cost=27.57..40.82 rows=1 width=265) (actual time=0.023..0.024 rows=1 loops=1)

6. 0.002 0.023 ↑ 1.0 1 1

Nested Loop Left Join (cost=27.45..40.54 rows=1 width=268) (actual time=0.022..0.023 rows=1 loops=1)

7. 0.008 0.019 ↑ 1.0 1 1

Hash Left Join (cost=27.30..40.15 rows=1 width=240) (actual time=0.018..0.019 rows=1 loops=1)

  • Hash Cond: (nla.nl_id = tagdeviceshistory.tdh_nl_lamp_id)
  • Filter: (COALESCE(nlp.nl_isactive, nla.nl_isactive) = 1)
8. 0.005 0.005 ↑ 200.0 1 1

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

9. 0.000 0.006 ↓ 0.0 0 1

Hash (cost=27.20..27.20 rows=8 width=128) (actual time=0.006..0.006 rows=0 loops=1)

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

Hash Right Join (cost=14.37..27.20 rows=8 width=128) (actual time=0.006..0.006 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=120) (never executed)

12. 0.000 0.004 ↓ 0.0 0 1

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

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

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

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

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

15. 0.002 0.002 ↓ 0.0 0 1

Index Scan using personnelcompanies_pkey on personnelcompanies (cost=0.15..0.39 rows=1 width=36) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (persc_id = COALESCE(nlp.nl_persc_id, nla.nl_persc_id))
16. 0.000 0.000 ↓ 0.0 0 1

Index Scan using personneldepartments_pkey on personneldepartments (cost=0.12..0.20 rows=1 width=5) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (persd_id = COALESCE(nlp.nl_persd_id, nla.nl_persd_id))
17. 0.001 0.001 ↓ 0.0 0 1

Index Scan using personnelpositions_pkey on personnelpositions (cost=0.15..0.39 rows=1 width=36) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (persp_id = COALESCE(nlp.nl_persp_id, nla.nl_persp_id))
18. 0.000 0.000 ↓ 0.0 0 1

Index Scan using personnelcrews_pkey on personnelcrews (cost=0.15..0.39 rows=1 width=36) (actual time=0.000..0.000 rows=0 loops=1)

  • Index Cond: (perscr_id = COALESCE(nlp.nl_perscr_id, nla.nl_perscr_id))
19. 0.006 0.006 ↑ 1.0 1 1

Index Scan using watah_unique_active_logical on wifiactivetagsassignmenthistory (cost=0.14..0.41 rows=1 width=12) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (watah_nl_id = nla.nl_id)
  • Filter: (watah_mac = '00:0c:cc:12:ee:9a'::macaddr)
20. 0.008 0.008 ↑ 1.0 1 1

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

  • Index Cond: (e_id = nla.nl_e_id)