explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ILLV

Settings
# exclusive inclusive rows x rows loops node
1. 2,063.208 4,103.079 ↓ 1.1 3,692,928 1

Nested Loop (cost=68,387.09..2,942,888.17 rows=3,435,725 width=1,872) (actual time=420.866..4,103.079 rows=3,692,928 loops=1)

  • Buffers: shared hit=2 read=257040
2. 0.035 0.035 ↑ 1.0 1 1

Index Only Scan using portfolios_pkey on portfolios p (cost=0.28..8.29 rows=1 width=4) (actual time=0.033..0.035 rows=1 loops=1)

  • Index Cond: (p.id = 502)
  • Buffers: shared hit=2 read=1
3. 1,626.893 2,039.836 ↓ 1.1 3,692,928 1

Bitmap Heap Scan on instrument_performances ip (cost=68,386.81..2,908,522.62 rows=3,435,725 width=1,872) (actual time=420.825..2,039.836 rows=3,692,928 loops=1)

  • Filter: ((ip.date_from >= '2008-11-11'::date) AND (ip.date_to <= '2019-03-31'::date) AND (ip.currency_id = 161))
  • Buffers: shared read=257039
4. 412.943 412.943 ↓ 1.0 3,692,928 1

Bitmap Index Scan on index_instrument_performances_on_portfolio_id (cost=0..67,527.88 rows=3,656,442 width=0) (actual time=412.943..412.943 rows=3,692,928 loops=1)

  • Index Cond: (ip.portfolio_id = 502)
  • Buffers: shared read=10094