explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oKRw : Optimization for: 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; plan #4ZMM

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.108 14.038 ↓ 0.0 0 1

Update on t_e20so1_supportedfile_bigint (cost=0.41..2,106.74 rows=1 width=68) (actual time=14.038..14.038 rows=0 loops=1)

  • Buffers: shared hit=1,165 dirtied=1
2. 0.007 13.930 ↑ 1.0 1 1

Nested Loop (cost=0.41..2,106.74 rows=1 width=68) (actual time=0.713..13.93 rows=1 loops=1)

  • Buffers: shared hit=1,164
3. 13.897 13.897 ↑ 1.0 1 1

Seq Scan on t_e20so1_supportedfile_bigint t_e20so1_supportedfile_bigint (cost=0..2,104.1 rows=1 width=54) (actual time=0.684..13.897 rows=1 loops=1)

  • Filter: ((t_e20so1_supportedfile_bigint.c_supportedfileid = 7,839) AND (t_e20so1_supportedfile_bigint.c_fieldid = 'b84e03b1-7f29-42aa-87fe-8739c1c78732'::uuid))
  • Buffers: shared hit=1,160
4. 0.026 0.026 ↑ 1.0 1 1

Index Scan using t_e20so1_supportedfile_pkey on t_e20so1_supportedfile supportedfile (cost=0.41..2.63 rows=1 width=14) (actual time=0.024..0.026 rows=1 loops=1)

  • Index Cond: (supportedfile.c_supportedfileid = 7,839)
  • Buffers: shared hit=4