explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2IyJ : After Optimization Plan

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.027 0.168 ↓ 0.0 0 1

Update on t_e20so1_supportedfile_bigint (cost=0.83..5.28 rows=1 width=68) (actual time=0.168..0.168 rows=0 loops=1)

  • Buffers: shared hit=6 read=3
2. 0.004 0.141 ↑ 1.0 1 1

Nested Loop (cost=0.83..5.28 rows=1 width=68) (actual time=0.139..0.141 rows=1 loops=1)

  • Buffers: shared hit=5 read=3
3. 0.116 0.116 ↑ 1.0 1 1

Index Scan using t_e20so1_supportedfile_bigint_c_supportedfileid_c_fieldid_uidx on t_e20so1_supportedfile_bigint t_e20so1_supportedfile_bigint (cost=0.41..2.63 rows=1 width=54) (actual time=0.115..0.116 rows=1 loops=1)

  • Index Cond: ((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 read=3
4. 0.021 0.021 ↑ 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.02..0.021 rows=1 loops=1)

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