explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KUA6

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.387 3.151 ↓ 1.0 755 1

Nested Loop (cost=0.85..1,965.40 rows=754 width=1,628) (actual time=0.050..3.151 rows=755 loops=1)

2. 0.499 0.499 ↓ 1.0 755 1

Index Only Scan using idx_valuationdate_pspportfolioid_pspportfolioid_positionval on "PositionValuation" pos (cost=0.44..396.92 rows=754 width=4) (actual time=0.040..0.499 rows=755 loops=1)

  • Index Cond: (("ValuationDate" = '2018-05-04 00:00:00'::timestamp without time zone) AND ("PSPPortfolioId" = 36))
  • Heap Fetches: 755
3. 2.265 2.265 ↑ 1.0 1 755

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

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