explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0XZ : Optimization for: Optimization for: Optimization for: plan #KUA6; plan #knG5; plan #IUjI

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 4.248 ↓ 1.2 867 1

Nested Loop (cost=0.85..2,820.41 rows=722 width=1,628) (actual time=0.262..4.248 rows=867 loops=1)

2. 1.887 1.887 ↓ 1.2 867 1

Index Only Scan using "PositionValuation2_pkey" on "PositionValuation2" pos (cost=0.44..1,309.93 rows=722 width=4) (actual time=0.252..1.887 rows=867 loops=1)

  • Index Cond: (("PSPPortfolioId" = 218) AND ("ValuationDate" = '2018-06-11 00:00:00'::timestamp without time zone))
  • Heap Fetches: 867
3. 2.601 2.601 ↑ 1.0 1 867

Index Scan using "Instrument_pkey" on "Instrument" ins (cost=0.42..2.09 rows=1 width=1,628) (actual time=0.003..0.003 rows=1 loops=867)

  • Index Cond: (id = pos."PSPInstrumentId")