explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YLO

Settings
# exclusive inclusive rows x rows loops node
1. 67.386 8,661.344 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=404,727.74..443,540.83 rows=769 width=640) (actual time=5,189.999..8,661.344 rows=6,617 loops=1)

2. 14.816 6,079.498 ↓ 8.6 6,617 1

Hash Left Join (cost=404,727.17..423,714.77 rows=769 width=520) (actual time=5,189.560..6,079.498 rows=6,617 loops=1)

  • Hash Cond: (own_ent_funds.fund_type = fund_type_map.fund_type_code)
3. 14.879 6,064.650 ↓ 8.6 6,617 1

Hash Left Join (cost=404,725.75..423,702.77 rows=769 width=456) (actual time=5,189.518..6,064.650 rows=6,617 loops=1)

  • Hash Cond: (ent_entity_metro_areas.metro_id = metro_map.metro_code)
4. 18.587 6,049.556 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=404,719.58..423,686.03 rows=769 width=440) (actual time=5,189.292..6,049.556 rows=6,617 loops=1)

5. 10.127 5,925.097 ↓ 8.6 6,617 1

Hash Left Join (cost=404,719.15..423,322.57 rows=769 width=445) (actual time=5,189.267..5,925.097 rows=6,617 loops=1)

  • Hash Cond: (country_map.region_code = region_map.region_code)
6. 13.047 5,914.953 ↓ 8.6 6,617 1

Hash Left Join (cost=404,717.97..423,310.81 rows=769 width=379) (actual time=5,189.240..5,914.953 rows=6,617 loops=1)

  • Hash Cond: (fund_entity.iso_country = country_map.iso_country)
7. 18.245 5,901.583 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=404,709.90..423,292.17 rows=769 width=367) (actual time=5,188.900..5,901.583 rows=6,617 loops=1)

8. 16.673 5,777.466 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=404,709.48..418,005.96 rows=769 width=326) (actual time=5,188.877..5,777.466 rows=6,617 loops=1)

9. 18.270 5,661.538 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=404,709.05..416,333.75 rows=769 width=307) (actual time=5,188.855..5,661.538 rows=6,617 loops=1)

10. 17.267 5,537.396 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=404,708.62..413,106.20 rows=769 width=276) (actual time=5,188.833..5,537.396 rows=6,617 loops=1)

11. 27.185 5,407.640 ↓ 8.6 6,617 1

Hash Left Join (cost=404,708.19..409,878.66 rows=769 width=239) (actual time=5,188.802..5,407.640 rows=6,617 loops=1)

  • Hash Cond: (current_factset_fund_holdings.factset_fund_id = q4_fund_values.factset_fund_id)
12. 21.110 5,314.562 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=402,351.93..407,511.83 rows=769 width=223) (actual time=5,122.811..5,314.562 rows=6,617 loops=1)

13. 28.756 5,194.197 ↓ 8.6 6,617 1

Merge Left Join (cost=402,351.51..402,373.93 rows=769 width=192) (actual time=5,122.788..5,194.197 rows=6,617 loops=1)

  • Merge Cond: ((current_factset_fund_holdings.fsym_id = factset_prev_fund_holdings.fsym_id) AND (current_factset_fund_holdings.factset_fund_id = factset_prev_fund_holdings.factset_fund_id))
14.          

CTE factset_fund_holdings

15. 125.777 2,207.399 ↑ 2.0 77,625 1

WindowAgg (cost=189,243.11..193,454.58 rows=153,788 width=46) (actual time=1,830.908..2,207.399 rows=77,625 loops=1)

16. 154.411 2,081.622 ↑ 2.0 77,625 1

Merge Left Join (cost=189,243.11..190,763.29 rows=153,788 width=54) (actual time=1,830.900..2,081.622 rows=77,625 loops=1)

  • Merge Cond: ((own_fund_detail.factset_fund_id = adjh.factset_fund_id) AND (ad.report_date = adjh.report_date))
  • Join Filter: (adjh.fsym_id = sar.fsym_id)
17. 254.938 893.198 ↑ 2.0 77,625 1

Sort (cost=115,291.30..115,675.77 rows=153,788 width=46) (actual time=856.167..893.198 rows=77,625 loops=1)

  • Sort Key: own_fund_detail.factset_fund_id, ad.report_date DESC
  • Sort Method: quicksort Memory: 13973kB
18. 56.330 638.260 ↑ 2.0 77,625 1

Nested Loop (cost=77,017.22..102,042.02 rows=153,788 width=46) (actual time=360.960..638.260 rows=77,625 loops=1)

  • Join Filter: (own_fund_detail.factset_fund_id = ad.factset_fund_id)
19. 4.096 467.520 ↑ 1.6 6,730 1

Nested Loop (cost=77,016.79..77,592.30 rows=10,739 width=51) (actual time=360.926..467.520 rows=6,730 loops=1)

20. 0.017 0.017 ↑ 1.0 1 1

Index Only Scan using own_sec_coverage_fsym_id_idx on own_sec_coverage sar (cost=0.42..8.44 rows=1 width=9) (actual time=0.015..0.017 rows=1 loops=1)

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Fetches: 1
21. 8.735 463.407 ↑ 1.6 6,730 1

Hash Join (cost=77,016.37..77,476.47 rows=10,739 width=51) (actual time=360.909..463.407 rows=6,730 loops=1)

  • Hash Cond: (own_fund_detail.factset_fund_id = ent.factset_fund_id)
22. 47.540 385.103 ↑ 2.4 7,979 1

Unique (cost=72,099.09..72,193.17 rows=18,809 width=54) (actual time=290.890..385.103 rows=7,979 loops=1)

23. 252.164 337.563 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=290.888..337.563 rows=143,529 loops=1)

  • Sort Key: own_fund_detail.factset_fund_id
  • Sort Method: quicksort Memory: 17358kB
24. 68.240 85.399 ↓ 7.6 143,529 1

Bitmap Heap Scan on own_fund_detail (cost=442.39..70,763.18 rows=18,816 width=54) (actual time=19.299..85.399 rows=143,529 loops=1)

  • Recheck Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Blocks: exact=13494
25. 17.159 17.159 ↓ 7.7 144,981 1

Bitmap Index Scan on own_fund_detail_fsym_id_report_date_idx (cost=0.00..437.69 rows=18,816 width=0) (actual time=17.159..17.159 rows=144,981 loops=1)

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
26. 26.617 69.569 ↓ 1.0 68,140 1

Hash (cost=4,065.65..4,065.65 rows=68,131 width=9) (actual time=69.569..69.569 rows=68,140 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 3753kB
27. 42.952 42.952 ↓ 1.0 68,140 1

Seq Scan on own_ent_funds ent (cost=0.00..4,065.65 rows=68,131 width=9) (actual time=0.010..42.952 rows=68,140 loops=1)

  • Filter: (active_flag = 1)
  • Rows Removed by Filter: 51192
28. 114.410 114.410 ↑ 1.2 12 6,730

Index Only Scan using q4_fund_dates_pkey on q4_fund_dates ad (cost=0.43..2.10 rows=14 width=13) (actual time=0.011..0.017 rows=12 loops=6,730)

  • Index Cond: ((factset_fund_id = ent.factset_fund_id) AND (report_date >= '2017-06-10'::date) AND (report_date <= '2019-06-10'::date) AND (report_date >= '2017-06-10'::date) AND (report_date <= '2019-06-10'::date))
  • Heap Fetches: 77625
29. 272.719 1,034.013 ↓ 7.6 143,529 1

Sort (cost=73,951.81..73,998.84 rows=18,809 width=30) (actual time=974.717..1,034.013 rows=143,529 loops=1)

  • Sort Key: adjh.factset_fund_id, adjh.report_date DESC
  • Sort Method: quicksort Memory: 17358kB
30. 82.558 761.294 ↓ 7.6 143,529 1

Subquery Scan on adjh (cost=72,099.09..72,616.46 rows=18,809 width=30) (actual time=535.505..761.294 rows=143,529 loops=1)

31. 93.362 678.736 ↓ 7.6 143,529 1

Unique (cost=72,099.09..72,428.37 rows=18,809 width=54) (actual time=535.502..678.736 rows=143,529 loops=1)

32. 467.901 585.374 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=535.500..585.374 rows=143,529 loops=1)

  • Sort Key: own_fund_detail_1.factset_fund_id, own_fund_detail_1.adj_holding, own_fund_detail_1.report_date, own_fund_detail_1.reported_holding, own_fund_detail_1.adj_mv, own_fund_detail_1.reported_mv
  • Sort Method: quicksort Memory: 26321kB
33. 91.025 117.473 ↓ 7.6 143,529 1

Bitmap Heap Scan on own_fund_detail own_fund_detail_1 (cost=442.39..70,763.18 rows=18,816 width=54) (actual time=29.243..117.473 rows=143,529 loops=1)

  • Recheck Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Blocks: exact=13494
34. 26.448 26.448 ↓ 7.7 144,981 1

Bitmap Index Scan on own_fund_detail_fsym_id_report_date_idx (cost=0.00..437.69 rows=18,816 width=0) (actual time=26.447..26.448 rows=144,981 loops=1)

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
35.          

CTE factset_prev_fund_holdings

36. 161.899 2,709.407 ↑ 2.1 83,931 1

WindowAgg (cost=192,923.52..197,825.69 rows=179,250 width=46) (actual time=2,229.088..2,709.407 rows=83,931 loops=1)

37. 194.640 2,547.508 ↑ 2.1 83,931 1

Merge Left Join (cost=192,923.52..194,688.81 rows=179,250 width=54) (actual time=2,229.075..2,547.508 rows=83,931 loops=1)

  • Merge Cond: ((own_fund_detail_2.factset_fund_id = adjh_1.factset_fund_id) AND (ad_1.report_date = adjh_1.report_date))
  • Join Filter: (adjh_1.fsym_id = sar_1.fsym_id)
38. 218.218 1,253.657 ↑ 2.1 83,931 1

Sort (cost=118,971.70..119,419.83 rows=179,250 width=46) (actual time=1,206.201..1,253.657 rows=83,931 loops=1)

  • Sort Key: own_fund_detail_2.factset_fund_id, ad_1.report_date DESC
  • Sort Method: quicksort Memory: 14867kB
39. 76.950 1,035.439 ↑ 2.1 83,931 1

Nested Loop (cost=77,017.22..103,330.70 rows=179,250 width=46) (actual time=674.540..1,035.439 rows=83,931 loops=1)

  • Join Filter: (own_fund_detail_2.factset_fund_id = ad_1.factset_fund_id)
40. 4.724 817.159 ↑ 1.6 6,730 1

Nested Loop (cost=77,016.79..77,592.30 rows=10,739 width=51) (actual time=674.497..817.159 rows=6,730 loops=1)

41. 0.024 0.024 ↑ 1.0 1 1

Index Only Scan using own_sec_coverage_fsym_id_idx on own_sec_coverage sar_1 (cost=0.42..8.44 rows=1 width=9) (actual time=0.023..0.024 rows=1 loops=1)

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Fetches: 1
42. 10.760 812.411 ↑ 1.6 6,730 1

Hash Join (cost=77,016.37..77,476.47 rows=10,739 width=51) (actual time=674.472..812.411 rows=6,730 loops=1)

  • Hash Cond: (own_fund_detail_2.factset_fund_id = ent_1.factset_fund_id)
43. 68.375 685.660 ↑ 2.4 7,979 1

Unique (cost=72,099.09..72,193.17 rows=18,809 width=54) (actual time=557.916..685.660 rows=7,979 loops=1)

44. 446.209 617.285 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=557.914..617.285 rows=143,529 loops=1)

  • Sort Key: own_fund_detail_2.factset_fund_id
  • Sort Method: quicksort Memory: 17358kB
45. 143.432 171.076 ↓ 7.6 143,529 1

Bitmap Heap Scan on own_fund_detail own_fund_detail_2 (cost=442.39..70,763.18 rows=18,816 width=54) (actual time=30.699..171.076 rows=143,529 loops=1)

  • Recheck Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Blocks: exact=13494
46. 27.644 27.644 ↓ 7.7 144,981 1

Bitmap Index Scan on own_fund_detail_fsym_id_report_date_idx (cost=0.00..437.69 rows=18,816 width=0) (actual time=27.644..27.644 rows=144,981 loops=1)

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
47. 45.157 115.991 ↓ 1.0 68,140 1

Hash (cost=4,065.65..4,065.65 rows=68,131 width=9) (actual time=115.991..115.991 rows=68,140 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 3753kB
48. 70.834 70.834 ↓ 1.0 68,140 1

Seq Scan on own_ent_funds ent_1 (cost=0.00..4,065.65 rows=68,131 width=9) (actual time=0.014..70.834 rows=68,140 loops=1)

  • Filter: (active_flag = 1)
  • Rows Removed by Filter: 51192
49. 141.330 141.330 ↑ 1.4 12 6,730

Index Only Scan using q4_fund_dates_pkey on q4_fund_dates ad_1 (cost=0.43..2.18 rows=17 width=13) (actual time=0.014..0.021 rows=12 loops=6,730)

  • Index Cond: ((factset_fund_id = ent_1.factset_fund_id) AND (report_date >= '2016-12-31'::date) AND (report_date <= '2018-12-31'::date) AND (report_date >= '2016-12-31'::date) AND (report_date <= '2018-12-31'::date))
  • Heap Fetches: 83931
50. 357.572 1,099.211 ↓ 7.6 143,529 1

Sort (cost=73,951.81..73,998.84 rows=18,809 width=30) (actual time=1,022.853..1,099.211 rows=143,529 loops=1)

  • Sort Key: adjh_1.factset_fund_id, adjh_1.report_date DESC
  • Sort Method: quicksort Memory: 17358kB
51. 83.834 741.639 ↓ 7.6 143,529 1

Subquery Scan on adjh_1 (cost=72,099.09..72,616.46 rows=18,809 width=30) (actual time=507.963..741.639 rows=143,529 loops=1)

52. 98.829 657.805 ↓ 7.6 143,529 1

Unique (cost=72,099.09..72,428.37 rows=18,809 width=54) (actual time=507.961..657.805 rows=143,529 loops=1)

53. 461.772 558.976 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=507.958..558.976 rows=143,529 loops=1)

  • Sort Key: own_fund_detail_3.factset_fund_id, own_fund_detail_3.adj_holding, own_fund_detail_3.report_date, own_fund_detail_3.reported_holding, own_fund_detail_3.adj_mv, own_fund_detail_3.reported_mv
  • Sort Method: quicksort Memory: 26321kB
54. 75.372 97.204 ↓ 7.6 143,529 1

Bitmap Heap Scan on own_fund_detail own_fund_detail_3 (cost=442.39..70,763.18 rows=18,816 width=54) (actual time=24.644..97.204 rows=143,529 loops=1)

  • Recheck Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Blocks: exact=13494
55. 21.832 21.832 ↓ 7.7 144,981 1

Bitmap Index Scan on own_fund_detail_fsym_id_report_date_idx (cost=0.00..437.69 rows=18,816 width=0) (actual time=21.832..21.832 rows=144,981 loops=1)

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
56. 28.474 2,353.086 ↓ 8.6 6,617 1

Merge Left Join (cost=6,994.18..7,005.87 rows=769 width=112) (actual time=2,316.411..2,353.086 rows=6,617 loops=1)

  • Merge Cond: ((current_factset_fund_holdings.fsym_id = previous_factset_fund_holdings.fsym_id) AND (current_factset_fund_holdings.factset_fund_id = previous_factset_fund_holdings.factset_fund_id))
57. 12.132 2,287.251 ↓ 8.6 6,617 1

Sort (cost=3,497.09..3,499.01 rows=769 width=92) (actual time=2,283.094..2,287.251 rows=6,617 loops=1)

  • Sort Key: current_factset_fund_holdings.fsym_id, current_factset_fund_holdings.factset_fund_id
  • Sort Method: quicksort Memory: 709kB
58. 2,275.119 2,275.119 ↓ 8.6 6,617 1

CTE Scan on factset_fund_holdings current_factset_fund_holdings (cost=0.00..3,460.23 rows=769 width=92) (actual time=1,830.914..2,275.119 rows=6,617 loops=1)

  • Filter: (pos = 1)
  • Rows Removed by Filter: 71008
59. 12.303 37.361 ↓ 8.2 6,338 1

Sort (cost=3,497.09..3,499.01 rows=769 width=92) (actual time=33.312..37.361 rows=6,338 loops=1)

  • Sort Key: previous_factset_fund_holdings.fsym_id, previous_factset_fund_holdings.factset_fund_id
  • Sort Method: quicksort Memory: 688kB
60. 25.058 25.058 ↓ 8.2 6,338 1

CTE Scan on factset_fund_holdings previous_factset_fund_holdings (cost=0.00..3,460.23 rows=769 width=92) (actual time=0.006..25.058 rows=6,338 loops=1)

  • Filter: (pos = 2)
  • Rows Removed by Filter: 71287
61. 12.909 2,812.355 ↓ 7.3 6,562 1

Sort (cost=4,077.06..4,079.30 rows=896 width=88) (actual time=2,806.371..2,812.355 rows=6,562 loops=1)

  • Sort Key: factset_prev_fund_holdings.fsym_id, factset_prev_fund_holdings.factset_fund_id
  • Sort Method: quicksort Memory: 705kB
62. 2,799.446 2,799.446 ↓ 7.3 6,562 1

CTE Scan on factset_prev_fund_holdings (cost=0.00..4,033.12 rows=896 width=88) (actual time=2,229.095..2,799.446 rows=6,562 loops=1)

  • Filter: (pos = 1)
  • Rows Removed by Filter: 77369
63. 99.255 99.255 ↑ 1.0 1 6,617

Index Scan using own_ent_funds_pkey on own_ent_funds (cost=0.42..6.66 rows=1 width=31) (actual time=0.015..0.015 rows=1 loops=6,617)

  • Index Cond: (current_factset_fund_holdings.factset_fund_id = factset_fund_id)
64. 34.462 65.893 ↑ 1.0 65,078 1

Hash (cost=1,542.78..1,542.78 rows=65,078 width=26) (actual time=65.893..65.893 rows=65,078 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3926kB
65. 31.431 31.431 ↑ 1.0 65,078 1

Seq Scan on q4_fund_values (cost=0.00..1,542.78 rows=65,078 width=26) (actual time=0.009..31.431 rows=65,078 loops=1)

66. 112.489 112.489 ↑ 1.0 1 6,617

Index Scan using sym_entity_pkey on sym_entity inst_entity (cost=0.43..4.19 rows=1 width=37) (actual time=0.017..0.017 rows=1 loops=6,617)

  • Index Cond: (factset_entity_id = own_ent_funds.factset_inst_entity_id)
67. 105.872 105.872 ↑ 1.0 1 6,617

Index Scan using sym_entity_pkey on sym_entity fund_entity (cost=0.43..4.19 rows=1 width=40) (actual time=0.016..0.016 rows=1 loops=6,617)

  • Index Cond: (factset_entity_id = own_ent_funds.factset_fund_id)
68. 99.255 99.255 ↑ 1.0 1 6,617

Index Scan using h_entity_pkey on h_entity (cost=0.43..2.16 rows=1 width=37) (actual time=0.014..0.015 rows=1 loops=6,617)

  • Index Cond: (factset_entity_id = own_ent_funds.factset_fund_id)
69. 105.872 105.872 ↑ 1.0 1 6,617

Index Scan using cyclops_fund_overwrites_pkey on cyclops_fund_overwrites cyclops (cost=0.42..6.86 rows=1 width=51) (actual time=0.015..0.016 rows=1 loops=6,617)

  • Index Cond: (factset_fund_id = current_factset_fund_holdings.factset_fund_id)
70. 0.170 0.323 ↑ 1.0 270 1

Hash (cost=4.70..4.70 rows=270 width=15) (actual time=0.323..0.323 rows=270 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
71. 0.153 0.153 ↑ 1.0 270 1

Seq Scan on country_map (cost=0.00..4.70 rows=270 width=15) (actual time=0.008..0.153 rows=270 loops=1)

72. 0.009 0.017 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=76) (actual time=0.017..0.017 rows=8 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
73. 0.008 0.008 ↑ 1.0 8 1

Seq Scan on region_map (cost=0.00..1.08 rows=8 width=76) (actual time=0.005..0.008 rows=8 loops=1)

74. 105.872 105.872 ↑ 1.0 1 6,617

Index Scan using ent_entity_metro_areas_pkey on ent_entity_metro_areas (cost=0.43..0.46 rows=1 width=13) (actual time=0.015..0.016 rows=1 loops=6,617)

  • Index Cond: (factset_entity_id = inst_entity.factset_entity_id)
75. 0.101 0.215 ↑ 1.0 185 1

Hash (cost=3.85..3.85 rows=185 width=24) (actual time=0.214..0.215 rows=185 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
76. 0.114 0.114 ↑ 1.0 185 1

Seq Scan on metro_map (cost=0.00..3.85 rows=185 width=24) (actual time=0.011..0.114 rows=185 loops=1)

77. 0.017 0.032 ↑ 1.0 19 1

Hash (cost=1.19..1.19 rows=19 width=84) (actual time=0.031..0.032 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
78. 0.015 0.015 ↑ 1.0 19 1

Seq Scan on fund_type_map (cost=0.00..1.19 rows=19 width=84) (actual time=0.004..0.015 rows=19 loops=1)

79. 105.872 105.872 ↑ 2.0 1 6,617

Index Scan using own_sec_prices_pkey on own_sec_prices prices (cost=0.57..11.33 rows=2 width=45) (actual time=0.015..0.016 rows=1 loops=6,617)

  • Index Cond: ((fsym_id = current_factset_fund_holdings.fsym_id) AND (price_date = (date_trunc('month'::text, (current_factset_fund_holdings.report_date)::timestamp with time zone) - '1 day'::interval)))
80.          

SubPlan (forNested Loop Left Join)

81. 344.084 2,408.588 ↑ 1.0 1 6,617

Aggregate (cost=14.39..14.40 rows=1 width=32) (actual time=0.364..0.364 rows=1 loops=6,617)

82. 61.481 2,064.504 ↓ 2.0 2 6,617

Nested Loop Left Join (cost=8.59..14.39 rows=1 width=138) (actual time=0.181..0.312 rows=2 loops=6,617)

83. 986.665 1,958.632 ↓ 2.0 2 6,617

Hash Right Join (cost=8.46..14.18 rows=1 width=72) (actual time=0.172..0.296 rows=2 loops=6,617)

  • Hash Cond: (country_map_1.iso_country = ent_entity_address.iso_country)
84. 806.542 806.542 ↑ 1.0 270 6,611

Seq Scan on country_map country_map_1 (cost=0.00..4.70 rows=270 width=15) (actual time=0.003..0.122 rows=270 loops=6,611)

85. 33.085 165.425 ↓ 2.0 2 6,617

Hash (cost=8.45..8.45 rows=1 width=60) (actual time=0.025..0.025 rows=2 loops=6,617)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
86. 132.340 132.340 ↓ 2.0 2 6,617

Index Scan using ent_entity_address_factset_entity_id_idx on ent_entity_address (cost=0.43..8.45 rows=1 width=60) (actual time=0.017..0.020 rows=2 loops=6,617)

  • Index Cond: (factset_entity_id = own_ent_funds.factset_inst_entity_id)
87. 44.391 44.391 ↑ 1.0 1 14,797

Index Scan using region_map_pkey on region_map region_map_1 (cost=0.13..0.19 rows=1 width=76) (actual time=0.003..0.003 rows=1 loops=14,797)

  • Index Cond: (region_code = country_map_1.region_code)
Planning time : 4.570 ms
Execution time : 8,668.277 ms