explain.depesz.com

PostgreSQL's explain analyze made readable

Result: om4F : old

Settings
# exclusive inclusive rows x rows loops node
1. 44.145 6,113.482 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=403,063.20..441,876.29 rows=769 width=640) (actual time=4,051.422..6,113.482 rows=6,617 loops=1)

2. 6.688 4,606.980 ↓ 8.6 6,617 1

Hash Left Join (cost=403,062.63..422,050.23 rows=769 width=520) (actual time=4,051.150..4,606.980 rows=6,617 loops=1)

  • Hash Cond: (own_ent_funds.fund_type = fund_type_map.fund_type_code)
3. 7.093 4,600.272 ↓ 8.6 6,617 1

Hash Left Join (cost=403,061.20..422,038.23 rows=769 width=456) (actual time=4,051.121..4,600.272 rows=6,617 loops=1)

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

Nested Loop Left Join (cost=403,055.04..422,021.49 rows=769 width=440) (actual time=4,050.968..4,593.060 rows=6,617 loops=1)

5. 6.797 4,511.088 ↓ 8.6 6,617 1

Hash Left Join (cost=403,054.61..421,658.02 rows=769 width=445) (actual time=4,050.948..4,511.088 rows=6,617 loops=1)

  • Hash Cond: (country_map.region_code = region_map.region_code)
6. 7.627 4,504.278 ↓ 8.6 6,617 1

Hash Left Join (cost=403,053.43..421,646.27 rows=769 width=379) (actual time=4,050.929..4,504.278 rows=6,617 loops=1)

  • Hash Cond: (fund_entity.iso_country = country_map.iso_country)
7. 9.103 4,496.466 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=403,045.35..421,627.62 rows=769 width=367) (actual time=4,050.731..4,496.466 rows=6,617 loops=1)

8. 10.178 4,421.193 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=403,044.94..416,341.42 rows=769 width=326) (actual time=4,050.713..4,421.193 rows=6,617 loops=1)

9. 10.245 4,344.845 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=403,044.51..414,669.21 rows=769 width=307) (actual time=4,050.697..4,344.845 rows=6,617 loops=1)

10. 11.538 4,268.430 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=403,044.07..411,441.66 rows=769 width=276) (actual time=4,050.681..4,268.430 rows=6,617 loops=1)

11. 10.642 4,177.488 ↓ 8.6 6,617 1

Hash Left Join (cost=403,043.64..408,214.11 rows=769 width=239) (actual time=4,050.649..4,177.488 rows=6,617 loops=1)

  • Hash Cond: (current_factset_fund_holdings.factset_fund_id = q4_fund_values.factset_fund_id)
12. 8.617 4,117.553 ↓ 8.6 6,617 1

Nested Loop Left Join (cost=400,687.39..405,847.28 rows=769 width=223) (actual time=4,001.266..4,117.553 rows=6,617 loops=1)

13. 17.737 4,042.766 ↓ 8.6 6,617 1

Merge Left Join (cost=400,686.97..400,709.39 rows=769 width=192) (actual time=4,001.232..4,042.766 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. 76.470 2,174.794 ↑ 2.0 77,625 1

WindowAgg (cost=188,491.38..192,702.85 rows=153,788 width=46) (actual time=1,942.652..2,174.794 rows=77,625 loops=1)

16. 94.587 2,098.324 ↑ 2.0 77,625 1

Merge Left Join (cost=188,491.38..190,011.56 rows=153,788 width=54) (actual time=1,942.644..2,098.324 rows=77,625 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. 167.029 890.467 ↑ 2.0 77,625 1

Sort (cost=114,539.57..114,924.04 rows=153,788 width=46) (actual time=866.696..890.467 rows=77,625 loops=1)

  • Sort Key: own_fund_detail.factset_fund_id, q4_fund_dates.report_date DESC
  • Sort Method: quicksort Memory: 13973kB
18. 62.623 723.438 ↑ 2.0 77,625 1

Nested Loop (cost=77,017.22..101,290.29 rows=153,788 width=46) (actual time=386.437..723.438 rows=77,625 loops=1)

  • Join Filter: (own_fund_detail.factset_fund_id = q4_fund_dates.factset_fund_id)
19. 4.455 519.485 ↑ 1.6 6,730 1

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

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

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

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

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

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

23. 293.413 379.531 ↓ 7.6 143,529 1

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

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

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

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

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

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

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

Index Only Scan using q4_fund_dates_pkey on q4_fund_dates (cost=0.43..2.03 rows=14 width=13) (actual time=0.014..0.021 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))
  • Heap Fetches: 77625
29. 358.908 1,113.270 ↓ 7.6 143,529 1

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

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

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

31. 105.461 666.386 ↓ 7.6 143,529 1

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

32. 489.936 560.925 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=505.593..560.925 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.279 70.989 ↓ 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.863..70.989 rows=143,529 loops=1)

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

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

CTE factset_prev_fund_holdings

36. 87.430 1,714.379 ↑ 2.1 83,931 1

WindowAgg (cost=192,010.70..196,912.87 rows=179,250 width=46) (actual time=1,450.921..1,714.379 rows=83,931 loops=1)

37. 107.590 1,626.949 ↑ 2.1 83,931 1

Merge Left Join (cost=192,010.70..193,776.00 rows=179,250 width=54) (actual time=1,450.908..1,626.949 rows=83,931 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.182 736.308 ↑ 2.1 83,931 1

Sort (cost=118,058.89..118,507.01 rows=179,250 width=46) (actual time=709.230..736.308 rows=83,931 loops=1)

  • Sort Key: own_fund_detail_2.factset_fund_id, q4_fund_dates_1.report_date DESC
  • Sort Method: quicksort Memory: 14867kB
39. 44.929 573.126 ↑ 2.1 83,931 1

Nested Loop (cost=77,017.22..102,417.88 rows=179,250 width=46) (actual time=357.778..573.126 rows=83,931 loops=1)

  • Join Filter: (own_fund_detail_2.factset_fund_id = q4_fund_dates_1.factset_fund_id)
40. 2.903 440.707 ↑ 1.6 6,730 1

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

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

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

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

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

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

44. 247.146 331.601 ↓ 7.6 143,529 1

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

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

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

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

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

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

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

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,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))
  • Heap Fetches: 83931
50. 235.816 783.051 ↓ 7.6 143,529 1

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

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

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

52. 73.303 486.636 ↓ 7.6 143,529 1

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

53. 341.525 413.333 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=375.204..413.333 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. 54.405 71.808 ↓ 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=19.562..71.808 rows=143,529 loops=1)

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

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

Merge Left Join (cost=6,994.18..7,005.87 rows=769 width=112) (actual time=2,234.836..2,255.540 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. 6.984 2,223.039 ↓ 8.6 6,617 1

Sort (cost=3,497.09..3,499.01 rows=769 width=92) (actual time=2,220.485..2,223.039 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,216.055 2,216.055 ↓ 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,942.658..2,216.055 rows=6,617 loops=1)

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

Sort (cost=3,497.09..3,499.01 rows=769 width=92) (actual time=14.345..16.994 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.036 10.036 ↓ 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.005..10.036 rows=6,338 loops=1)

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

Sort (cost=4,077.06..4,079.30 rows=896 width=88) (actual time=1,766.389..1,769.489 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. 1,761.683 1,761.683 ↓ 7.3 6,562 1

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

  • Filter: (pos = 1)
  • Rows Removed by Filter: 77369
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.009..0.010 rows=1 loops=6,617)

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

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

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

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

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

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

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

  • Index Cond: (factset_fund_id = current_factset_fund_holdings.factset_fund_id)
70. 0.100 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.085 0.085 ↑ 1.0 270 1

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

72. 0.005 0.013 ↑ 1.0 8 1

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

74. 72.787 72.787 ↑ 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.010..0.011 rows=1 loops=6,617)

  • Index Cond: (factset_entity_id = inst_entity.factset_entity_id)
75. 0.056 0.119 ↑ 1.0 185 1

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

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

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

77. 0.007 0.020 ↑ 1.0 19 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
78. 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.004..0.013 rows=19 loops=1)

79. 59.553 59.553 ↑ 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.009..0.009 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. 211.744 1,402.804 ↑ 1.0 1 6,617

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

82. 29.959 1,191.060 ↓ 2.0 2 6,617

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

83. 562.865 1,131.507 ↓ 2.0 2 6,617

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

  • Hash Cond: (country_map_1.iso_country = ent_entity_address.iso_country)
84. 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)

85. 19.851 105.872 ↓ 2.0 2 6,617

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
86. 86.021 86.021 ↓ 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.011..0.013 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 : 4.492 ms
Execution time : 6,117.626 ms