explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yuVQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.026 ↑ 100.0 1 1

Nested Loop (cost=1.12..728.57 rows=100 width=26) (actual time=0.025..0.026 rows=1 loops=1)

2. 0.003 0.020 ↑ 100.0 1 1

Nested Loop (cost=0.57..459.25 rows=100 width=18) (actual time=0.020..0.020 rows=1 loops=1)

3. 0.006 0.006 ↑ 100.0 1 1

Function Scan on jsonb_array_elements m (cost=0.00..1.00 rows=100 width=32) (actual time=0.006..0.006 rows=1 loops=1)

4. 0.011 0.011 ↑ 1.0 1 1

Index Scan using source_odds_pkey on source_odds so (cost=0.56..4.58 rows=1 width=18) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (id = ((m.value ->> 'Id'::text))::bigint)
5. 0.005 0.005 ↑ 1.0 1 1

Index Scan using source_markets_pkey on source_markets sm (cost=0.56..2.69 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (id = so.market_id)
Planning time : 0.498 ms
Execution time : 0.055 ms