explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6gAo

Settings
# exclusive inclusive rows x rows loops node
1. 37.881 19,936.544 ↑ 1.0 1,000 1

Limit (cost=341,620,304.02..343,508,741.94 rows=1,000 width=1,101) (actual time=19,828.854..19,936.544 rows=1,000 loops=1)

2. 9,287.523 19,898.663 ↑ 2.0 181,900 1

Nested Loop (cost=1,883.40..694,805,406.93 rows=367,925 width=1,101) (actual time=0.169..19,898.663 rows=181,900 loops=1)

  • Join Filter: ((o.symbol)::text = (i.symbol)::text)
  • Rows Removed by Join Filter: 35106620
3. 244.114 3,517.040 ↑ 2.0 181,900 1

Nested Loop Left Join (cost=1,883.40..693,734,737.76 rows=367,925 width=1,073) (actual time=0.044..3,517.040 rows=181,900 loops=1)

4. 180.626 180.626 ↑ 2.0 181,900 1

Index Scan using broadway_orders_qqq on broadway_orders o (cost=0.43..929,050.99 rows=367,925 width=1,085) (actual time=0.011..180.626 rows=181,900 loops=1)

  • Index Cond: (tagomi_account_id = 701)
5. 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)

6. 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)
7. 7,094.040 7,094.100 ↑ 1.0 194 181,900

Materialize (cost=0.00..7.91 rows=194 width=11) (actual time=0.000..0.039 rows=194 loops=181,900)

8. 0.060 0.060 ↑ 1.0 194 1

Seq Scan on instrument_master i (cost=0.00..6.94 rows=194 width=11) (actual time=0.003..0.060 rows=194 loops=1)

Planning time : 0.534 ms
Execution time : 19,936.872 ms