explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hMjQ : Optimization for: Pages Nvarchar Before

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 18.711 ↓ 0.0 0 1

Update on t_e20so1_pages_nvarchar (cost=0.41..2,750.05 rows=1 width=92) (actual time=18.711..18.711 rows=0 loops=1)

  • Buffers: shared hit=1,855
2. 0.002 18.710 ↓ 0.0 0 1

Nested Loop (cost=0.41..2,750.05 rows=1 width=92) (actual time=18.709..18.71 rows=0 loops=1)

  • Buffers: shared hit=1,855
3. 18.708 18.708 ↓ 0.0 0 1

Seq Scan on t_e20so1_pages_nvarchar t_e20so1_pages_nvarchar (cost=0..2,747.41 rows=1 width=54) (actual time=18.708..18.708 rows=0 loops=1)

  • Filter: ((t_e20so1_pages_nvarchar.c_pagesid = 20,936) AND (t_e20so1_pages_nvarchar.c_fieldid = 'b84e03b1-7f29-42aa-87fe-8739c1c78732'::uuid))
  • Buffers: shared hit=1,855
4. 0.000 0.000 ↓ 0.0 0 0

Index Scan using t_e20so1_pages_pkey on t_e20so1_pages p (cost=0.41..2.63 rows=1 width=14) (never executed)

  • Index Cond: (p.c_pagesid = 20,936)