explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NXAj : test

Settings

Optimization(s) for this plan:

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

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

  • Output: t.s, t.md5, c.catname
  • Inner Unique: true
  • Buffers: shared hit=5
2. 0.017 0.017 ↑ 1.0 1 1

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

  • Output: t.s, t.md5, t.catid
  • Index Cond: (t.s = 350)
  • Buffers: shared hit=3
3. 0.004 0.004 ↑ 1.0 1 1

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

  • Output: c.catid, c.catname
  • Index Cond: (c.catid = t.catid)
  • Buffers: shared hit=2
Planning time : 0.150 ms
Execution time : 0.049 ms