explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dbvg : original

Settings
# exclusive inclusive rows x rows loops node
1. 39.772 5,539.069 ↓ 8.7 6,619 1

Nested Loop Left Join (cost=401,437.03..440,014.82 rows=765 width=640) (actual time=3,649.793..5,539.069 rows=6,619 loops=1)

2. 6.473 4,168.878 ↓ 8.7 6,619 1

Hash Left Join (cost=401,436.46..420,301.34 rows=765 width=495) (actual time=3,649.480..4,168.878 rows=6,619 loops=1)

  • Hash Cond: (own_ent_funds.fund_type = fund_type_map.fund_type_code)
3. 6.509 4,162.384 ↓ 8.7 6,619 1

Hash Left Join (cost=401,435.03..420,289.39 rows=765 width=431) (actual time=3,649.442..4,162.384 rows=6,619 loops=1)

  • Hash Cond: (ent_entity_metro_areas.metro_id = metro_map.metro_code)
4. 7.612 4,155.753 ↓ 8.7 6,619 1

Nested Loop Left Join (cost=401,428.87..420,272.71 rows=765 width=415) (actual time=3,649.284..4,155.753 rows=6,619 loops=1)

5. 6.430 4,081.951 ↓ 8.7 6,619 1

Hash Left Join (cost=401,428.44..419,911.14 rows=765 width=420) (actual time=3,649.256..4,081.951 rows=6,619 loops=1)

  • Hash Cond: (country_map.region_code = region_map.region_code)
6. 6.629 4,075.506 ↓ 8.7 6,619 1

Hash Left Join (cost=401,427.26..419,899.44 rows=765 width=354) (actual time=3,649.225..4,075.506 rows=6,619 loops=1)

  • Hash Cond: (fund_entity.iso_country = country_map.iso_country)
7. 12.703 4,068.692 ↓ 8.7 6,619 1

Nested Loop Left Join (cost=401,419.19..419,880.85 rows=765 width=342) (actual time=3,649.024..4,068.692 rows=6,619 loops=1)

8. 11.866 3,996.418 ↓ 8.7 6,619 1

Nested Loop Left Join (cost=401,418.77..414,620.42 rows=765 width=326) (actual time=3,649.006..3,996.418 rows=6,619 loops=1)

9. 11.202 3,924.981 ↓ 8.7 6,619 1

Nested Loop Left Join (cost=401,418.34..412,956.55 rows=765 width=307) (actual time=3,648.986..3,924.981 rows=6,619 loops=1)

10. 7.394 3,847.589 ↓ 8.7 6,619 1

Nested Loop Left Join (cost=401,417.91..409,745.25 rows=765 width=276) (actual time=3,648.957..3,847.589 rows=6,619 loops=1)

11. 9.482 3,767.386 ↓ 8.7 6,619 1

Hash Left Join (cost=401,417.47..406,533.96 rows=765 width=239) (actual time=3,648.922..3,767.386 rows=6,619 loops=1)

  • Hash Cond: (current_factset_fund_holdings.factset_fund_id = q4_fund_values.factset_fund_id)
12. 10.223 3,709.149 ↓ 8.7 6,619 1

Nested Loop Left Join (cost=399,061.22..404,167.19 rows=765 width=223) (actual time=3,599.923..3,709.149 rows=6,619 loops=1)

13. 17.473 3,639.355 ↓ 8.7 6,619 1

Merge Left Join (cost=399,060.80..399,083.11 rows=765 width=192) (actual time=3,599.890..3,639.355 rows=6,619 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. 80.051 1,745.407 ↑ 2.0 77,488 1

WindowAgg (cost=187,738.61..191,930.55 rows=153,086 width=46) (actual time=1,501.516..1,745.407 rows=77,488 loops=1)

16. 99.673 1,665.356 ↑ 2.0 77,488 1

Merge Left Join (cost=187,738.61..189,251.55 rows=153,086 width=54) (actual time=1,501.502..1,665.356 rows=77,488 loops=1)

  • Merge Cond: ((own_fund_detail.factset_fund_id = adjh.factset_fund_id) AND (q4_fund_dates.report_date = adjh.report_date))
  • Join Filter: (adjh.fsym_id = sar.fsym_id)
17. 150.235 764.527 ↑ 2.0 77,488 1

Sort (cost=113,980.01..114,362.72 rows=153,086 width=46) (actual time=740.200..764.527 rows=77,488 loops=1)

  • Sort Key: own_fund_detail.factset_fund_id, q4_fund_dates.report_date DESC
  • Sort Method: quicksort Memory: 13963kB
18. 43.145 614.292 ↑ 2.0 77,488 1

Nested Loop (cost=76,608.56..100,796.26 rows=153,086 width=46) (actual time=381.473..614.292 rows=77,488 loops=1)

  • Join Filter: (own_fund_detail.factset_fund_id = q4_fund_dates.factset_fund_id)
19. 3.315 470.167 ↑ 1.6 6,732 1

Nested Loop (cost=76,608.13..77,181.65 rows=10,686 width=51) (actual time=381.409..470.167 rows=6,732 loops=1)

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

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Fetches: 1
21. 7.412 466.811 ↑ 1.6 6,732 1

Hash Join (cost=76,607.71..77,066.35 rows=10,686 width=51) (actual time=381.368..466.811 rows=6,732 loops=1)

  • Hash Cond: (own_fund_detail.factset_fund_id = ent.factset_fund_id)
22. 38.246 388.044 ↑ 2.4 7,978 1

Unique (cost=71,911.06..72,004.89 rows=18,760 width=54) (actual time=309.559..388.044 rows=7,978 loops=1)

23. 244.614 349.798 ↓ 7.6 143,507 1

Sort (cost=71,911.06..71,957.98 rows=18,767 width=54) (actual time=309.557..349.798 rows=143,507 loops=1)

  • Sort Key: own_fund_detail.factset_fund_id
  • Sort Method: quicksort Memory: 17356kB
24. 87.261 105.184 ↓ 7.6 143,507 1

Bitmap Heap Scan on own_fund_detail (cost=442.01..70,578.98 rows=18,767 width=54) (actual time=20.053..105.184 rows=143,507 loops=1)

  • Recheck Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Blocks: exact=13470
25. 17.923 17.923 ↓ 7.7 144,938 1

Bitmap Index Scan on own_fund_detail_fsym_id_report_date_idx (cost=0.00..437.32 rows=18,767 width=0) (actual time=17.922..17.923 rows=144,938 loops=1)

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
26. 24.573 71.355 ↓ 1.0 68,142 1

Hash (cost=3,847.24..3,847.24 rows=67,953 width=9) (actual time=71.355..71.355 rows=68,142 loops=1)

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

Seq Scan on own_ent_funds ent (cost=0.00..3,847.24 rows=67,953 width=9) (actual time=0.012..46.782 rows=68,142 loops=1)

  • Filter: (active_flag = 1)
  • Rows Removed by Filter: 51182
28. 100.980 100.980 ↑ 1.2 12 6,732

Index Only Scan using q4_fund_dates_pkey on q4_fund_dates (cost=0.43..2.03 rows=14 width=13) (actual time=0.010..0.015 rows=12 loops=6,732)

  • Index Cond: ((factset_fund_id = ent.factset_fund_id) AND (report_date >= '2017-06-07'::date) AND (report_date <= '2019-06-07'::date))
  • Heap Fetches: 77488
29. 235.012 801.156 ↓ 7.6 143,507 1

Sort (cost=73,758.61..73,805.51 rows=18,760 width=30) (actual time=761.289..801.156 rows=143,507 loops=1)

  • Sort Key: adjh.factset_fund_id, adjh.report_date DESC
  • Sort Method: quicksort Memory: 17356kB
30. 64.922 566.144 ↓ 7.6 143,507 1

Subquery Scan on adjh (cost=71,911.06..72,427.08 rows=18,760 width=30) (actual time=384.284..566.144 rows=143,507 loops=1)

31. 77.696 501.222 ↓ 7.6 143,507 1

Unique (cost=71,911.06..72,239.48 rows=18,760 width=54) (actual time=384.281..501.222 rows=143,507 loops=1)

32. 349.470 423.526 ↓ 7.6 143,507 1

Sort (cost=71,911.06..71,957.98 rows=18,767 width=54) (actual time=384.280..423.526 rows=143,507 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: 26319kB
33. 56.589 74.056 ↓ 7.6 143,507 1

Bitmap Heap Scan on own_fund_detail own_fund_detail_1 (cost=442.01..70,578.98 rows=18,767 width=54) (actual time=19.600..74.056 rows=143,507 loops=1)

  • Recheck Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Blocks: exact=13470
34. 17.467 17.467 ↓ 7.7 144,938 1

Bitmap Index Scan on own_fund_detail_fsym_id_report_date_idx (cost=0.00..437.32 rows=18,767 width=0) (actual time=17.466..17.467 rows=144,938 loops=1)

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

CTE factset_prev_fund_holdings

36. 86.236 1,738.590 ↑ 2.1 83,932 1

WindowAgg (cost=191,234.31..196,111.17 rows=178,365 width=46) (actual time=1,480.554..1,738.590 rows=83,932 loops=1)

37. 104.584 1,652.354 ↑ 2.1 83,932 1

Merge Left Join (cost=191,234.31..192,989.79 rows=178,365 width=54) (actual time=1,480.547..1,652.354 rows=83,932 loops=1)

  • Merge Cond: ((own_fund_detail_2.factset_fund_id = adjh_1.factset_fund_id) AND (q4_fund_dates_1.report_date = adjh_1.report_date))
  • Join Filter: (adjh_1.fsym_id = sar_1.fsym_id)
38. 163.655 745.716 ↑ 2.1 83,932 1

Sort (cost=117,475.70..117,921.61 rows=178,365 width=46) (actual time=718.726..745.716 rows=83,932 loops=1)

  • Sort Key: own_fund_detail_2.factset_fund_id, q4_fund_dates_1.report_date DESC
  • Sort Method: quicksort Memory: 14873kB
39. 49.431 582.061 ↑ 2.1 83,932 1

Nested Loop (cost=76,608.56..101,918.29 rows=178,365 width=46) (actual time=357.301..582.061 rows=83,932 loops=1)

  • Join Filter: (own_fund_detail_2.factset_fund_id = q4_fund_dates_1.factset_fund_id)
40. 3.230 445.114 ↑ 1.6 6,732 1

Nested Loop (cost=76,608.13..77,181.65 rows=10,686 width=51) (actual time=357.272..445.114 rows=6,732 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.022..0.023 rows=1 loops=1)

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Fetches: 1
42. 7.334 441.861 ↑ 1.6 6,732 1

Hash Join (cost=76,607.71..77,066.35 rows=10,686 width=51) (actual time=357.246..441.861 rows=6,732 loops=1)

  • Hash Cond: (own_fund_detail_2.factset_fund_id = ent_1.factset_fund_id)
43. 37.958 368.983 ↑ 2.4 7,978 1

Unique (cost=71,911.06..72,004.89 rows=18,760 width=54) (actual time=291.256..368.983 rows=7,978 loops=1)

44. 243.246 331.025 ↓ 7.6 143,507 1

Sort (cost=71,911.06..71,957.98 rows=18,767 width=54) (actual time=291.255..331.025 rows=143,507 loops=1)

  • Sort Key: own_fund_detail_2.factset_fund_id
  • Sort Method: quicksort Memory: 17356kB
45. 70.712 87.779 ↓ 7.6 143,507 1

Bitmap Heap Scan on own_fund_detail own_fund_detail_2 (cost=442.01..70,578.98 rows=18,767 width=54) (actual time=19.195..87.779 rows=143,507 loops=1)

  • Recheck Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Blocks: exact=13470
46. 17.067 17.067 ↓ 7.7 144,938 1

Bitmap Index Scan on own_fund_detail_fsym_id_report_date_idx (cost=0.00..437.32 rows=18,767 width=0) (actual time=17.066..17.067 rows=144,938 loops=1)

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
47. 23.790 65.544 ↓ 1.0 68,142 1

Hash (cost=3,847.24..3,847.24 rows=67,953 width=9) (actual time=65.544..65.544 rows=68,142 loops=1)

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

Seq Scan on own_ent_funds ent_1 (cost=0.00..3,847.24 rows=67,953 width=9) (actual time=0.014..41.754 rows=68,142 loops=1)

  • Filter: (active_flag = 1)
  • Rows Removed by Filter: 51182
49. 87.516 87.516 ↑ 1.4 12 6,732

Index Only Scan using q4_fund_dates_pkey on q4_fund_dates q4_fund_dates_1 (cost=0.43..2.10 rows=17 width=13) (actual time=0.009..0.013 rows=12 loops=6,732)

  • Index Cond: ((factset_fund_id = ent_1.factset_fund_id) AND (report_date >= '2016-12-31'::date) AND (report_date <= '2018-12-31'::date))
  • Heap Fetches: 83932
50. 235.616 802.054 ↓ 7.6 143,507 1

Sort (cost=73,758.61..73,805.51 rows=18,760 width=30) (actual time=761.804..802.054 rows=143,507 loops=1)

  • Sort Key: adjh_1.factset_fund_id, adjh_1.report_date DESC
  • Sort Method: quicksort Memory: 17356kB
51. 66.795 566.438 ↓ 7.6 143,507 1

Subquery Scan on adjh_1 (cost=71,911.06..72,427.08 rows=18,760 width=30) (actual time=380.569..566.438 rows=143,507 loops=1)

52. 78.293 499.643 ↓ 7.6 143,507 1

Unique (cost=71,911.06..72,239.48 rows=18,760 width=54) (actual time=380.566..499.643 rows=143,507 loops=1)

53. 345.773 421.350 ↓ 7.6 143,507 1

Sort (cost=71,911.06..71,957.98 rows=18,767 width=54) (actual time=380.564..421.350 rows=143,507 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: 26319kB
54. 58.348 75.577 ↓ 7.6 143,507 1

Bitmap Heap Scan on own_fund_detail own_fund_detail_3 (cost=442.01..70,578.98 rows=18,767 width=54) (actual time=19.375..75.577 rows=143,507 loops=1)

  • Recheck Cond: (fsym_id = 'BHM9TN-S'::bpchar)
  • Heap Blocks: exact=13470
55. 17.229 17.229 ↓ 7.7 144,938 1

Bitmap Index Scan on own_fund_detail_fsym_id_report_date_idx (cost=0.00..437.32 rows=18,767 width=0) (actual time=17.229..17.229 rows=144,938 loops=1)

  • Index Cond: (fsym_id = 'BHM9TN-S'::bpchar)
56. 14.031 1,828.049 ↓ 8.7 6,619 1

Merge Left Join (cost=6,962.15..6,973.78 rows=765 width=112) (actual time=1,809.057..1,828.049 rows=6,619 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.194 1,796.497 ↓ 8.7 6,619 1

Sort (cost=3,481.08..3,482.99 rows=765 width=92) (actual time=1,794.050..1,796.497 rows=6,619 loops=1)

  • Sort Key: current_factset_fund_holdings.fsym_id, current_factset_fund_holdings.factset_fund_id
  • Sort Method: quicksort Memory: 710kB
58. 1,789.303 1,789.303 ↓ 8.7 6,619 1

CTE Scan on factset_fund_holdings current_factset_fund_holdings (cost=0.00..3,444.43 rows=765 width=92) (actual time=1,501.521..1,789.303 rows=6,619 loops=1)

  • Filter: (pos = 1)
  • Rows Removed by Filter: 70869
59. 7.248 17.521 ↓ 8.3 6,340 1

Sort (cost=3,481.08..3,482.99 rows=765 width=92) (actual time=15.002..17.521 rows=6,340 loops=1)

  • Sort Key: previous_factset_fund_holdings.fsym_id, previous_factset_fund_holdings.factset_fund_id
  • Sort Method: quicksort Memory: 688kB
60. 10.273 10.273 ↓ 8.3 6,340 1

CTE Scan on factset_fund_holdings previous_factset_fund_holdings (cost=0.00..3,444.43 rows=765 width=92) (actual time=0.006..10.273 rows=6,340 loops=1)

  • Filter: (pos = 2)
  • Rows Removed by Filter: 71148
61. 8.008 1,793.833 ↓ 7.4 6,564 1

Sort (cost=4,056.92..4,059.15 rows=892 width=88) (actual time=1,790.827..1,793.833 rows=6,564 loops=1)

  • Sort Key: factset_prev_fund_holdings.fsym_id, factset_prev_fund_holdings.factset_fund_id
  • Sort Method: quicksort Memory: 705kB
62. 1,785.825 1,785.825 ↓ 7.4 6,564 1

CTE Scan on factset_prev_fund_holdings (cost=0.00..4,013.21 rows=892 width=88) (actual time=1,480.559..1,785.825 rows=6,564 loops=1)

  • Filter: (pos = 1)
  • Rows Removed by Filter: 77368
63. 59.571 59.571 ↑ 1.0 1 6,619

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

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

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

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

66. 72.809 72.809 ↑ 1.0 1 6,619

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

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

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

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

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

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

Index Scan using cyclops_fund_overwrites_pkey on cyclops_fund_overwrites cyclops (cost=0.42..6.87 rows=1 width=26) (actual time=0.009..0.009 rows=1 loops=6,619)

  • Index Cond: (factset_fund_id = current_factset_fund_holdings.factset_fund_id)
70. 0.111 0.185 ↑ 1.0 270 1

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

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

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

72. 0.006 0.015 ↑ 1.0 8 1

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

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

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

74. 66.190 66.190 ↑ 1.0 1 6,619

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.009..0.010 rows=1 loops=6,619)

  • Index Cond: (factset_entity_id = inst_entity.factset_entity_id)
75. 0.067 0.122 ↑ 1.0 185 1

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

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

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

77. 0.011 0.021 ↑ 1.0 19 1

Hash (cost=1.19..1.19 rows=19 width=84) (actual time=0.021..0.021 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.006..0.010 rows=19 loops=1)

79. 52.952 52.952 ↑ 2.0 1 6,619

Index Scan using own_sec_prices_pkey on own_sec_prices prices (cost=0.57..11.31 rows=2 width=45) (actual time=0.008..0.008 rows=1 loops=6,619)

  • 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.713 1,277.467 ↑ 1.0 1 6,619

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

82. 29.969 1,098.754 ↓ 2.0 2 6,619

Nested Loop Left Join (cost=8.59..14.39 rows=1 width=138) (actual time=0.097..0.166 rows=2 loops=6,619)

83. 510.053 1,039.183 ↓ 2.0 2 6,619

Hash Right Join (cost=8.46..14.18 rows=1 width=72) (actual time=0.093..0.157 rows=2 loops=6,619)

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

Seq Scan on country_map country_map_1 (cost=0.00..4.70 rows=270 width=15) (actual time=0.002..0.065 rows=270 loops=6,613)

85. 19.857 99.285 ↓ 2.0 2 6,619

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

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

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.010..0.012 rows=2 loops=6,619)

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

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,801)

  • Index Cond: (region_code = country_map_1.region_code)