explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.530 9.889 ↓ 1.0 752 1

Nested Loop (cost=0.85..1,896.91 rows=725 width=1,628) (actual time=0.727..9.889 rows=752 loops=1)

2. 7.103 7.103 ↓ 1.0 752 1

Index Only Scan using idx_valuationdate_pspportfolioid_pspportfolioid_positionval on "PositionValuation" pos (cost=0.44..381.82 rows=725 width=4) (actual time=0.614..7.103 rows=752 loops=1)

  • Index Cond: (("ValuationDate" = '2018-05-11 00:00:00'::timestamp without time zone) AND ("PSPPortfolioId" = 242))
  • Heap Fetches: 752
3. 2.256 2.256 ↑ 1.0 1 752

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=752)

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