explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DOAs

Settings
# exclusive inclusive rows x rows loops node
1. 38.765 5,194.975 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=390,167.02..406,656.84 rows=256 width=640) (actual time=3,397.986..5,194.975 rows=6,617 loops=1)

2. 6.171 3,912.214 ↓ 25.8 6,617 1

Hash Left Join (cost=390,166.45..400,043.18 rows=256 width=520) (actual time=3,397.727..3,912.214 rows=6,617 loops=1)

  • Hash Cond: (own_ent_funds.fund_type = fund_type_map.fund_type_code)
3. 6.384 3,906.025 ↓ 25.8 6,617 1

Hash Left Join (cost=390,165.03..400,038.23 rows=256 width=456) (actual time=3,397.701..3,906.025 rows=6,617 loops=1)

  • Hash Cond: (ent_entity_metro_areas.metro_id = metro_map.metro_code)
4. 7.493 3,899.507 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=390,158.86..400,028.55 rows=256 width=440) (actual time=3,397.557..3,899.507 rows=6,617 loops=1)

5. 6.038 3,832.461 ↓ 25.8 6,617 1

Hash Left Join (cost=390,158.43..399,907.55 rows=256 width=445) (actual time=3,397.540..3,832.461 rows=6,617 loops=1)

  • Hash Cond: (country_map.region_code = region_map.region_code)
6. 6.610 3,826.412 ↓ 25.8 6,617 1

Hash Left Join (cost=390,157.25..399,902.85 rows=256 width=379) (actual time=3,397.522..3,826.412 rows=6,617 loops=1)

  • Hash Cond: (fund_entity.iso_country = country_map.iso_country)
7. 12.401 3,819.624 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=390,149.18..399,891.26 rows=256 width=367) (actual time=3,397.330..3,819.624 rows=6,617 loops=1)

8. 7.491 3,754.287 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=390,148.76..397,889.34 rows=256 width=326) (actual time=3,397.312..3,754.287 rows=6,617 loops=1)

9. 7.383 3,687.243 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=390,148.33..397,332.66 rows=256 width=307) (actual time=3,397.296..3,687.243 rows=6,617 loops=1)

10. 11.691 3,620.307 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=390,147.90..396,258.21 rows=256 width=276) (actual time=3,397.282..3,620.307 rows=6,617 loops=1)

11. 8.781 3,549.063 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=390,147.47..395,183.76 rows=256 width=239) (actual time=3,397.266..3,549.063 rows=6,617 loops=1)

12. 12.789 3,487.346 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=390,147.05..393,318.48 rows=256 width=223) (actual time=3,397.247..3,487.346 rows=6,617 loops=1)

13. 10.041 3,421.621 ↓ 25.8 6,617 1

Hash Left Join (cost=390,146.63..391,334.00 rows=256 width=192) (actual time=3,397.221..3,421.621 rows=6,617 loops=1)

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

CTE factset_fund_holdings

15. 20.494 1,750.267 ↑ 4.0 12,955 1

Subquery Scan on h (cost=189,243.11..195,376.93 rows=51,263 width=46) (actual time=1,499.764..1,750.267 rows=12,955 loops=1)

  • Filter: (h.pos < 3)
  • Rows Removed by Filter: 64670
16. 76.896 1,729.773 ↑ 2.0 77,625 1

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

17. 95.156 1,652.877 ↑ 2.0 77,625 1

Merge Left Join (cost=189,243.11..190,763.29 rows=153,788 width=54) (actual time=1,499.753..1,652.877 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)
18. 156.954 782.481 ↑ 2.0 77,625 1

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

  • Sort Key: own_fund_detail.factset_fund_id, ad.report_date DESC
  • Sort Method: quicksort Memory: 13973kB
19. 52.731 625.527 ↑ 2.0 77,625 1

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

  • Join Filter: (own_fund_detail.factset_fund_id = ad.factset_fund_id)
20. 3.511 471.846 ↑ 1.6 6,730 1

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

21. 0.016 0.016 ↑ 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.016 rows=1 loops=1)

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Fetches: 1
22. 7.911 468.319 ↑ 1.6 6,730 1

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

  • Hash Cond: (own_fund_detail.factset_fund_id = ent.factset_fund_id)
23. 40.931 390.509 ↑ 2.4 7,979 1

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

24. 262.459 349.578 ↓ 7.6 143,529 1

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

  • Sort Key: own_fund_detail.factset_fund_id
  • Sort Method: quicksort Memory: 17358kB
25. 68.981 87.119 ↓ 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=20.303..87.119 rows=143,529 loops=1)

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

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
27. 25.540 69.899 ↓ 1.0 68,140 1

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

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

  • Filter: (active_flag = 1)
  • Rows Removed by Filter: 51192
29. 100.950 100.950 ↑ 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.010..0.015 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
30. 229.960 775.240 ↓ 7.6 143,529 1

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

  • Sort Key: adjh.factset_fund_id, adjh.report_date DESC
  • Sort Method: quicksort Memory: 17358kB
31. 61.152 545.280 ↓ 7.6 143,529 1

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

32. 73.962 484.128 ↓ 7.6 143,529 1

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

33. 340.962 410.166 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=371.923..410.166 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
34. 52.647 69.204 ↓ 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=18.667..69.204 rows=143,529 loops=1)

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

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

CTE factset_prev_fund_holdings

37. 17.937 1,624.583 ↑ 3.5 12,763 1

Subquery Scan on ph (cost=187,152.43..192,589.70 rows=45,304 width=46) (actual time=1,402.141..1,624.583 rows=12,763 loops=1)

  • Filter: (ph.pos < 3)
  • Rows Removed by Filter: 51672
38. 63.412 1,606.646 ↑ 2.1 64,435 1

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

39. 87.301 1,543.234 ↑ 2.1 64,435 1

Merge Left Join (cost=187,152.43..188,512.31 rows=135,913 width=54) (actual time=1,402.130..1,543.234 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)
40. 124.280 669.483 ↑ 2.1 64,435 1

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

  • Sort Key: own_fund_detail_2.factset_fund_id, ad_1.report_date DESC
  • Sort Method: quicksort Memory: 10592kB
41. 34.691 545.203 ↑ 2.1 64,435 1

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

  • Join Filter: (own_fund_detail_2.factset_fund_id = ad_1.factset_fund_id)
42. 2.938 429.752 ↑ 1.6 6,730 1

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

43. 0.027 0.027 ↑ 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.025..0.027 rows=1 loops=1)

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Fetches: 1
44. 6.725 426.787 ↑ 1.6 6,730 1

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

  • Hash Cond: (own_fund_detail_2.factset_fund_id = ent_1.factset_fund_id)
45. 35.549 357.657 ↑ 2.4 7,979 1

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

46. 239.018 322.108 ↓ 7.6 143,529 1

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

  • Sort Key: own_fund_detail_2.factset_fund_id
  • Sort Method: quicksort Memory: 17358kB
47. 65.680 83.090 ↓ 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=19.538..83.090 rows=143,529 loops=1)

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

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
49. 22.370 62.405 ↓ 1.0 68,140 1

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

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

  • Filter: (active_flag = 1)
  • Rows Removed by Filter: 51192
51. 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.008..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
52. 229.518 786.450 ↓ 7.6 143,529 1

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

  • Sort Key: adjh_1.factset_fund_id, adjh_1.report_date DESC
  • Sort Method: quicksort Memory: 17358kB
53. 61.229 556.932 ↓ 7.6 143,529 1

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

54. 73.631 495.703 ↓ 7.6 143,529 1

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

55. 352.619 422.072 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=384.789..422.072 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
56. 52.807 69.453 ↓ 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=18.755..69.453 rows=143,529 loops=1)

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

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
58. 8.204 1,775.929 ↓ 25.8 6,617 1

Hash Left Join (cost=1,157.26..2,328.61 rows=256 width=112) (actual time=1,761.550..1,775.929 rows=6,617 loops=1)

  • Hash 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))
59. 1,505.962 1,505.962 ↓ 25.8 6,617 1

CTE Scan on factset_fund_holdings current_factset_fund_holdings (cost=0.00..1,153.42 rows=256 width=92) (actual time=1,499.769..1,505.962 rows=6,617 loops=1)

  • Filter: (pos = 1)
  • Rows Removed by Filter: 6338
60. 2.744 261.763 ↓ 24.8 6,338 1

Hash (cost=1,153.42..1,153.42 rows=256 width=92) (actual time=261.763..261.763 rows=6,338 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 523kB
61. 259.019 259.019 ↓ 24.8 6,338 1

CTE Scan on factset_fund_holdings previous_factset_fund_holdings (cost=0.00..1,153.42 rows=256 width=92) (actual time=0.014..259.019 rows=6,338 loops=1)

  • Filter: (pos = 2)
  • Rows Removed by Filter: 6617
62. 2.695 1,635.651 ↓ 28.7 6,524 1

Hash (cost=1,019.34..1,019.34 rows=227 width=88) (actual time=1,635.651..1,635.651 rows=6,524 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 485kB
63. 1,632.956 1,632.956 ↓ 28.7 6,524 1

CTE Scan on factset_prev_fund_holdings (cost=0.00..1,019.34 rows=227 width=88) (actual time=1,402.146..1,632.956 rows=6,524 loops=1)

  • Filter: (pos = 1)
  • Rows Removed by Filter: 6239
64. 52.936 52.936 ↑ 1.0 1 6,617

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

  • Index Cond: (current_factset_fund_holdings.factset_fund_id = factset_fund_id)
65. 52.936 52.936 ↑ 1.0 1 6,617

Index Scan using q4_fund_values_pkey on q4_fund_values (cost=0.41..7.28 rows=1 width=26) (actual time=0.008..0.008 rows=1 loops=6,617)

  • Index Cond: (factset_fund_id = current_factset_fund_holdings.factset_fund_id)
66. 59.553 59.553 ↑ 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.009..0.009 rows=1 loops=6,617)

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

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

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

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

  • Index Cond: (factset_fund_id = current_factset_fund_holdings.factset_fund_id)
70. 0.095 0.178 ↑ 1.0 270 1

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

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

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

72. 0.003 0.011 ↑ 1.0 8 1

Hash (cost=1.08..1.08 rows=8 width=76) (actual time=0.011..0.011 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.003..0.008 rows=8 loops=1)

74. 59.553 59.553 ↑ 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.008..0.009 rows=1 loops=6,617)

  • Index Cond: (factset_entity_id = inst_entity.factset_entity_id)
75. 0.077 0.134 ↑ 1.0 185 1

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

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

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

77. 0.008 0.018 ↑ 1.0 19 1

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

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

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

79. 52.936 52.936 ↑ 2.0 1 6,617

Index Scan using own_sec_prices_pkey on own_sec_prices prices (cost=0.57..11.38 rows=2 width=45) (actual time=0.008..0.008 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. 178.659 1,191.060 ↑ 1.0 1 6,617

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

82. 23.342 1,012.401 ↓ 2.0 2 6,617

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

83. 483.395 959.465 ↓ 2.0 2 6,617

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

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

85. 13.234 86.021 ↓ 2.0 2 6,617

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
86. 72.787 72.787 ↓ 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.009..0.011 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.001..0.002 rows=1 loops=14,797)

  • Index Cond: (region_code = country_map_1.region_code)
Planning time : 5.055 ms
Execution time : 5,198.968 ms