explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VEO9

Settings
# exclusive inclusive rows x rows loops node
1. 37.766 4,163.243 ↑ 1.0 1,000 1

Limit (cost=341,123,694.58..343,009,387.29 rows=1,000 width=1,101) (actual time=4,140.333..4,163.243 rows=1,000 loops=1)

2. 169.149 4,125.477 ↑ 2.0 181,900 1

Nested Loop Left Join (cost=1,883.54..699,463,765.75 rows=370,931 width=1,101) (actual time=0.044..4,125.477 rows=181,900 loops=1)

3. 335.912 864.028 ↑ 2.0 181,900 1

Nested Loop (cost=0.57..997,757.20 rows=370,931 width=1,096) (actual time=0.020..864.028 rows=181,900 loops=1)

4. 164.316 164.316 ↑ 2.0 181,900 1

Index Scan using broadway_orders_qqq on broadway_orders o (cost=0.43..933,743.60 rows=370,931 width=1,085) (actual time=0.012..164.316 rows=181,900 loops=1)

  • Index Cond: (tagomi_account_id = 701)
5. 363.800 363.800 ↑ 1.0 1 181,900

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

  • Index Cond: ((symbol)::text = (o.symbol)::text)
6. 181.900 3,092.300 ↑ 1.0 1 181,900

Aggregate (cost=1,882.97..1,882.99 rows=1 width=8) (actual time=0.017..0.017 rows=1 loops=181,900)

7. 2,910.400 2,910.400 ↓ 0.0 0 181,900

Index Scan using broadway_fills_root_order_group_idx on broadway_fills ff (cost=0.56..1,879.10 rows=516 width=8) (actual time=0.016..0.016 rows=0 loops=181,900)

  • Index Cond: ((root_order_group)::text = (o.internal_order_id)::text)
Planning time : 0.582 ms
Execution time : 4,163.529 ms