explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9Fle

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2.272 ↓ 0.0 0 1

Nested Loop (cost=0.73..2,739.35 rows=722 width=1,689) (actual time=2.272..2.272 rows=0 loops=1)

2. 1.720 1.720 ↑ 1.1 683 1

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

  • Index Cond: (("PSPPortfolioId" = 123) AND ("ValuationDate" = '2018-06-11 00:00:00'::timestamp without time zone))
  • Heap Fetches: 683
3. 0.683 0.683 ↓ 0.0 0 683

Index Scan using "Instrument2_pkey" on "Instrument2" ins (cost=0.29..1.98 rows=1 width=1,689) (actual time=0.001..0.001 rows=0 loops=683)

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