explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ubKl

Settings
# exclusive inclusive rows x rows loops node
1. 55.188 5,876.939 ↑ 1.0 1,000 1

Limit (cost=151,597,145.98..152,203,532.15 rows=1,000 width=1,101) (actual time=5,852.513..5,876.939 rows=1,000 loops=1)

2. 316.025 5,821.751 ↑ 1.5 251,000 1

Nested Loop Left Join (cost=604.23..225,171,798.79 rows=371,333 width=1,101) (actual time=0.045..5,821.751 rows=251,000 loops=1)

3. 252.332 1,238.726 ↑ 1.5 251,000 1

Nested Loop (cost=0.57..998,841.58 rows=371,333 width=1,096) (actual time=0.020..1,238.726 rows=251,000 loops=1)

4. 233.394 233.394 ↑ 1.5 251,000 1

Index Scan using broadway_orders_qqq on broadway_orders o (cost=0.43..934,758.63 rows=371,333 width=1,085) (actual time=0.012..233.394 rows=251,000 loops=1)

  • Index Cond: (tagomi_account_id = 701)
5. 753.000 753.000 ↑ 1.0 1 251,000

Index Scan using instrument_master_symbol on instrument_master i (cost=0.14..0.16 rows=1 width=11) (actual time=0.002..0.003 rows=1 loops=251,000)

  • Index Cond: ((symbol)::text = (o.symbol)::text)
6. 251.000 4,267.000 ↑ 1.0 1 251,000

Aggregate (cost=603.66..603.68 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=251,000)

7. 4,016.000 4,016.000 ↓ 0.0 0 251,000

Index Only Scan using broadway_orders_root_order_group_fees_idx on broadway_fills ff (cost=0.56..599.71 rows=527 width=8) (actual time=0.016..0.016 rows=0 loops=251,000)

  • Index Cond: (root_order_group = (o.internal_order_id)::text)
  • Heap Fetches: 6085
Planning time : 0.506 ms
Execution time : 5,877.251 ms