explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2No2 : Optimization for: Optimization for: Test; plan #XPFH; plan #g5bf

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.007 0.116 ↓ 2.0 2 1

Nested Loop (cost=0.41..13.77 rows=1 width=802) (actual time=0.11..0.116 rows=2 loops=1)

  • Buffers: shared hit=11 read=1 dirtied=1
2. 0.061 0.061 ↓ 2.0 2 1

Seq Scan on tempreposupvar_supint_04082020_80939 t_e20so1_supportedfile (cost=0..11.12 rows=1 width=798) (actual time=0.059..0.061 rows=2 loops=1)

  • Filter: (t_e20so1_supportedfile.c_documentid = 54,636)
  • Buffers: shared read=1 dirtied=1
3. 0.048 0.048 ↑ 1.0 1 2

Index Scan using t_e20so1_document_property_c_documentid_idx on t_e20so1_document_property docprop (cost=0.41..2.63 rows=1 width=12) (actual time=0.024..0.024 rows=1 loops=2)

  • Index Cond: (docprop.c_documentid = 54,636)
  • Buffers: shared hit=11
Planning time : 0.775 ms
Execution time : 0.213 ms