explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V1Ae

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.007 0.701 ↑ 41.0 1 1

Unique (cost=224.58..224.88 rows=41 width=13) (actual time=0.694..0.701 rows=1 loops=1)

  • Output: eo.market_id, (((eo.odds_version)::numeric = (unnest('{1.75}'::numeric[])))), eo.outcome_no, eo.odds_version
  • Buffers: shared hit=19
2. 0.087 0.694 ↑ 3.4 12 1

Sort (cost=224.58..224.68 rows=41 width=13) (actual time=0.693..0.694 rows=12 loops=1)

  • Output: eo.market_id, (((eo.odds_version)::numeric = (unnest('{1.75}'::numeric[])))), eo.outcome_no, eo.odds_version
  • Sort Key: eo.market_id, eo.outcome_no, eo.odds_version DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=19
3. 0.036 0.607 ↑ 3.4 12 1

Nested Loop (cost=0.43..223.48 rows=41 width=13) (actual time=0.229..0.607 rows=12 loops=1)

  • Output: eo.market_id, ((eo.odds_version)::numeric = (unnest('{1.75}'::numeric[]))), eo.outcome_no, eo.odds_version
  • Buffers: shared hit=16
4. 0.010 0.012 ↑ 100.0 1 1

ProjectSet (cost=0.00..0.52 rows=100 width=40) (actual time=0.009..0.012 rows=1 loops=1)

  • Output: unnest('{128618}'::integer[]), unnest('{1}'::integer[]), unnest('{1.75}'::numeric[])
5. 0.002 0.002 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.001..0.002 rows=1 loops=1)

6. 0.559 0.559 ↓ 12.0 12 1

Index Only Scan using market_outcomes_market_id_outcome_no_odds_version_idx on iddaa.market_outcomes eo (cost=0.43..2.21 rows=1 width=12) (actual time=0.202..0.559 rows=12 loops=1)

  • Output: eo.market_id, eo.outcome_no, eo.odds_version
  • Index Cond: ((eo.market_id = (unnest('{128618}'::integer[]))) AND (eo.outcome_no = (unnest('{1}'::integer[]))))
  • Heap Fetches: 12
  • Buffers: shared hit=16
Planning time : 1.527 ms
Execution time : 0.869 ms