explain.depesz.com

PostgreSQL's explain analyze made readable

Result: scfR : Optimization for: test; plan #NXAj

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.004 0.034 ↑ 1.0 1 1

Nested Loop (cost=0.44..16.49 rows=1 width=69) (actual time=0.033..0.034 rows=1 loops=1)

  • Buffers: shared hit=5
2. 0.017 0.017 ↑ 1.0 1 1

Index Scan using pk_t_random on t_random t (cost=0.29..8.3 rows=1 width=41) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (t.s = 350)
  • Buffers: shared hit=3
3. 0.013 0.013 ↑ 1.0 1 1

Index Scan using t_category_pkey on t_category c (cost=0.15..8.17 rows=1 width=36) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (c.catid = t.catid)
  • Buffers: shared hit=2
Planning time : 0.561 ms
Execution time : 0.098 ms