explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 62Lx : Optimization for: After Pages Nvarchar

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.352 0.433 ↓ 0.0 0 1

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

  • Buffers: shared hit=22 dirtied=2
2. 0.007 0.081 ↑ 1.0 1 1

Nested Loop (cost=0.83..5.28 rows=1 width=92) (actual time=0.071..0.081 rows=1 loops=1)

  • Buffers: shared hit=8
3. 0.028 0.028 ↑ 1.0 1 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.026..0.028 rows=1 loops=1)

  • Index Cond: ((t_e20so1_pages_nvarchar.c_pagesid = 20,936) AND (t_e20so1_pages_nvarchar.c_fieldid = '89d8c9ba-1ff0-494c-bea6-4aec33eeb062'::uuid))
  • Buffers: shared hit=4
4. 0.046 0.046 ↑ 1.0 1 1

Index Scan using t_e20so1_pages_pkey on t_e20so1_pages p (cost=0.41..2.63 rows=1 width=14) (actual time=0.041..0.046 rows=1 loops=1)

  • Index Cond: (p.c_pagesid = 20,936)
  • Buffers: shared hit=4