explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.004 67.029 ↓ 0.0 0 1

Insert on t_e20so1_pages_nvarchar (cost=3,320.44..5,036.98 rows=1 width=80) (actual time=67.028..67.029 rows=0 loops=1)

  • Buffers: shared hit=3,034
2. 0.070 67.025 ↓ 0.0 0 1

Nested Loop (cost=3,320.44..5,036.98 rows=1 width=80) (actual time=67.025..67.025 rows=0 loops=1)

  • Buffers: shared hit=3,034
3. 16.824 66.809 ↓ 146.0 146 1

Hash Join (cost=3,320.15..5,036.53 rows=1 width=28) (actual time=44.458..66.809 rows=146 loops=1)

  • Buffers: shared hit=2,742
4. 6.322 6.322 ↑ 1.0 59,228 1

Seq Scan on t_e20so1_pages b (cost=0..1,494.28 rows=59,228 width=28) (actual time=0.025..6.322 rows=59,228 loops=1)

  • Buffers: shared hit=902
5. 17.132 43.663 ↑ 1.0 59,326 1

Hash (cost=2,578.57..2,578.57 rows=59,326 width=8) (actual time=43.662..43.663 rows=59,326 loops=1)

  • Buffers: shared hit=1,837
6. 26.531 26.531 ↑ 1.0 59,326 1

Seq Scan on t_e20so1_pages_nvarchar c (cost=0..2,578.57 rows=59,326 width=8) (actual time=0.016..26.531 rows=59,326 loops=1)

  • Filter: (c.c_fieldid = '89d8c9ba-1ff0-494c-bea6-4aec33eeb062'::uuid)
  • Buffers: shared hit=1,837
7. 0.146 0.146 ↓ 0.0 0 146

Index Scan using "temp_opt_07312020100727_720564659278d-175e-4296-91fb-6b2f2cde49" on temp_opt_07312020100727_72056 a (cost=0.29..0.43 rows=1 width=60) (actual time=0.001..0.001 rows=0 loops=146)

  • Index Cond: (a.documentid_cp = b.c_documentid)
  • Filter: ((b.c_pagealias)::text = (a.imagelabel_cp)::text)
  • Buffers: shared hit=292
Planning time : 3.178 ms
Execution time : 67.396 ms