explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4ZMM : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Test; plan #XPFH; plan #9uzE; plan #MjvN; plan #zFNm; plan #u2t2; plan #8OKW; plan #3PDF

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Update on t_e20so1_supportedfile_int (cost=0.83..5.28 rows=1 width=64) (never executed)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..5.28 rows=1 width=64) (never executed)

3. 0.000 0.000 ↓ 0.0

Index Scan using "UQ_be14811a-ea28-4fc9-9947-96c174aaefc2" on t_e20so1_supportedfile_int t_e20so1_supportedfile_int (cost=0.41..2.63 rows=1 width=54) (never executed)

  • Index Cond: ((t_e20so1_supportedfile_int.c_supportedfileid = 7,839) AND (t_e20so1_supportedfile_int.c_fieldid = '00591c85-92d9-4d98-ac84-240178380526'::uuid))
4. 0.000 0.000 ↓ 0.0

Index Scan using t_e20so1_supportedfile_pkey on t_e20so1_supportedfile supportedfile (cost=0.41..2.63 rows=1 width=14) (never executed)

  • Index Cond: (supportedfile.c_supportedfileid = 7,839)