explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NyNj

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 0.128 ↑ 1.0 1 1

Nested Loop (cost=0.00..6.69 rows=1 width=109) (actual time=0.097..0.128 rows=1 loops=1)

2. 0.056 0.056 ↑ 1.0 1 1

Seq Scan on smw_fpt_lcode a (cost=0.00..2.34 rows=1 width=3) (actual time=0.052..0.056 rows=1 loops=1)

  • Filter: (s_id = 4283)
  • Rows Removed by Filter: 118
3. 0.055 0.055 ↑ 1.0 1 1

Seq Scan on smw_fpt_text b (cost=0.00..4.34 rows=1 width=106) (actual time=0.029..0.055 rows=1 loops=1)

  • Filter: (s_id = 4283)
  • Rows Removed by Filter: 118