explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 136.690 317.765 ↓ 0.0 0 1

Insert on t_e20so1_pages_nvarchar (cost=5,096.7..12,129.09 rows=6 width=80) (actual time=317.765..317.765 rows=0 loops=1)

  • Buffers: shared hit=237,898 read=155 dirtied=155
2. 68.709 181.075 ↓ 9,354.3 56,126 1

Hash Join (cost=5,096.7..12,129.09 rows=6 width=80) (actual time=53.449..181.075 rows=56,126 loops=1)

  • Buffers: shared hit=65,725 read=1 dirtied=1
3. 30.436 107.946 ↓ 9,354.3 56,126 1

Hash Join (cost=3,179.7..10,211.97 rows=6 width=48) (actual time=48.786..107.946 rows=56,126 loops=1)

  • Buffers: shared hit=7,752
4. 34.238 34.238 ↑ 1.0 56,126 1

Seq Scan on temp_opt_07312020100727_72056 a (cost=0..6,611.26 rows=56,126 width=60) (actual time=5.392..34.238 rows=56,126 loops=1)

  • Buffers: shared hit=6,050
5. 19.968 43.272 ↑ 1.0 59,228 1

Hash (cost=2,291.28..2,291.28 rows=59,228 width=28) (actual time=43.271..43.272 rows=59,228 loops=1)

  • Buffers: shared hit=1,699
6. 23.304 23.304 ↑ 1.0 59,228 1

Seq Scan on t_e20so1_pages b (cost=0..2,291.28 rows=59,228 width=28) (actual time=0.015..23.304 rows=59,228 loops=1)

  • Buffers: shared hit=1,699
7. 0.497 4.420 ↑ 1.0 3,200 1

Hash (cost=1,877..1,877 rows=3,200 width=8) (actual time=4.42..4.42 rows=3,200 loops=1)

  • Buffers: shared hit=1,837
8. 3.923 3.923 ↑ 1.0 3,200 1

Seq Scan on t_e20so1_pages_nvarchar c (cost=0..1,877 rows=3,200 width=8) (actual time=0.014..3.923 rows=3,200 loops=1)

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