explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.013 0.108 ↓ 2.0 2 1

Nested Loop (cost=0.41..13.76 rows=1 width=798) (actual time=0.076..0.108 rows=2 loops=1)

  • Buffers: shared hit=9
2. 0.017 0.017 ↓ 2.0 2 1

Seq Scan on tempreposup_supnvar_04082020_80939 t_e20so1_supportedfile (cost=0..11.12 rows=1 width=794) (actual time=0.014..0.017 rows=2 loops=1)

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

Index Scan using "UQ_be14811a-ea28-4fc9-9947-96c174aaefc2" on t_e20so1_supportedfile_int supportedfileint (cost=0.41..2.63 rows=1 width=12) (actual time=0.039..0.039 rows=1 loops=2)

  • Index Cond: ((t_e20so1_supportedfile.c_supportedfileid = supportedfileint.c_supportedfileid) AND (supportedfileint.c_fieldid = '00591c85-92d9-4d98-ac84-240178380526'::uuid))
  • Buffers: shared hit=8
Planning time : 0.445 ms
Execution time : 6.523 ms