explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Z2

Settings

Optimization(s) for this plan:

# 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