explain.depesz.com

PostgreSQL's explain analyze made readable

Result: N3EGs : WightedHoldingSector_BMK_75s_QA

Settings
# exclusive inclusive rows x rows loops node
1. 0.031 75,642.452 ↑ 1,617,892.1 13 1

Sort (cost=15,997,733,227.95..15,997,785,809.44 rows=21,032,597 width=288) (actual time=75,642.451..75,642.452 rows=13 loops=1)

  • Sort Key: (COALESCE(sum(securities.acctmv), '0'::double precision)) DESC
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=1,975,856 read=111, temp read=39 written=33
2.          

CTE accountholdingdate

3. 0.038 0.446 ↑ 96.0 1 1

GroupAggregate (cost=0.70..402.05 rows=96 width=27) (actual time=0.446..0.446 rows=1 loops=1)

  • Group Key: h.masterentityid, h.sourcecode
  • Buffers: shared hit=305
4. 0.408 0.408 ↓ 2.9 277 1

Index Only Scan using holding_pkey on holding h (cost=0.70..400.37 rows=96 width=27) (actual time=0.065..0.408 rows=277 loops=1)

  • Index Cond: ((effectivedate = '2020-07-31'::date) AND (masterentityid = '01CB0002XX'::text) AND (sourcecode = 'STARDIRECT'::text))
  • Heap Fetches: 277
  • Buffers: shared hit=305
5.          

CTE holdings

6. 0.058 8.354 ↑ 33.5 277 1

Nested Loop Left Join (cost=4.54..263,240.84 rows=9,266 width=86) (actual time=0.542..8.354 rows=277 loops=1)

  • Buffers: shared hit=3,237
7. 0.104 0.817 ↓ 2.0 277 1

Nested Loop (cost=0.70..3,704.61 rows=142 width=50) (actual time=0.474..0.817 rows=277 loops=1)

  • Buffers: shared hit=336
8. 0.448 0.448 ↑ 96.0 1 1

CTE Scan on accountholdingdate m (cost=0.00..1.92 rows=96 width=1,040) (actual time=0.447..0.448 rows=1 loops=1)

  • Buffers: shared hit=305
9. 0.265 0.265 ↓ 39.6 277 1

Index Scan using holding_pkey on holding h_1 (cost=0.70..38.50 rows=7 width=50) (actual time=0.023..0.265 rows=277 loops=1)

  • Index Cond: ((effectivedate = m.effectivedate) AND ((masterentityid)::text = (m.masterentityid)::text) AND ((sourcecode)::text = (m.sourcecode)::text))
  • Buffers: shared hit=31
10. 0.250 7.479 ↑ 65.0 1 277

Hash Left Join (cost=3.85..1,830.89 rows=65 width=40) (actual time=0.016..0.027 rows=1 loops=277)

  • Hash Cond: ((s.issuetypecode)::text = (cr.issuetypecode)::text)
  • Buffers: shared hit=2,901
11. 7.202 7.202 ↑ 65.0 1 277

Index Scan using ix_873765_securityreferencemaster on securityreferencemaster s (cost=0.56..1,827.16 rows=65 width=35) (actual time=0.016..0.026 rows=1 loops=277)

  • Index Cond: ((h_1.primaryissueid)::text = (primaryissueid)::text)
  • Filter: ((_seq = 1) AND (h_1.effectivedate >= _fromdate) AND (h_1.effectivedate <= _todate))
  • Rows Removed by Filter: 18
  • Buffers: shared hit=2,899
12. 0.010 0.027 ↑ 1.0 40 1

Hash (cost=2.78..2.78 rows=40 width=10) (actual time=0.026..0.027 rows=40 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=2
13. 0.017 0.017 ↑ 1.0 40 1

Seq Scan on securityglobalcashrule cr (cost=0.00..2.78 rows=40 width=10) (actual time=0.005..0.017 rows=40 loops=1)

  • Filter: ((_seq = 1) AND ((schemecode)::text = 'GLOBAL'::text))
  • Rows Removed by Filter: 12
  • Buffers: shared hit=2
14.          

CTE benchmark

15. 0.004 0.025 ↑ 17.0 1 1

Nested Loop (cost=0.41..736.24 rows=17 width=28) (actual time=0.024..0.025 rows=1 loops=1)

  • Buffers: shared hit=4
16. 0.001 0.001 ↑ 96.0 1 1

CTE Scan on accountholdingdate a (cost=0.00..1.92 rows=96 width=516) (actual time=0.001..0.001 rows=1 loops=1)

17. 0.020 0.020 ↑ 1.0 1 1

Index Scan using accountbenchmarkrelationship_pkey on accountbenchmarkrelationship abr (cost=0.41..7.64 rows=1 width=28) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: (((masterentityid)::text = (a.masterentityid)::text) AND ((segmentcode)::text = 'TF'::text) AND (benchmarkordinalnumber = 14))
  • Buffers: shared hit=4
18.          

CTE bmksources

19. 0.012 0.012 ↑ 33.3 3 1

Function Scan on unnest t (cost=0.00..1.25 rows=100 width=40) (actual time=0.010..0.012 rows=3 loops=1)

20.          

CTE bmksource

21. 0.740 9.690 ↑ 54,764.0 1 1

GroupAggregate (cost=170,342.81..171,438.09 rows=54,764 width=26) (actual time=9.689..9.690 rows=1 loops=1)

  • Group Key: h_2.accountbenchmarkid, h_2.effectivedate
  • Buffers: shared hit=5,604
22. 1.448 8.950 ↑ 9.7 5,666 1

Sort (cost=170,342.81..170,479.72 rows=54,764 width=26) (actual time=8.635..8.950 rows=5,666 loops=1)

  • Sort Key: h_2.accountbenchmarkid
  • Sort Method: quicksort Memory: 635kB
  • Buffers: shared hit=5,604
23. 1.170 7.502 ↑ 9.7 5,666 1

Hash Join (cost=3.82..166,032.62 rows=54,764 width=26) (actual time=0.129..7.502 rows=5,666 loops=1)

  • Hash Cond: ((h_2.sourcecode)::text = s_1.sourcecode)
  • Buffers: shared hit=5,604
24. 0.620 6.314 ↑ 9.7 5,666 1

Nested Loop (cost=0.57..165,276.37 rows=54,764 width=25) (actual time=0.104..6.314 rows=5,666 loops=1)

  • Buffers: shared hit=5,604
25. 0.027 0.027 ↑ 17.0 1 1

CTE Scan on benchmark b (cost=0.00..0.34 rows=17 width=516) (actual time=0.025..0.027 rows=1 loops=1)

  • Buffers: shared hit=4
26. 5.667 5.667 ↓ 1.8 5,666 1

Index Only Scan using benchmarkconstituents_pkey on benchmarkconstituents h_2 (cost=0.57..9,689.91 rows=3,221 width=25) (actual time=0.075..5.667 rows=5,666 loops=1)

  • Index Cond: ((effectivedate = '2020-07-31'::date) AND (accountbenchmarkid = (b.benchmarkid)::text))
  • Heap Fetches: 5,666
  • Buffers: shared hit=5,600
27. 0.004 0.018 ↑ 33.3 3 1

Hash (cost=2.00..2.00 rows=100 width=40) (actual time=0.018..0.018 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
28. 0.014 0.014 ↑ 33.3 3 1

CTE Scan on bmksources s_1 (cost=0.00..2.00 rows=100 width=40) (actual time=0.012..0.014 rows=3 loops=1)

29.          

CTE bmkholdingdate

30. 0.028 9.722 ↑ 27,382.0 1 1

Hash Join (cost=3.25..1,577.71 rows=27,382 width=556) (actual time=9.720..9.722 rows=1 loops=1)

  • Hash Cond: (b_1.sortorder = bs.sortorder)
  • Buffers: shared hit=5,607
31. 9.691 9.691 ↑ 54,764.0 1 1

CTE Scan on bmksource b_1 (cost=0.00..1,095.28 rows=54,764 width=532) (actual time=9.690..9.691 rows=1 loops=1)

  • Buffers: shared hit=5,604
32. 0.002 0.003 ↑ 33.3 3 1

Hash (cost=2.00..2.00 rows=100 width=40) (actual time=0.003..0.003 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
33. 0.001 0.001 ↑ 33.3 3 1

CTE Scan on bmksources bs (cost=0.00..2.00 rows=100 width=40) (actual time=0.001..0.001 rows=3 loops=1)

34.          

CTE bmkholdings

35. 1.570 189.273 ↑ 541.3 5,666 1

Hash Left Join (cost=4.41..9,379,085.75 rows=3,067,128 width=140) (actual time=9.822..189.273 rows=5,666 loops=1)

  • Hash Cond: ((s_2.issuetypecode)::text = (cr_1.issuetypecode)::text)
  • Buffers: shared hit=65,742
36. 13.375 187.679 ↑ 541.3 5,666 1

Nested Loop Left Join (cost=1.13..9,350,552.29 rows=3,067,128 width=59) (actual time=9.793..187.679 rows=5,666 loops=1)

  • Join Filter: ((b_2.effectivedate >= s_2._fromdate) AND (b_2.effectivedate <= s_2._todate))
  • Rows Removed by Join Filter: 116,934
  • Buffers: shared hit=65,740
37. 1.284 15.656 ↑ 8.3 5,666 1

Nested Loop (cost=0.57..8,351,144.79 rows=46,953 width=56) (actual time=9.758..15.656 rows=5,666 loops=1)

  • Buffers: shared hit=5,679
38. 9.723 9.723 ↑ 27,382.0 1 1

CTE Scan on bmkholdingdate b_2 (cost=0.00..547.64 rows=27,382 width=556) (actual time=9.721..9.723 rows=1 loops=1)

  • Buffers: shared hit=5,607
39. 4.649 4.649 ↓ 24.0 5,666 1

Index Scan using benchmarkconstituents_pkey on benchmarkconstituents c (cost=0.57..302.61 rows=236 width=48) (actual time=0.034..4.649 rows=5,666 loops=1)

  • Index Cond: ((effectivedate = b_2.effectivedate) AND ((accountbenchmarkid)::text = (b_2.accountbenchmarkid)::text) AND ((sourcecode)::text = b_2.sourcecode))
  • Buffers: shared hit=72
40. 158.648 158.648 ↑ 26.7 22 5,666

Index Scan using ix_873765_securityreferencemaster on securityreferencemaster s_2 (cost=0.56..12.47 rows=588 width=35) (actual time=0.010..0.028 rows=22 loops=5,666)

  • Index Cond: ((c.cadisissueid)::text = (primaryissueid)::text)
  • Filter: (_seq = 1)
  • Buffers: shared hit=60,061
41. 0.008 0.024 ↑ 1.0 40 1

Hash (cost=2.78..2.78 rows=40 width=10) (actual time=0.024..0.024 rows=40 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
  • Buffers: shared hit=2
42. 0.016 0.016 ↑ 1.0 40 1

Seq Scan on securityglobalcashrule cr_1 (cost=0.00..2.78 rows=40 width=10) (actual time=0.005..0.016 rows=40 loops=1)

  • Filter: ((_seq = 1) AND ((schemecode)::text = 'GLOBAL'::text))
  • Rows Removed by Filter: 12
  • Buffers: shared hit=2
43.          

CTE sectors

44. 2.678 75,599.328 ↑ 47.7 5,763 1

Unique (cost=13,940,594.10..13,947,465.20 rows=274,844 width=1,740) (actual time=75,596.256..75,599.328 rows=5,763 loops=1)

  • Buffers: shared hit=1,975,847 read=111
45. 21.628 75,596.650 ↑ 46.2 5,943 1

Sort (cost=13,940,594.10..13,941,281.21 rows=274,844 width=1,740) (actual time=75,596.255..75,596.650 rows=5,943 loops=1)

  • Sort Key: h_3.primaryissueid, ascm.sectorclassificationlevel2desc, ascm.sectorclassificationlevel2desc, (''::text), (''::text), (''::text), (''::text), (''::text), (''::text)
  • Sort Method: quicksort Memory: 662kB
  • Buffers: shared hit=1,975,847 read=111
46. 1.799 75,575.022 ↑ 46.2 5,943 1

Append (cost=0.57..13,500,545.35 rows=274,844 width=1,740) (actual time=0.568..75,575.022 rows=5,943 loops=1)

  • Buffers: shared hit=1,975,847 read=111
47. 0.151 12.546 ↑ 917.1 277 1

Nested Loop (cost=0.57..507,207.86 rows=254,032 width=734) (actual time=0.568..12.546 rows=277 loops=1)

  • Buffers: shared hit=4,682
48. 8.517 8.517 ↑ 33.5 277 1

CTE Scan on holdings h_3 (cost=0.00..185.32 rows=9,266 width=524) (actual time=0.543..8.517 rows=277 loops=1)

  • Buffers: shared hit=3,237
49. 3.878 3.878 ↑ 27.0 1 277

Index Scan using securityclassificationmaster_scdindex on securityclassificationmaster ascm (cost=0.57..54.45 rows=27 width=36) (actual time=0.014..0.014 rows=1 loops=277)

  • Index Cond: (((sourcecode)::text = 'EAGLE'::text) AND ((primaryissueid)::text = (h_3.primaryissueid)::text) AND ((sectorclassificationschemacode)::text = 'IVZ_FI'::text) AND (h_3.effectivedate >= _fromdate) AND (h_3.effectivedate <= _todate))
  • Buffers: shared hit=1,445
50. 13,001.410 75,560.677 ↑ 3.7 5,666 1

Merge Join (cost=2,813,459.51..12,990,589.05 rows=20,812 width=734) (actual time=197.846..75,560.677 rows=5,666 loops=1)

  • Merge Cond: (((bscm.sourcecode)::text = c_1.sectorsource) AND ((bscm.primaryissueid)::text = (c_1.cadisissueid)::text) AND ((bscm.sectorclassificationschemacode)::text = c_1.sectorscheme))
  • Join Filter: ((c_1.effectivedate >= bscm._fromdate) AND (c_1.effectivedate <= bscm._todate))
  • Rows Removed by Join Filter: 153,840
  • Buffers: shared hit=1,971,165 read=111
51. 62,348.646 62,348.646 ↑ 1.0 74,701,005 1

Index Scan using securityclassificationmaster_scdindex on securityclassificationmaster bscm (cost=0.57..9,573,421.81 rows=75,007,943 width=49) (actual time=0.023..62,348.646 rows=74,701,005 loops=1)

  • Buffers: shared hit=1,905,423 read=111
52. 12.097 210.621 ↑ 19.3 159,291 1

Materialize (cost=2,813,458.94..2,828,794.58 rows=3,067,128 width=588) (actual time=196.106..210.621 rows=159,291 loops=1)

  • Buffers: shared hit=65,742
53. 5.367 198.524 ↑ 541.3 5,666 1

Sort (cost=2,813,458.94..2,821,126.76 rows=3,067,128 width=588) (actual time=196.101..198.524 rows=5,666 loops=1)

  • Sort Key: c_1.sectorsource, c_1.cadisissueid, c_1.sectorscheme
  • Sort Method: quicksort Memory: 635kB
  • Buffers: shared hit=65,742
54. 193.157 193.157 ↑ 541.3 5,666 1

CTE Scan on bmkholdings c_1 (cost=0.00..61,342.56 rows=3,067,128 width=588) (actual time=9.824..193.157 rows=5,666 loops=1)

  • Buffers: shared hit=65,742
55.          

CTE securities

56. 1.864 75,628.339 ↑ 707,810.8 5,943 1

Unique (cost=15,577,066,927.16..15,734,811,402.34 rows=4,206,519,338 width=1,344) (actual time=75,626.069..75,628.339 rows=5,943 loops=1)

  • Buffers: shared hit=1,975,853 read=111, temp read=39 written=33
57. 5.101 75,626.475 ↑ 707,810.8 5,943 1

Sort (cost=15,577,066,927.16..15,587,583,225.51 rows=4,206,519,338 width=1,344) (actual time=75,626.068..75,626.475 rows=5,943 loops=1)

  • Sort Key: h_4.masterentityid, h_4.effectivedate, h_4.issueclass, sa.id, sa.level1code, sa.level1name, sa.level2code, sa.level2name, sa.level3code, sa.level3name, sa.level4code, sa.level4name, (CASE WHEN ((h_4.issueclass)::text = 'EQUITY'::text) THEN h_4.marketvaluebaseamount ELSE (h_4.marketvaluebaseamount + h_4.accruedincomenetbaseamount) END), (((0))::double precision)
  • Sort Method: quicksort Memory: 1,028kB
  • Buffers: shared hit=1,975,853 read=111, temp read=39 written=33
58. 0.608 75,621.374 ↑ 707,810.8 5,943 1

Append (cost=31,878,217.16..153,082,028.20 rows=4,206,519,338 width=1,344) (actual time=75,603.387..75,621.374 rows=5,943 loops=1)

  • Buffers: shared hit=1,975,850 read=111, temp read=39 written=33
59. 0.061 75,603.536 ↑ 45,741.5 277 1

Result (cost=31,878,217.16..32,511,737.16 rows=12,670,400 width=1,344) (actual time=75,603.387..75,603.536 rows=277 loops=1)

  • Buffers: shared hit=1,975,850 read=111, temp read=39 written=33
60. 0.072 75,603.475 ↑ 45,741.5 277 1

Unique (cost=31,878,217.16..32,353,357.16 rows=12,670,400 width=1,340) (actual time=75,603.385..75,603.475 rows=277 loops=1)

  • Buffers: shared hit=1,975,850 read=111, temp read=39 written=33
61. 0.892 75,603.403 ↑ 45,741.5 277 1

Sort (cost=31,878,217.16..31,909,893.16 rows=12,670,400 width=1,340) (actual time=75,603.385..75,603.403 rows=277 loops=1)

  • Sort Key: h_4.masterentityid, h_4.effectivedate, h_4.issueclass, sa.id, sa.level1code, sa.level1name, sa.level2code, sa.level2name, sa.level3code, sa.level3name, sa.level4code, sa.level4name, (CASE WHEN ((h_4.issueclass)::text = 'EQUITY'::text) THEN h_4.marketvaluebaseamount ELSE (h_4.marketvaluebaseamount + h_4.accruedincomenetbaseamount) END), (0)
  • Sort Method: quicksort Memory: 63kB
  • Buffers: shared hit=1,975,850 read=111, temp read=39 written=33
62. 0.032 75,602.511 ↑ 45,741.5 277 1

Append (cost=1,575.74..761,417.33 rows=12,670,400 width=1,340) (actual time=75,596.561..75,602.511 rows=277 loops=1)

  • Buffers: shared hit=1,975,847 read=111, temp read=39 written=33
63. 1.639 75,602.436 ↑ 46,073.8 275 1

Hash Join (cost=1,575.74..634,458.06 rows=12,670,308 width=2,308) (actual time=75,596.560..75,602.436 rows=275 loops=1)

  • Hash Cond: ((sa.id)::text = (h_4.primaryissueid)::text)
  • Buffers: shared hit=1,975,847 read=111, temp read=39 written=33
64. 75,600.590 75,600.590 ↑ 47.7 5,763 1

CTE Scan on sectors sa (cost=0.00..5,496.88 rows=274,844 width=1,740) (actual time=75,596.258..75,600.590 rows=5,763 loops=1)

  • Buffers: shared hit=1,975,847 read=111
65. 0.140 0.207 ↑ 33.5 275 1

Hash (cost=208.48..208.48 rows=9,220 width=1,088) (actual time=0.207..0.207 rows=275 loops=1)

  • Buckets: 4,096 Batches: 4 Memory Usage: 38kB
66. 0.067 0.067 ↑ 33.5 275 1

CTE Scan on holdings h_4 (cost=0.00..208.48 rows=9,220 width=1,088) (actual time=0.003..0.067 rows=275 loops=1)

  • Filter: ((issueclass)::text <> 'CASH'::text)
  • Rows Removed by Filter: 2
67. 0.043 0.043 ↑ 46.0 2 1

CTE Scan on holdings (cost=0.00..255.28 rows=92 width=1,340) (actual time=0.024..0.043 rows=2 loops=1)

  • Filter: (((issueclass)::text = 'CASH'::text) OR (((issueclass)::text = 'EQUITY'::text) AND (accruedincomenetbaseamount <> '0'::double precision)))
  • Rows Removed by Filter: 275
68. 0.846 16.626 ↑ 740,175.4 5,666 1

Subquery Scan on *SELECT* 3 (cost=5,161,661.21..120,501,088.96 rows=4,193,833,602 width=2,312) (actual time=8.525..16.626 rows=5,666 loops=1)

69. 5.729 15.780 ↑ 740,175.4 5,666 1

Merge Join (cost=5,161,661.21..68,078,168.94 rows=4,193,833,602 width=2,308) (actual time=8.523..15.780 rows=5,666 loops=1)

  • Merge Cond: ((sb.id)::text = (c_2.cadisissueid)::text)
70. 3.818 4.883 ↑ 47.7 5,763 1

Sort (cost=445,545.64..446,232.75 rows=274,844 width=1,740) (actual time=4.483..4.883 rows=5,763 loops=1)

  • Sort Key: sb.id
  • Sort Method: quicksort Memory: 648kB
71. 1.065 1.065 ↑ 47.7 5,763 1

CTE Scan on sectors sb (cost=0.00..5,496.88 rows=274,844 width=1,740) (actual time=0.001..1.065 rows=5,763 loops=1)

72. 0.726 5.168 ↑ 538.6 5,666 1

Materialize (cost=4,716,115.57..4,731,374.53 rows=3,051,792 width=1,080) (actual time=4.036..5.168 rows=5,666 loops=1)

73. 3.345 4.442 ↑ 538.6 5,666 1

Sort (cost=4,716,115.57..4,723,745.05 rows=3,051,792 width=1,080) (actual time=4.034..4.442 rows=5,666 loops=1)

  • Sort Key: c_2.cadisissueid
  • Sort Method: quicksort Memory: 635kB
74. 1.097 1.097 ↑ 538.6 5,666 1

CTE Scan on bmkholdings c_2 (cost=0.00..69,010.38 rows=3,051,792 width=1,080) (actual time=0.002..1.097 rows=5,666 loops=1)

  • Filter: ((issueclass)::text <> 'CASH'::text)
75. 0.000 0.604 ↓ 0.0 0 1

Subquery Scan on *SELECT* 4 (cost=0.00..69,202.08 rows=15,336 width=1,344) (actual time=0.604..0.604 rows=0 loops=1)

76. 0.604 0.604 ↓ 0.0 0 1

CTE Scan on bmkholdings c_3 (cost=0.00..69,010.38 rows=15,336 width=1,340) (actual time=0.604..0.604 rows=0 loops=1)

  • Filter: ((issueclass)::text = 'CASH'::text)
  • Rows Removed by Filter: 5,666
77.          

CTE totals

78. 1.151 4.797 ↑ 1.0 1 1

Aggregate (cost=115,679,281.80..115,679,281.81 rows=1 width=24) (actual time=4.796..4.797 rows=1 loops=1)

79. 3.646 3.646 ↑ 707,810.8 5,943 1

CTE Scan on securities securities_1 (cost=0.00..84,130,386.76 rows=4,206,519,338 width=24) (actual time=0.000..3.646 rows=5,943 loops=1)

80. 2.874 75,642.421 ↑ 1,617,892.1 13 1

GroupAggregate (cost=111,300,021.06..112,509,395.39 rows=21,032,597 width=288) (actual time=75,639.151..75,642.421 rows=13 loops=1)

  • Group Key: securities.level1code, securities.level1name, securities.level2code, securities.level2name, securities.level3code, securities.level3name, securities.level4code, securities.level4name
  • Buffers: shared hit=1,975,853 read=111, temp read=39 written=33
81. 6.202 75,639.547 ↑ 3,539.1 5,943 1

Sort (cost=111,300,021.06..111,352,602.55 rows=21,032,597 width=296) (actual time=75,639.137..75,639.547 rows=5,943 loops=1)

  • Sort Key: securities.level1code, securities.level1name, securities.level2code, securities.level2name, securities.level3code, securities.level3name, securities.level4code, securities.level4name
  • Sort Method: quicksort Memory: 1,028kB
  • Buffers: shared hit=1,975,853 read=111, temp read=39 written=33
82. 1.857 75,633.345 ↑ 3,539.1 5,943 1

Hash Join (cost=0.03..100,115,160.28 rows=21,032,597 width=296) (actual time=75,630.886..75,633.345 rows=5,943 loops=1)

  • Hash Cond: (securities.effectivedate = totals.datetot)
  • Buffers: shared hit=1,975,853 read=111, temp read=39 written=33
83. 75,626.687 75,626.687 ↑ 707,810.8 5,943 1

CTE Scan on securities (cost=0.00..84,130,386.76 rows=4,206,519,338 width=280) (actual time=75,626.071..75,626.687 rows=5,943 loops=1)

  • Buffers: shared hit=1,975,853 read=111, temp read=39 written=33
84. 0.003 4.801 ↑ 1.0 1 1

Hash (cost=0.02..0.02 rows=1 width=24) (actual time=4.801..4.801 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
85. 4.798 4.798 ↑ 1.0 1 1

CTE Scan on totals (cost=0.00..0.02 rows=1 width=24) (actual time=4.798..4.798 rows=1 loops=1)

Planning time : 4.365 ms
Execution time : 75,654.816 ms