explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lVZu : Optimization for: Test; plan #XPFH

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.513 200.727 ↓ 0.0 0 1

Insert on t_e20so1_pages_nvarchar (cost=0.29..3,346.48 rows=1 width=80) (actual time=200.727..200.727 rows=0 loops=1)

  • Buffers: shared hit=18,461 dirtied=6
2. 76.669 200.214 ↓ 10.0 10 1

Nested Loop (cost=0.29..3,346.48 rows=1 width=80) (actual time=24.725..200.214 rows=10 loops=1)

  • Buffers: shared hit=18,422 dirtied=1
3. 0.055 0.285 ↓ 10.0 10 1

Nested Loop (cost=0.29..26.3 rows=1 width=27) (actual time=0.048..0.285 rows=10 loops=1)

  • Buffers: shared hit=31
4. 0.040 0.040 ↑ 1.0 10 1

Seq Scan on temp_opt_07302020124118_72056 a (cost=0..1.1 rows=10 width=34) (actual time=0.015..0.04 rows=10 loops=1)

  • Buffers: shared hit=1
5. 0.190 0.190 ↑ 1.0 1 10

Index Scan using t_e20so1_pages_c_documentid_idx on t_e20so1_pages b (cost=0.29..2.51 rows=1 width=28) (actual time=0.016..0.019 rows=1 loops=10)

  • Index Cond: (b.c_documentid = a.documentid_cp)
  • Filter: ((a.imagelabel_cp)::text = (b.c_pagealias)::text)
  • Buffers: shared hit=30
6. 123.260 123.260 ↑ 1.0 59,316 10

Seq Scan on t_e20so1_pages_nvarchar c (cost=0..2,578.59 rows=59,327 width=8) (actual time=0.004..12.326 rows=59,316 loops=10)

  • Filter: (c.c_fieldid = '89d8c9ba-1ff0-494c-bea6-4aec33eeb062'::uuid)
  • Buffers: shared hit=18,370
Planning time : 1.251 ms
Execution time : 200.881 ms