explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C1IH

Settings

Optimization(s) for this plan:

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

Limit (cost=84.22..84.22 rows=1 width=185) (actual time=0.124..0.125 rows=1 loops=1)

2. 0.009 0.123 ↑ 1.0 1 1

Sort (cost=84.22..84.22 rows=1 width=185) (actual time=0.123..0.123 rows=1 loops=1)

  • Sort Key: wifiaeroscouttagspositionhistory.watph_from DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 0.000 0.114 ↓ 13.0 13 1

Nested Loop Left Join (cost=48.64..84.21 rows=1 width=185) (actual time=0.069..0.114 rows=13 loops=1)

4. 0.005 0.088 ↓ 13.0 13 1

Nested Loop Left Join (cost=48.49..84.01 rows=1 width=35) (actual time=0.062..0.088 rows=13 loops=1)

5. 0.009 0.057 ↓ 13.0 13 1

Hash Left Join (cost=48.36..83.84 rows=1 width=32) (actual time=0.042..0.057 rows=13 loops=1)

  • Hash Cond: (wifiaeroscouttagspositionhistory.watph_wap_basemac = wifiaccesspointsassignmenthistory.wapah_basemac)
  • Filter: (wifiaccesspointsassignmenthistory.wapah_end IS NULL)
6. 0.014 0.034 ↑ 1.0 13 1

Bitmap Heap Scan on wifiaeroscouttagspositionhistory (cost=4.38..36.58 rows=13 width=22) (actual time=0.024..0.034 rows=13 loops=1)

  • Recheck Cond: (watph_wat_mac = '00:0c:cc:4f:ea:87'::macaddr)
  • Heap Blocks: exact=6
7. 0.020 0.020 ↑ 1.0 13 1

Bitmap Index Scan on watph_wat_mac_index (cost=0.00..4.38 rows=13 width=0) (actual time=0.019..0.020 rows=13 loops=1)

  • Index Cond: (watph_wat_mac = '00:0c:cc:4f:ea:87'::macaddr)
8. 0.009 0.014 ↑ 503.3 3 1

Hash (cost=25.10..25.10 rows=1,510 width=18) (actual time=0.014..0.014 rows=3 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
9. 0.005 0.005 ↑ 503.3 3 1

Seq Scan on wifiaccesspointsassignmenthistory (cost=0.00..25.10 rows=1,510 width=18) (actual time=0.004..0.005 rows=3 loops=1)

10. 0.026 0.026 ↑ 1.0 1 13

Index Scan using wifiaccesspoints_pkey on wifiaccesspoints (cost=0.13..0.16 rows=1 width=15) (actual time=0.002..0.002 rows=1 loops=13)

  • Index Cond: (wap_basemac = wifiaccesspointsassignmenthistory.wapah_basemac)
11. 0.026 0.026 ↑ 1.0 1 13

Index Scan using nodeslogical_pkey on nodeslogical (cost=0.14..0.19 rows=1 width=158) (actual time=0.002..0.002 rows=1 loops=13)

  • Index Cond: (nl_id = wifiaccesspointsassignmenthistory.wapah_nl_id)