#	exclusive	inclusive	rows x	rows	loops	node
1.	0.002	0.053	↑ 1.0	1	1	→ Limit (cost=0.42..9.16 rows=1 width=189) (actual time=0.051..0.053 rows=1 loops=1)
2.	0.002	0.051	↑ 19.0	1	1	→ Nested Loop Left Join (cost=0.42..166.55 rows=19 width=189) (actual time=0.051..0.051 rows=1 loops=1) Join Filter: (nodeslogical.nl_id = wifiaccesspointsassignmenthistory.wapah_nl_id) Rows Removed by Join Filter: 4
3.	0.001	0.042	↑ 19.0	1	1	→ Nested Loop Left Join (cost=0.42..97.05 rows=19 width=35) (actual time=0.042..0.042 rows=1 loops=1)
4.	0.003	0.038	↑ 19.0	1	1	→ Nested Loop (cost=0.27..45.39 rows=19 width=37) (actual time=0.038..0.038 rows=1 loops=1) Join Filter: (wifiaccesspoints.wap_basemac = wifiaeroscouttagspositionhistory.watph_wap_basemac) Rows Removed by Join Filter: 4
5.	0.026	0.026	↑ 19.0	1	1	→ Index Only Scan using watph_wat_mac_index on wifiaeroscouttagspositionhistory (cost=0.27..42.74 rows=19 width=22) (actual time=0.026..0.026 rows=1 loops=1) Index Cond: (watph_wat_mac = '00:0c:cc:49:17:64'::macaddr) Heap Fetches: 1
6.	0.003	0.009	↑ 1.2	5	1	→ Materialize (cost=0.00..1.09 rows=6 width=15) (actual time=0.007..0.009 rows=5 loops=1)
7.	0.006	0.006	↑ 1.2	5	1	→ Seq Scan on wifiaccesspoints (cost=0.00..1.06 rows=6 width=15) (actual time=0.004..0.006 rows=5 loops=1)
8.	0.003	0.003	↓ 0.0	0	1	→ Index Scan using wapah_unique_active_mac on wifiaccesspointsassignmenthistory (cost=0.14..2.69 rows=1 width=10) (actual time=0.003..0.003 rows=0 loops=1) Index Cond: (wapah_basemac = wifiaeroscouttagspositionhistory.watph_wap_basemac)
9.	0.002	0.007	↑ 50.0	4	1	→ Materialize (cost=0.00..13.00 rows=200 width=158) (actual time=0.005..0.007 rows=4 loops=1)
10.	0.005	0.005	↑ 50.0	4	1	→ Seq Scan on nodeslogical (cost=0.00..12.00 rows=200 width=158) (actual time=0.004..0.005 rows=4 loops=1)

"Limit  (cost=0.42..9.16 rows=1 width=189) (actual time=0.051..0.053 rows=1 loops=1)"
"  ->  Nested Loop Left Join  (cost=0.42..166.55 rows=19 width=189) (actual time=0.051..0.051 rows=1 loops=1)"
"        Join Filter: (nodeslogical.nl_id = wifiaccesspointsassignmenthistory.wapah_nl_id)"
"        Rows Removed by Join Filter: 4"
"        ->  Nested Loop Left Join  (cost=0.42..97.05 rows=19 width=35) (actual time=0.042..0.042 rows=1 loops=1)"
"              ->  Nested Loop  (cost=0.27..45.39 rows=19 width=37) (actual time=0.038..0.038 rows=1 loops=1)"
"                    Join Filter: (wifiaccesspoints.wap_basemac = wifiaeroscouttagspositionhistory.watph_wap_basemac)"
"                    Rows Removed by Join Filter: 4"
"                    ->  Index Only Scan using watph_wat_mac_index on wifiaeroscouttagspositionhistory  (cost=0.27..42.74 rows=19 width=22) (actual time=0.026..0.026 rows=1 loops=1)"
"                          Index Cond: (watph_wat_mac = '00:0c:cc:49:17:64'::macaddr)"
"                          Heap Fetches: 1"
"                    ->  Materialize  (cost=0.00..1.09 rows=6 width=15) (actual time=0.007..0.009 rows=5 loops=1)"
"                          ->  Seq Scan on wifiaccesspoints  (cost=0.00..1.06 rows=6 width=15) (actual time=0.004..0.006 rows=5 loops=1)"
"              ->  Index Scan using wapah_unique_active_mac on wifiaccesspointsassignmenthistory  (cost=0.14..2.69 rows=1 width=10) (actual time=0.003..0.003 rows=0 loops=1)"
"                    Index Cond: (wapah_basemac = wifiaeroscouttagspositionhistory.watph_wap_basemac)"
"        ->  Materialize  (cost=0.00..13.00 rows=200 width=158) (actual time=0.005..0.007 rows=4 loops=1)"
"              ->  Seq Scan on nodeslogical  (cost=0.00..12.00 rows=200 width=158) (actual time=0.004..0.005 rows=4 loops=1)"
"Planning Time: 0.624 ms"
"Execution Time: 0.087 ms"

Per node type stats

node type	count	sum of times	% of query
Index Only Scan	1	0.026 ms	49.1 %
Index Scan	1	0.003 ms	5.7 %
Limit	1	0.002 ms	3.8 %
Materialize	2	0.005 ms	9.4 %
Nested Loop	1	0.003 ms	5.7 %
Nested Loop Left Join	2	0.003 ms	5.7 %
Seq Scan	2	0.011 ms	20.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
nodeslogical	1	0.005 ms	9.4 %
Seq Scan	1	0.005 ms	100.0 %
wifiaccesspoints	1	0.006 ms	11.3 %
Seq Scan	1	0.006 ms	100.0 %
wifiaccesspointsassignmenthistory	1	0.003 ms	5.7 %
Index Scan	1	0.003 ms	100.0 %
wifiaeroscouttagspositionhistory	1	0.026 ms	49.1 %
Index Only Scan	1	0.026 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PmIZ : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #SD18; plan #wb5W; plan #QfXa; plan #Z4Wx; plan #qSC9; plan #7cNA

Color mode:

Visible columns:

Optimization path:

Per node type stats

Per table stats