explain.depesz.com

PostgreSQL's explain analyze made readable

Result: od2f

Settings
# exclusive inclusive rows x rows loops node
1. 45.306 12,748.319 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=396,805.81..435,617.25 rows=769 width=640) (actual time=10,460.934..12,748.319 rows=6,617 loops=1)

2. 7.303 11,121.550 ↓ 8.6 6,617 1

Hash Left Join (cost=396,805.25..415,791.18 rows=769 width=520) (actual time=10,459.487..11,121.550 rows=6,617 loops=1)

  • Hash Cond: (own_ent_funds.fund_type = fund_type_map.fund_type_code)
3. 7.101 11,114.223 ↓ 8.6 6,617 1

Hash Left Join (cost=396,803.82..415,779.18 rows=769 width=456) (actual time=10,459.450..11,114.223 rows=6,617 loops=1)

  • Hash Cond: (ent_entity_metro_areas.metro_id = metro_map.metro_code)
4. 10.407 11,106.992 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=396,797.66..415,762.45 rows=769 width=440) (actual time=10,459.284..11,106.992 rows=6,617 loops=1)

5. 7.166 10,977.479 ↓ 8.6 6,617 1

Hash Left Join (cost=396,797.23..415,398.98 rows=769 width=445) (actual time=10,459.257..10,977.479 rows=6,617 loops=1)

  • Hash Cond: (country_map.region_code = region_map.region_code)
6. 7.599 10,970.297 ↓ 8.6 6,617 1

Hash Left Join (cost=396,796.05..415,387.23 rows=769 width=379) (actual time=10,459.233..10,970.297 rows=6,617 loops=1)

  • Hash Cond: (fund_entity.iso_country = country_map.iso_country)
7. 14.505 10,962.516 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=396,787.97..415,368.58 rows=769 width=367) (actual time=10,459.041..10,962.516 rows=6,617 loops=1)

8. 12.415 10,875.224 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=396,787.55..410,082.37 rows=769 width=326) (actual time=10,459.012..10,875.224 rows=6,617 loops=1)

9. 14.043 10,790.022 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=396,787.12..408,410.16 rows=769 width=307) (actual time=10,458.987..10,790.022 rows=6,617 loops=1)

10. 12.820 10,703.192 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=396,786.69..405,182.62 rows=769 width=276) (actual time=10,458.962..10,703.192 rows=6,617 loops=1)

11. 10.353 10,591.117 ↓ 8.6 6,617 1

Hash Left Join (cost=396,786.26..401,955.07 rows=769 width=239) (actual time=10,458.935..10,591.117 rows=6,617 loops=1)

  • Hash Cond: (current_factset_fund_holdings.factset_fund_id = q4_fund_values.factset_fund_id)
12. 12.309 10,535.446 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=394,430.00..399,588.24 rows=769 width=223) (actual time=10,413.378..10,535.446 rows=6,617 loops=1)

13. 18.614 10,456.967 ↓ 8.6 6,617 1

Merge Left Join (cost=394,429.59..394,450.35 rows=769 width=192) (actual time=10,413.343..10,456.967 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. 77.441 8,542.224 ↑ 2.0 77,625 1

WindowAgg (cost=189,243.11..193,454.58 rows=153,788 width=46) (actual time=8,309.456..8,542.224 rows=77,625 loops=1)

16. 95.261 8,464.783 ↑ 2.0 77,625 1

Merge Left Join (cost=189,243.11..190,763.29 rows=153,788 width=54) (actual time=8,309.449..8,464.783 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. 147.388 7,567.637 ↑ 2.0 77,625 1

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

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

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

  • Join Filter: (own_fund_detail.factset_fund_id = ad.factset_fund_id)
19. 2.948 7,262.226 ↑ 1.6 6,730 1

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

20. 1.091 1.091 ↑ 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=1.089..1.091 rows=1 loops=1)

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

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

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

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

23. 255.835 7,144.479 ↓ 7.6 143,529 1

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

  • Sort Key: own_fund_detail.factset_fund_id
  • Sort Method: quicksort Memory: 17358kB
24. 6,848.316 6,888.644 ↓ 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=42.990..6,888.644 rows=143,529 loops=1)

  • Recheck Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Blocks: exact=13494
25. 40.328 40.328 ↓ 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=40.328..40.328 rows=144,981 loops=1)

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

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

  • Buckets: 131072 Batches: 1 Memory Usage: 3753kB
27. 48.781 48.781 ↓ 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.012..48.781 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.012..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. 229.790 801.885 ↓ 7.6 143,529 1

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

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

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

31. 74.238 509.729 ↓ 7.6 143,529 1

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

32. 364.092 435.491 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=396.760..435.491 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. 54.235 71.399 ↓ 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=19.313..71.399 rows=143,529 loops=1)

  • Recheck Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Blocks: exact=13494
34. 17.164 17.164 ↓ 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.164..17.164 rows=144,981 loops=1)

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

CTE factset_prev_fund_holdings

36. 64.073 1,770.199 ↑ 2.1 64,435 1

WindowAgg (cost=187,152.43..190,890.79 rows=135,913 width=46) (actual time=1,564.408..1,770.199 rows=64,435 loops=1)

37. 85.760 1,706.126 ↑ 2.1 64,435 1

Merge Left Join (cost=187,152.43..188,512.31 rows=135,913 width=54) (actual time=1,564.400..1,706.126 rows=64,435 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. 124.293 717.025 ↑ 2.1 64,435 1

Sort (cost=113,200.62..113,540.40 rows=135,913 width=46) (actual time=697.684..717.025 rows=64,435 loops=1)

  • Sort Key: own_fund_detail_2.factset_fund_id, ad_1.report_date DESC
  • Sort Method: quicksort Memory: 10592kB
39. 38.128 592.732 ↑ 2.1 64,435 1

Nested Loop (cost=77,017.22..101,612.46 rows=135,913 width=46) (actual time=387.554..592.732 rows=64,435 loops=1)

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

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

41. 0.023 0.023 ↑ 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.021..0.023 rows=1 loops=1)

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

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

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

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

44. 243.893 342.188 ↓ 7.6 143,529 1

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

  • Sort Key: own_fund_detail_2.factset_fund_id
  • Sort Method: quicksort Memory: 17358kB
45. 71.563 98.295 ↓ 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=29.534..98.295 rows=143,529 loops=1)

  • Recheck Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Blocks: exact=13494
46. 26.732 26.732 ↓ 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.731..26.732 rows=144,981 loops=1)

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

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

  • Buckets: 131072 Batches: 1 Memory Usage: 3753kB
48. 53.178 53.178 ↓ 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.011..53.178 rows=68,140 loops=1)

  • Filter: (active_flag = 1)
  • Rows Removed by Filter: 51192
49. 80.760 80.760 ↑ 1.3 10 6,730

Index Only Scan using q4_fund_dates_pkey on q4_fund_dates ad_1 (cost=0.43..2.07 rows=13 width=13) (actual time=0.009..0.012 rows=10 loops=6,730)

  • Index Cond: ((factset_fund_id = ent_1.factset_fund_id) AND (report_date >= '2017-06-10'::date) AND (report_date <= '2019-06-10'::date) AND (report_date >= '2016-12-31'::date) AND (report_date <= '2018-12-31'::date))
  • Heap Fetches: 64435
50. 252.189 903.341 ↓ 7.6 143,529 1

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

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

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

52. 112.458 556.459 ↓ 7.6 143,529 1

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

53. 367.903 444.001 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=383.406..444.001 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. 58.005 76.098 ↓ 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=20.261..76.098 rows=143,529 loops=1)

  • Recheck Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Blocks: exact=13494
55. 18.093 18.093 ↓ 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=18.092..18.093 rows=144,981 loops=1)

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
56. 16.067 8,625.136 ↓ 8.6 6,617 1

Merge Left Join (cost=6,994.18..7,005.87 rows=769 width=112) (actual time=8,603.568..8,625.136 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. 7.266 8,591.589 ↓ 8.6 6,617 1

Sort (cost=3,497.09..3,499.01 rows=769 width=92) (actual time=8,588.877..8,591.589 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. 8,584.323 8,584.323 ↓ 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=8,309.461..8,584.323 rows=6,617 loops=1)

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

Sort (cost=3,497.09..3,499.01 rows=769 width=92) (actual time=14.688..17.480 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. 10.215 10.215 ↓ 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.007..10.215 rows=6,338 loops=1)

  • Filter: (pos = 2)
  • Rows Removed by Filter: 71287
61. 8.093 1,813.217 ↓ 9.6 6,524 1

Sort (cost=3,090.03..3,091.73 rows=680 width=88) (actual time=1,809.769..1,813.217 rows=6,524 loops=1)

  • Sort Key: factset_prev_fund_holdings.fsym_id, factset_prev_fund_holdings.factset_fund_id
  • Sort Method: quicksort Memory: 702kB
62. 1,805.124 1,805.124 ↓ 9.6 6,524 1

CTE Scan on factset_prev_fund_holdings (cost=0.00..3,058.04 rows=680 width=88) (actual time=1,564.416..1,805.124 rows=6,524 loops=1)

  • Filter: (pos = 1)
  • Rows Removed by Filter: 57911
63. 66.170 66.170 ↑ 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.010..0.010 rows=1 loops=6,617)

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

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

  • Buckets: 65536 Batches: 1 Memory Usage: 3926kB
65. 22.755 22.755 ↑ 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.011..22.755 rows=65,078 loops=1)

66. 99.255 99.255 ↑ 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.015..0.015 rows=1 loops=6,617)

  • Index Cond: (factset_entity_id = own_ent_funds.factset_inst_entity_id)
67. 72.787 72.787 ↑ 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.011..0.011 rows=1 loops=6,617)

  • Index Cond: (factset_entity_id = own_ent_funds.factset_fund_id)
68. 72.787 72.787 ↑ 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.011..0.011 rows=1 loops=6,617)

  • Index Cond: (factset_entity_id = own_ent_funds.factset_fund_id)
69. 72.787 72.787 ↑ 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.011..0.011 rows=1 loops=6,617)

  • Index Cond: (factset_fund_id = current_factset_fund_holdings.factset_fund_id)
70. 0.097 0.182 ↑ 1.0 270 1

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

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

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

72. 0.004 0.016 ↑ 1.0 8 1

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

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

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

74. 119.106 119.106 ↑ 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.017..0.018 rows=1 loops=6,617)

  • Index Cond: (factset_entity_id = inst_entity.factset_entity_id)
75. 0.068 0.130 ↑ 1.0 185 1

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

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

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

77. 0.012 0.024 ↑ 1.0 19 1

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

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

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

79. 66.170 66.170 ↑ 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.010..0.010 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. 218.361 1,515.293 ↑ 1.0 1 6,617

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

82. 36.576 1,296.932 ↓ 2.0 2 6,617

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

83. 595.968 1,230.762 ↓ 2.0 2 6,617

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

  • Hash Cond: (country_map_1.iso_country = ent_entity_address.iso_country)
84. 482.603 482.603 ↑ 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.002..0.073 rows=270 loops=6,611)

85. 13.234 152.191 ↓ 2.0 2 6,617

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
86. 138.957 138.957 ↓ 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.016..0.021 rows=2 loops=6,617)

  • Index Cond: (factset_entity_id = own_ent_funds.factset_inst_entity_id)
87. 29.594 29.594 ↑ 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.002..0.002 rows=1 loops=14,797)

  • Index Cond: (region_code = country_map_1.region_code)
Planning time : 8.411 ms
Execution time : 12,761.219 ms