explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mduB

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.739 1,940.694 ↑ 361.4 1,047 1

Sort (cost=500,071.25..501,017.13 rows=378,352 width=84) (actual time=1,940.622..1,940.694 rows=1,047 loops=1)

  • Sort Key: (sum(a.flow)) DESC
  • Sort Method: quicksort Memory: 195kB
2. 185.771 1,939.955 ↑ 361.4 1,047 1

HashAggregate (cost=461,234.61..465,018.13 rows=378,352 width=84) (actual time=1,936.999..1,939.955 rows=1,047 loops=1)

  • Group Key: c.list_id, b.fundfamilyname
3. 324.936 1,754.184 ↓ 1.2 582,285 1

Hash Left Join (cost=14,273.08..457,504.87 rows=497,298 width=52) (actual time=157.234..1,754.184 rows=582,285 loops=1)

  • Hash Cond: (a.source = (b.id)::bpchar)
4. 87.677 1,273.457 ↓ 1.2 582,285 1

Nested Loop (cost=0.99..436,394.93 rows=497,298 width=33) (actual time=0.143..1,273.457 rows=582,285 loops=1)

5. 0.497 0.497 ↓ 2.6 389 1

Index Scan using securities_listconstituent_list_id_62b0f6d1 on securities_listconstituent c (cost=0.42..140.19 rows=150 width=25) (actual time=0.055..0.497 rows=389 loops=1)

  • Index Cond: (list_id = '6e87ce34-29ea-42da-8297-e6dd7e4967f8'::uuid)
6. 1,185.283 1,185.283 ↑ 2.2 1,497 389

Index Scan using edge_flows_sink_as_of_temp on edge_flows a (cost=0.57..2,875.07 rows=3,329 width=26) (actual time=0.028..3.047 rows=1,497 loops=389)

  • Index Cond: ((sink = (c.shareclass_id)::bpchar) AND (as_of >= '2018-05-01'::date) AND (as_of <= '2019-05-01'::date))
7. 62.043 155.791 ↑ 1.0 182,182 1

Hash (cost=11,994.82..11,994.82 rows=182,182 width=37) (actual time=155.791..155.791 rows=182,182 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 14414kB
8. 93.748 93.748 ↑ 1.0 182,182 1

Seq Scan on securities_shareclass b (cost=0.00..11,994.82 rows=182,182 width=37) (actual time=0.020..93.748 rows=182,182 loops=1)

Planning time : 0.571 ms
Execution time : 1,946.943 ms