#	exclusive	inclusive	rows x	rows	loops	node
1.	0.336	0.797	↓ 2.0	2	1	→ Nested Loop (cost=0.00..3.17 rows=1 width=8) (actual time=0.316..0.797 rows=2 loops=1)
2.	0.141	0.141	↓ 2.0	2	1	→ Seq Scan on s (cost=0.00..1.07 rows=1 width=4) (actual time=0.072..0.141 rows=2 loops=1) Filter: (id = 7) Rows Removed by Filter: 4
3.	0.320	0.320	↑ 1.0	1	2	→ Seq Scan on s2 (cost=0.00..2.09 rows=1 width=4) (actual time=0.128..0.160 rows=1 loops=2) Filter: (id = 7) Rows Removed by Filter: 86

Total runtime	:	1.115 ms

 Nested Loop  (cost=0.00..3.17 rows=1 width=8) (actual time=0.316..0.797 rows=2 loops=1)
   ->  Seq Scan on s  (cost=0.00..1.07 rows=1 width=4) (actual time=0.072..0.141 rows=2 loops=1)
         Filter: (id = 7)
         Rows Removed by Filter: 4
   ->  Seq Scan on s2  (cost=0.00..2.09 rows=1 width=4) (actual time=0.128..0.160 rows=1 loops=2)
         Filter: (id = 7)
         Rows Removed by Filter: 86
 Total runtime: 1.115 ms

Per node type stats

node type	count	sum of times	% of query
Nested Loop	1	0.336 ms	42.2 %
Seq Scan	2	0.461 ms	57.8 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
s	1	0.141 ms	17.7 %
Seq Scan	1	0.141 ms	100.0 %
s2	1	0.320 ms	40.2 %
Seq Scan	1	0.320 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Z2

Color mode:

Visible columns:

Optimization(s) for this plan:

Per node type stats

Per table stats