explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mz0F : Optimization for: Optimization for: Test; plan #XPFH; plan #g5bf

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.010 0.053 ↓ 2.0 2 1

Nested Loop (cost=0.29..13.77 rows=1 width=861) (actual time=0.037..0.053 rows=2 loops=1)

  • Buffers: shared hit=7
2. 0.015 0.015 ↓ 2.0 2 1

Seq Scan on temp_repositorysupported_04082020_80939 t_e20so1_supportedfile (cost=0..11.25 rows=1 width=762) (actual time=0.013..0.015 rows=2 loops=1)

  • Filter: (t_e20so1_supportedfile.c_documentid = 54,636)
  • Buffers: shared hit=1
3. 0.028 0.028 ↑ 1.0 1 2

Index Scan using t_e20so1_supportedfile_nvarchar_c_supportedfileid_idx on t_e20so1_supportedfile_nvarchar t_e20so1_supportedfile_nvarchar (cost=0.29..2.51 rows=1 width=107) (actual time=0.012..0.014 rows=1 loops=2)

  • Index Cond: (t_e20so1_supportedfile.c_supportedfileid = t_e20so1_supportedfile_nvarchar.c_supportedfileid)
  • Filter: (t_e20so1_supportedfile_nvarchar.c_fieldid = '50a3d1b8-b902-4256-8d35-c278ed3306c5'::uuid)
  • Buffers: shared hit=6
Planning time : 0.56 ms
Execution time : 7.754 ms