explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 87ra : Optimization for: After Pages Nvarchar

Settings

Optimization path:

Optimization(s) for this plan:

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

Update on t_e20so1_pages_nvarchar (cost=0.83..5.27 rows=1 width=92) (actual time=0.017..0.017 rows=0 loops=1)

  • Buffers: shared hit=3
2. 0.000 0.016 ↓ 0.0 0 1

Nested Loop (cost=0.83..5.27 rows=1 width=92) (actual time=0.016..0.016 rows=0 loops=1)

  • Buffers: shared hit=3
3. 0.016 0.016 ↓ 0.0 0 1

Index Scan using t_e20so1_pages_nvarchar_c_pagesid_c_fieldid_uidx on t_e20so1_pages_nvarchar t_e20so1_pages_nvarchar (cost=0.41..2.63 rows=1 width=54) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: ((t_e20so1_pages_nvarchar.c_pagesid = 20,936) AND (t_e20so1_pages_nvarchar.c_fieldid = 'b84e03b1-7f29-42aa-87fe-8739c1c78732'::uuid))
  • Buffers: shared hit=3
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)