explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1hYv : Optimization for: Optimization for: After Pages Nvarchar; plan #62Lx

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.053 0.107 ↓ 0.0 0 1

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

  • Buffers: shared hit=9
2. 0.004 0.054 ↑ 1.0 1 1

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

  • Buffers: shared hit=8
3. 0.034 0.034 ↑ 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.033..0.034 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.016 0.016 ↑ 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.015..0.016 rows=1 loops=1)

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