explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yzzC

Settings
# exclusive inclusive rows x rows loops node
1. 44.563 6,202.504 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=396,113.60..412,799.32 rows=256 width=640) (actual time=3,642.458..6,202.504 rows=6,617 loops=1)

2. 7.169 4,655.882 ↓ 25.8 6,617 1

Hash Left Join (cost=396,113.03..406,185.66 rows=256 width=520) (actual time=3,642.126..4,655.882 rows=6,617 loops=1)

  • Hash Cond: (own_ent_funds.fund_type = fund_type_map.fund_type_code)
3. 7.225 4,648.689 ↓ 25.8 6,617 1

Hash Left Join (cost=396,111.61..406,180.71 rows=256 width=456) (actual time=3,642.088..4,648.689 rows=6,617 loops=1)

  • Hash Cond: (ent_entity_metro_areas.metro_id = metro_map.metro_code)
4. 12.009 4,641.336 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=396,105.44..406,171.03 rows=256 width=440) (actual time=3,641.925..4,641.336 rows=6,617 loops=1)

5. 6.833 4,549.923 ↓ 25.8 6,617 1

Hash Left Join (cost=396,105.01..406,050.03 rows=256 width=445) (actual time=3,641.897..4,549.923 rows=6,617 loops=1)

  • Hash Cond: (country_map.region_code = region_map.region_code)
6. 8.173 4,543.074 ↓ 25.8 6,617 1

Hash Left Join (cost=396,103.83..406,045.33 rows=256 width=379) (actual time=3,641.866..4,543.074 rows=6,617 loops=1)

  • Hash Cond: (fund_entity.iso_country = country_map.iso_country)
7. 12.992 4,534.718 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=396,095.76..406,033.74 rows=256 width=367) (actual time=3,641.670..4,534.718 rows=6,617 loops=1)

8. 10.133 4,448.939 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=396,095.34..404,031.82 rows=256 width=326) (actual time=3,641.640..4,448.939 rows=6,617 loops=1)

9. 11.231 4,366.019 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=396,094.91..403,475.14 rows=256 width=307) (actual time=3,641.612..4,366.019 rows=6,617 loops=1)

10. 13.296 4,282.001 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=396,094.48..402,400.69 rows=256 width=276) (actual time=3,641.585..4,282.001 rows=6,617 loops=1)

11. 8.319 4,176.067 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=396,094.05..401,326.24 rows=256 width=239) (actual time=3,641.559..4,176.067 rows=6,617 loops=1)

12. 13.521 4,101.578 ↓ 25.8 6,617 1

Nested Loop Left Join (cost=396,093.63..399,460.96 rows=256 width=223) (actual time=3,641.525..4,101.578 rows=6,617 loops=1)

13. 11.492 4,021.887 ↓ 25.8 6,617 1

Hash Left Join (cost=396,093.21..397,476.48 rows=256 width=192) (actual time=3,641.486..4,021.887 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))
14.          

CTE factset_fund_holdings

15. 25.084 1,973.272 ↑ 4.0 12,955 1

Subquery Scan on h (cost=188,491.38..194,625.20 rows=51,263 width=46) (actual time=1,661.115..1,973.272 rows=12,955 loops=1)

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

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

17. 118.297 1,851.400 ↑ 2.0 77,625 1

Merge Left Join (cost=188,491.38..190,011.56 rows=153,788 width=54) (actual time=1,661.107..1,851.400 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)
18. 156.098 763.945 ↑ 2.0 77,625 1

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

  • Sort Key: own_fund_detail.factset_fund_id, q4_fund_dates.report_date DESC
  • Sort Method: quicksort Memory: 13973kB
19. 42.836 607.847 ↑ 2.0 77,625 1

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

  • Join Filter: (own_fund_detail.factset_fund_id = q4_fund_dates.factset_fund_id)
20. 2.939 464.061 ↑ 1.6 6,730 1

Nested Loop (cost=77,016.79..77,592.30 rows=10,739 width=51) (actual time=382.158..464.061 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. 7.177 461.084 ↑ 1.6 6,730 1

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

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

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

24. 248.192 347.498 ↓ 7.6 143,529 1

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

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

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

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

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

  • Buckets: 131072 Batches: 1 Memory Usage: 3753kB
28. 48.777 48.777 ↓ 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..48.777 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 (cost=0.43..2.03 rows=14 width=13) (actual time=0.011..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))
  • Heap Fetches: 77625
30. 278.974 969.158 ↓ 7.6 143,529 1

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

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

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

32. 104.243 602.799 ↓ 7.6 143,529 1

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

33. 392.965 498.556 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=444.539..498.556 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. 86.174 105.591 ↓ 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=22.347..105.591 rows=143,529 loops=1)

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

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

CTE factset_prev_fund_holdings

37. 27.144 1,993.366 ↑ 4.6 12,961 1

Subquery Scan on p (cost=192,010.70..199,153.50 rows=59,750 width=46) (actual time=1,647.835..1,993.366 rows=12,961 loops=1)

  • Filter: (p.pos <= 2)
  • Rows Removed by Filter: 70970
38. 107.308 1,966.222 ↑ 2.1 83,931 1

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

39. 124.285 1,858.914 ↑ 2.1 83,931 1

Merge Left Join (cost=192,010.70..193,776.00 rows=179,250 width=54) (actual time=1,647.819..1,858.914 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)
40. 166.554 938.679 ↑ 2.1 83,931 1

Sort (cost=118,058.89..118,507.01 rows=179,250 width=46) (actual time=906.106..938.679 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
41. 43.362 772.125 ↑ 2.1 83,931 1

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

  • Join Filter: (own_fund_detail_2.factset_fund_id = q4_fund_dates_1.factset_fund_id)
42. 2.919 641.273 ↑ 1.6 6,730 1

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

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

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

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

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

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

46. 365.575 503.973 ↓ 7.6 143,529 1

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

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

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

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

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

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

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

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

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

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

54. 72.923 483.635 ↓ 7.6 143,529 1

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

55. 341.259 410.712 ↓ 7.6 143,529 1

Sort (cost=72,099.09..72,146.13 rows=18,816 width=54) (actual time=372.417..410.712 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.449 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=19.158..69.453 rows=143,529 loops=1)

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

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

Hash Right Join (cost=1,157.26..2,522.58 rows=256 width=108) (actual time=3,635.778..4,004.706 rows=6,617 loops=1)

  • Hash Cond: ((factset_prev_fund_holdings.factset_fund_id = current_factset_fund_holdings.factset_fund_id) AND (factset_prev_fund_holdings.fsym_id = current_factset_fund_holdings.fsym_id))
59. 2,006.563 2,006.563 ↓ 21.9 6,562 1

CTE Scan on factset_prev_fund_holdings (cost=0.00..1,344.38 rows=299 width=88) (actual time=1,647.840..2,006.563 rows=6,562 loops=1)

  • Filter: (pos = 1)
  • Rows Removed by Filter: 6399
60. 3.792 1,987.918 ↓ 25.8 6,617 1

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

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 530kB
61. 1,984.126 1,984.126 ↓ 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,661.124..1,984.126 rows=6,617 loops=1)

  • Filter: (pos = 1)
  • Rows Removed by Filter: 6338
62. 2.461 5.689 ↓ 24.8 6,338 1

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

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

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

  • Index Cond: (current_factset_fund_holdings.factset_fund_id = factset_fund_id)
65. 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)
66. 92.638 92.638 ↑ 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.014..0.014 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.010..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..7.81 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.101 0.183 ↑ 1.0 270 1

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

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

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

72. 0.005 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.011 0.011 ↑ 1.0 8 1

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

74. 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.012..0.012 rows=1 loops=6,617)

  • Index Cond: (factset_entity_id = inst_entity.factset_entity_id)
75. 0.064 0.128 ↑ 1.0 185 1

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

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

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

77. 0.009 0.024 ↑ 1.0 19 1

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

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

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

79. 72.787 72.787 ↑ 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.011..0.011 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,429.272 ↑ 1.0 1 6,617

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

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

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

83. 562.871 1,144.741 ↓ 2.0 2 6,617

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

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

85. 19.851 112.489 ↓ 2.0 2 6,617

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
86. 92.638 92.638 ↓ 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.012..0.014 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 : 7.431 ms
Execution time : 6,214.165 ms