explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9qHE8 : Optimization for: Pages Nvarchar Before

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 2.469 22.371 ↓ 0.0 0 1

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

  • Buffers: shared hit=1,871 read=1 dirtied=3
2. 0.008 19.902 ↑ 1.0 1 1

Nested Loop (cost=0.41..2,750.05 rows=1 width=92) (actual time=1.198..19.902 rows=1 loops=1)

  • Buffers: shared hit=1,862
3. 19.816 19.816 ↑ 1.0 1 1

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

  • Filter: ((t_e20so1_pages_nvarchar.c_pagesid = 20,936) AND (t_e20so1_pages_nvarchar.c_fieldid = '89d8c9ba-1ff0-494c-bea6-4aec33eeb062'::uuid))
  • Buffers: shared hit=1,855
4. 0.078 0.078 ↑ 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.074..0.078 rows=1 loops=1)

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