explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8xPZ : Optimization for: Test; plan #XPFH

Settings

Optimization path:

Optimization(s) for this plan:

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

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

  • Buffers: shared hit=13,078
2. 58.332 142.450 ↓ 0.0 0 1

Nested Loop (cost=0.29..3,346.48 rows=1 width=80) (actual time=142.45..142.45 rows=0 loops=1)

  • Buffers: shared hit=13,078
3. 0.058 0.278 ↓ 10.0 10 1

Nested Loop (cost=0.29..26.3 rows=1 width=27) (actual time=0.044..0.278 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.019..0.04 rows=10 loops=1)

  • Buffers: shared hit=1
5. 0.180 0.180 ↑ 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.015..0.018 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. 83.840 83.840 ↑ 1.4 42,260 10

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

  • Filter: (c.c_fieldid = '89d8c9ba-1ff0-494c-bea6-4aec33eeb062'::uuid)
  • Buffers: shared hit=13,047
Planning time : 1.072 ms
Execution time : 142.772 ms