explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O5x3

Settings
# exclusive inclusive rows x rows loops node
1. 54.496 35,318.819 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=389,144.28..405,652.56 rows=256 width=640) (actual time=4,070.151..35,318.819 rows=6,617 loops=1)

2. 7.904 33,729.179 ↓ 25.8 6,617 1

Hash Left Join (cost=389,143.71..399,038.90 rows=256 width=520) (actual time=4,069.816..33,729.179 rows=6,617 loops=1)

  • Hash Cond: (own_ent_funds.fund_type = fund_type_map.fund_type_code)
3. 7.531 33,721.248 ↓ 25.8 6,617 1

Hash Left Join (cost=389,142.28..399,033.95 rows=256 width=456) (actual time=4,069.772..33,721.248 rows=6,617 loops=1)

  • Hash Cond: (ent_entity_metro_areas.metro_id = metro_map.metro_code)
4. 10.055 33,713.592 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=389,136.12..399,024.27 rows=256 width=440) (actual time=4,069.606..33,713.592 rows=6,617 loops=1)

5. 8.131 33,624.133 ↓ 25.8 6,617 1

Hash Left Join (cost=389,135.69..398,903.27 rows=256 width=445) (actual time=4,069.577..33,624.133 rows=6,617 loops=1)

  • Hash Cond: (country_map.region_code = region_map.region_code)
6. 9.141 33,615.979 ↓ 25.8 6,617 1

Hash Left Join (cost=389,134.51..398,898.57 rows=256 width=379) (actual time=4,069.542..33,615.979 rows=6,617 loops=1)

  • Hash Cond: (fund_entity.iso_country = country_map.iso_country)
7. 8.989 33,606.647 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=389,126.43..398,886.97 rows=256 width=367) (actual time=4,069.338..33,606.647 rows=6,617 loops=1)

8. 11.028 33,518.254 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=389,126.02..396,885.05 rows=256 width=326) (actual time=4,069.308..33,518.254 rows=6,617 loops=1)

9. 12.517 33,434.439 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=389,125.59..396,328.38 rows=256 width=307) (actual time=4,069.280..33,434.439 rows=6,617 loops=1)

10. 13.081 33,349.135 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=389,125.15..395,253.93 rows=256 width=276) (actual time=4,069.252..33,349.135 rows=6,617 loops=1)

11. 17.707 33,250.033 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=389,124.72..394,179.48 rows=256 width=239) (actual time=4,069.226..33,250.033 rows=6,617 loops=1)

12. 12.285 33,166.156 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=389,124.31..392,314.20 rows=256 width=223) (actual time=4,069.204..33,166.156 rows=6,617 loops=1)

13. 12,584.602 33,074.467 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=389,123.89..390,329.72 rows=256 width=192) (actual time=4,069.163..33,074.467 rows=6,617 loops=1)

  • Join Filter: ((current_factset_fund_holdings.factset_fund_id = factset_prev_fund_holdings.factset_fund_id) AND (factset_prev_fund_holdings.fsym_id = current_factset_fund_holdings.fsym_id))
  • Rows Removed by Join Filter: 43162784
14.          

CTE factset_fund_holdings

15. 21.007 2,417.510 ↑ 4.0 12,955 1

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

  • Filter: (h.pos <= 2)
  • Rows Removed by Filter: 64670
16. 75.624 2,396.503 ↑ 2.0 77,625 1

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

17. 94.586 2,320.879 ↑ 2.0 77,625 1

Merge Left Join (cost=189,243.11..190,763.29 rows=153,788 width=54) (actual time=2,167.558..2,320.879 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. 257.722 1,131.029 ↑ 2.0 77,625 1

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

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

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

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

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

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

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

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

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

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

24. 371.818 468.976 ↓ 7.6 143,529 1

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

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

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

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

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

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

  • Filter: (active_flag = 1)
  • Rows Removed by Filter: 51192
29. 174.980 174.980 ↑ 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.018..0.026 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. 246.945 1,095.264 ↓ 7.6 143,529 1

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

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

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

32. 102.583 762.156 ↓ 7.6 143,529 1

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

33. 544.939 659.573 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=603.358..659.573 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. 87.588 114.634 ↓ 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.930..114.634 rows=143,529 loops=1)

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

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

CTE factset_prev_fund_holdings

37. 16.052 1,860.024 ↓ 9.6 6,524 1

Subquery Scan on ph (cost=187,152.43..192,589.70 rows=680 width=46) (actual time=1,640.223..1,860.024 rows=6,524 loops=1)

  • Filter: (ph.pos = 1)
  • Rows Removed by Filter: 57911
38. 63.081 1,843.972 ↑ 2.1 64,435 1

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

39. 86.141 1,780.891 ↑ 2.1 64,435 1

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

Sort (cost=113,200.62..113,540.40 rows=135,913 width=46) (actual time=684.376..703.647 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. 33.503 569.512 ↑ 2.1 64,435 1

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

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

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

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

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

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

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

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

46. 265.836 348.382 ↓ 7.6 143,529 1

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

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

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

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

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

  • Buckets: 131072 Batches: 1 Memory Usage: 3753kB
50. 40.029 40.029 ↓ 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.029 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. 228.241 991.103 ↓ 7.6 143,529 1

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

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

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

54. 73.052 702.285 ↓ 7.6 143,529 1

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

55. 518.696 629.233 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=591.155..629.233 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. 86.848 110.537 ↓ 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=26.447..110.537 rows=143,529 loops=1)

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

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

Hash Left Join (cost=1,157.26..2,328.61 rows=256 width=112) (actual time=2,428.930..2,445.306 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. 2,173.034 2,173.034 ↓ 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=2,167.572..2,173.034 rows=6,617 loops=1)

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

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

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 523kB
61. 258.532 258.532 ↓ 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.011..258.532 rows=6,338 loops=1)

  • Filter: (pos = 2)
  • Rows Removed by Filter: 6617
62. 18,044.559 18,044.559 ↓ 2,174.7 6,524 6,617

CTE Scan on factset_prev_fund_holdings (cost=0.00..15.30 rows=3 width=88) (actual time=0.248..2.727 rows=6,524 loops=6,617)

  • Filter: (pos = 1)
63. 79.404 79.404 ↑ 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.011..0.012 rows=1 loops=6,617)

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

  • Index Cond: (factset_fund_id = current_factset_fund_holdings.factset_fund_id)
65. 86.021 86.021 ↑ 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.012..0.013 rows=1 loops=6,617)

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

  • Index Cond: (factset_fund_id = current_factset_fund_holdings.factset_fund_id)
69. 0.103 0.191 ↑ 1.0 270 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 21kB
70. 0.088 0.088 ↑ 1.0 270 1

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

71. 0.011 0.023 ↑ 1.0 8 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
72. 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.008..0.012 rows=8 loops=1)

73. 79.404 79.404 ↑ 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.011..0.012 rows=1 loops=6,617)

  • Index Cond: (factset_entity_id = inst_entity.factset_entity_id)
74. 0.067 0.125 ↑ 1.0 185 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
75. 0.058 0.058 ↑ 1.0 185 1

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

76. 0.014 0.027 ↑ 1.0 19 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
77. 0.013 0.013 ↑ 1.0 19 1

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

78. 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.38 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)))
79.          

SubPlan (forNested Loop Left Join)

80. 224.978 1,468.974 ↑ 1.0 1 6,617

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

81. 36.576 1,243.996 ↓ 2.0 2 6,617

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

82. 589.333 1,177.826 ↓ 2.0 2 6,617

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

  • Hash Cond: (country_map_1.iso_country = ent_entity_address.iso_country)
83. 462.770 462.770 ↑ 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.070 rows=270 loops=6,611)

84. 19.851 125.723 ↓ 2.0 2 6,617

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
85. 105.872 105.872 ↓ 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.014..0.016 rows=2 loops=6,617)

  • Index Cond: (factset_entity_id = own_ent_funds.factset_inst_entity_id)
86. 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 : 7.420 ms
Execution time : 35,329.668 ms