explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LF5q

Settings
# exclusive inclusive rows x rows loops node
1. 1.709 15,098.623 ↓ 2.5 10 1

Limit (cost=83,433.32..83,433.32 rows=4 width=488) (actual time=15,096.915..15,098.623 rows=10 loops=1)

2. 11.409 15,096.914 ↓ 2.5 10 1

Sort (cost=83,433.32..83,433.32 rows=4 width=488) (actual time=15,096.914..15,096.914 rows=10 loops=1)

  • Sort Key: (count(*) OVER (?))
  • Sort Method: top-N heapsort Memory: 27kB
3. 25.411 15,085.505 ↓ 10,702.0 42,808 1

WindowAgg (cost=83,433.26..83,433.31 rows=4 width=488) (actual time=15,075.583..15,085.505 rows=42,808 loops=1)

4. 17.653 15,060.094 ↓ 10,702.0 42,808 1

Unique (cost=83,433.26..83,433.28 rows=4 width=480) (actual time=15,037.131..15,060.094 rows=42,808 loops=1)

5. 223.429 15,042.441 ↓ 11,011.5 44,046 1

Sort (cost=83,433.26..83,433.27 rows=4 width=480) (actual time=15,037.130..15,042.441 rows=44,046 loops=1)

  • Sort Key: maintenance_impact__c.account__c, "case".casenumber, maintenance_impact__c.service__c, s.name, maintenance_impact__c.circuit_id__c, maintenance_impact__c.expected_impact__c, maintenance_impact__c.a_location_clli__c, maintenance_impact__c.z_location_clli__c, (CASE WHEN (maintenance_impact__c.service_component__c IS NOT NULL) THEN sc.legacy_circuit_id__c WHEN (maintenance_impact__c.service__c IS NOT NULL) THEN s.legacy_circuit_id__c ELSE NULL::character varying END)
  • Sort Method: quicksort Memory: 13234kB
6. 4.052 14,819.012 ↓ 11,011.5 44,046 1

Append (cost=1,261.90..83,433.26 rows=4 width=480) (actual time=230.756..14,819.012 rows=44,046 loops=1)

7. 10.047 14,814.216 ↓ 22,023.0 44,046 1

Gather (cost=1,261.90..70,164.48 rows=2 width=149) (actual time=230.755..14,814.216 rows=44,046 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
8. 1,122.938 14,804.169 ↓ 22,023.0 22,023 2

Nested Loop Left Join (cost=261.90..69,164.28 rows=1 width=149) (actual time=222.087..14,804.169 rows=22,023 loops=2)

9. 614.967 13,681.182 ↓ 22,023.0 22,023 2

Nested Loop Left Join (cost=261.82..69,161.16 rows=1 width=149) (actual time=220.803..13,681.182 rows=22,023 loops=2)

10. 18.118 13,066.188 ↓ 22,023.0 22,023 2

Hash Join (cost=261.73..69,158.42 rows=1 width=129) (actual time=220.112..13,066.188 rows=22,023 loops=2)

  • Hash Cond: ((maintenance_impact__c.case__c)::text = ("case".sfid)::text)
11. 12,846.771 12,974.897 ↓ 8.8 30,656 2

Parallel Bitmap Heap Scan on maintenance_impact__c (cost=156.28..69,051.14 rows=3,486 width=133) (actual time=146.890..12,974.897 rows=30,656 loops=2)

  • Recheck Cond: ((((((((upper((expected_impact__c)::text) || ' '::text) || upper((a_location_clli__c)::text)) || ' '::text) || upper((z_location_clli__c)::text)) || ' '::text) || upper((circuit_id__c)::text)) ~~ '%ZYO%'::text) AND ((expected_impact__c)::text <> 'Remove'::text) AND (NOT isdeleted) AND ((account__c IS NOT NULL) OR (corrected_account_name__c IS NOT NULL)))
  • Filter: ((account__c)::text = ANY ('{0016000001EYimkAAD,0016000001EYimJAAT,0016000001EYycmAAD,0016000001Lg8R6AAJ,0016000001JQLUfAAP,0016000001EYidXAAT,0016000001EYidZAAT,0016000001EYidYAAT,0016000001EYizxAAD,0016000001Cs2cJAAR,0016000001Cs2Z8AAJ,0016000001Cs2KfAAJ,0016000001MeTaWAAV,0016000001K5zbCAAR,0016000001CqwZSAAZ,0016000001CqwdlAAB,0016000001CqwbyAAB,00160000018pQDoAAM,00160000018pQDKAA2,00160000018pQBiAAM,00160000018pQ20AAE,00160000018pQ1CAAU,00160000018pQ17AAE,00160000018pQ0sAAE,00160000018pPzfAAE,00160000018pPxyAAE,00160000018mMewAAE,00160000018mMevAAE,00160000018mfsWAAQ,0016000001Cr4lPAAR,0016000001CqwgBAAR,0016000001B8tzLAAR,00160000018pxpzAAA,00160000018pQC2AAM,00160000018pQAGAA2,00160000018pQ9hAAE,00160000018pQ7QAAU,00160000018pQ2FAAU,00160000018pQ1qAAE,00160000018pPzGAAU,00160000018mMetAAE,00160000018mMesAAE,00160000018mMerAAE,00160000018pQ7GAAU,0016000001NhzrmAAB,00160000018mMeEAAU,00160000018mMeuAAE,0016000001CrYbiAAF,0016000001CrYbdAAF,00160000018mMeFAAU,00160000017Pn8cAAC,0016000001Ea06qAAB,0016000001K6XAMAA3,00160000016UbpWAAS,00160000016UbpRAAS,00160000016UbpMAAS,00160000016UbpCAAS,00160000018q8wDAAQ,00160000018pASXAA2,00160000016Ubp2AAC,00160000016UbonAAC,00160000015Zq5vAAC,0016000000zmpYtAAI,0016000000zmJwjAAE,0016000000zmJtRAAU,0016000000sesfGAAQ,0016000000seshpAAA,0016000001B9xxEAAR,00160000018pECyAAM,00160000018pbQwAAI,00160000018pbQmAAI,00160000018pbQcAAI,00160000018pbQXAAY,00160000018pbQSAAY,00160000018pbO7AAI,00160000018pRr4AAE,00160000018pRqzAAE,00160000018pPLLAA2,00160000018pF5SAAU,00160000018pCqbAAE,0016000000un1LhAAI,0016000000umU7OAAU,0016000000uC4dMAAS,0016000000oEOtWAAW,0016000000mppvCAAQ,0016000000tfpY5AAI,0016000000scJUXAA2,0016000000jzI1SAAU,0016000000jzI1RAAU,0016000000kpWk1AAE,0016000000iqgnfAAA,0016000000iqgohAAA,0016000000oEvJIAA0,0016000000inHEfAAM,0016000000inGIEAA2,0016000000inGXUAA2,0016000000konuWAAQ,0016000001CrKkSAAV,0016000000wjoelAAA,0016000000iq2DMAAY,0010z00001UjqaMAAR,0016000000orcoYAAQ,0016000000sc30rAAA,0016000000mppuYAAQ,0016000000QSd6aAAD,0010z00001Rkkw1AAB,0016000000ooKoAAAU,0016000000iq283AAA,0016000000iq1wqAAA,0016000000inGylAAE,0016000000eYHRjAAO,0016000000eYHRiAAO,0016000000eYHRgAAO,0016000000eYHR5AAO,0016000000eYHR3AAO,0016000000eYHPrAAO,0016000000eYHPqAAO,0016000000eYHPpAAO,0016000000eYHPoAAO,0016000000QSdAmAAL,0016000000MDYSDAA5,0016000000LZvwSAAT,0016000000KLntaAAD,0016000000KLnoJAAT,0016000000KLnn0AAD,0016000000KLnlYAAT,0016000000KLnjeAAD,0016000000KLnjNAAT,0010z00001Oz4XVAAZ,0016000000z2CRzAAM,0016000000yHj3eAAC,0016000000sblX6AAI,0016000001EZXlNAAX,0016000001B9pQZAAZ,0016000000sblXtAAI,0016000000sblXoAAI,0016000000sblXjAAI,0016000000sblXeAAI,0016000000sblSWAAY,0016000000r9OhIAAU,0016000000os6TdAAI,0016000000oDKteAAG,0016000000oDKtPAAW,0016000000mpprtAAA,0016000000mppgXAAQ,0016000000lyNU7AAM,0016000000ly7mwAAA,0016000000inGykAAE,0016000000eYHRhAAO,0016000000eYHR7AAO,0016000000eYHR6AAO,0016000000djsiGAAQ,0016000000QSdFsAAL,0016000000QSdFpAAL,0016000000QSdAuAAL,0016000000QSdApAAL,0016000000QSdAoAAL,0016000000QSdAnAAL,0016000000QSdAlAAL,0016000000QSd74AAD,0016000000QSd73AAD,0016000000QSd72AAD,0016000000Q13ExAAJ,0016000000MDYTzAAP,0016000000MDYTxAAP,0016000000MDYTrAAP,0016000000MDYSEAA5,0016000000LZvvFAAT,0016000000LBhQhAAL,0016000000Kr7yyAAB,0016000000KqG39AAF,0016000000KLnmlAAD,0016000000KLnkrAAD,0016000000yKequAAC,0016000000yIAQuAAO,0016000000yHfkbAAC,0016000000yHfhDAAS,0016000000xbtZEAAY,0016000000xbtJLAAY,0016000000sblXyAAI,0010z00001QJKrKAAX,0016000000WJkTCAA1,0016000000WJfNKAA1,0016000000NxBcHAAV,0016000000NxBb0AAF,0016000000NxBXNAA3,0016000000MDYTyAAP,0010z00001Qh7h8AAB,0010z00001NctC1AAJ,0016000000NxBbhAAF,0016000000zoP3UAAU,0016000000VOjfCAAT,0016000000MDYU0AAP,0016000000kpYqEAAU,0016000000coPNjAAM,0016000001EZBCiAAP,0016000001B8vjDAAR,00160000018pknCAAQ,00160000018nyX2AAI,00160000017Ph8fAAC,00160000014F2fUAAS,00160000013GVBjAAO,0016000000zoCf1AAE,0016000000znG9EAAU,0016000000z4sunAAA,0016000000z1pkoAAA,0016000000xfldzAAA,0016000001EZNytAAH,0016000001EZNyUAAX,0016000001EZNyPAAX,0016000001EZNxqAAH,0016000001EZNwOAAX,0016000001EZNvQAAX,0016000001EZNuwAAH,0016000001EZNuDAAX,0016000001EZNtUAAX,0016000001EZNiqAAH,0016000001EZNB7AAP,0016000001EZN7KAAX,0016000001EZMxxAAH,0016000001EZMrOAAX,0016000001EZMqkAAH,0016000001EZLRRAA5,0016000001EZLPoAAP,0016000001EZLKKAA5,0016000001EZLDwAAP,0016000001EZL9PAAX,0016000001EZ3SBAA1,0016000001EZ3OsAAL,0016000001EZ107AAD,0016000001EYxEUAA1,0016000001EYxDWAA1,0016000001EYuoIAAT,0016000001CrehsAAB,0016000001CrdywAAB,0016000001CrdgZAAR,0016000001Crb3VAAR,0016000001Crb3QAAR,0016000001Crb31AAB,0016000001Crb2cAAB,0016000001Crb2SAAR,0016000001CrapJAAR,0016000001CrYT5AAN,0016000001CrYSgAAN,0016000001CrYHmAAN,0016000001CrXt2AAF,0016000001CrVGgAAN,0016000001CrUabAAF,0016000001CrShIAAV,0016000001CrShDAAV,0016000001CrSh8AAF,0016000001CrSf2AAF,0016000001CrSZOAA3,0016000001CrSWXAA3,0016000001CrSQoAAN,0016000001CrSFFAA3,0016000001CrSD9AAN,0016000001CrSC6AAN,0016000001CrRtdAAF,0016000001CrP4JAAV,0016000001CrMFZAA3,0016000001CrMDEAA3,0016000001CrKlkAAF,0016000001CrKDoAAN,0016000001CrJjTAAV,0016000001CrJHXAA3,0016000001CrJHNAA3,0016000001CrJH8AAN,0016000001CrGUsAAN,0016000001CrFFJAA3,0016000001CrFCPAA3,0016000001CrFBMAA3,0016000001CrFAnAAN,0016000001CrFA4AAN,0016000001CrF9VAAV,0016000001CrF8VAAV,0016000001CrEtkAAF,0016000001CrDaKAAV,0016000001CrDWwAAN,0016000001CrDWSAA3,0016000001Cr8BxAAJ,0016000001Cr7wrAAB,0016000001Cr7k5AAB,0016000001Cr6YjAAJ,0016000001Cr6ObAAJ,0016000001Cr5ZQAAZ,0016000001Cr2BOAAZ,0016000001BA97WAAT,0016000001BA74KAAT,0016000001BA74FAAT,0016000001BA74AAAT,0016000001BA745AAD,0016000001BA740AAD,0016000001BA73qAAD,0016000001BA73lAAD,0016000001BA6aGAAT,0016000001BA6ZwAAL,0016000001BA3YcAAL,0016000001BA3WqAAL,0016000001BA2d5AAD,0016000001BA19cAAD,0016000001BA19XAAT,0016000001B9yyaAAB,0016000001B9ynHAAR,0016000001B9xOwAAJ,0016000001B9xOrAAJ,0016000001B9wnIAAR,0016000001B9wnDAAR,0016000001B9wn3AAB,0016000001B9wmyAAB,0016000001B9r4CAAR,0016000001B9nMtAAJ,0016000001B9m92AAB,0016000001B9hJIAAZ,0016000001B9ZtnAAF,0016000001B9Zn1AAF,0016000001B9Zd5AAF,0016000001B9ZcWAAV,0016000001B9ZcRAAV,0016000001B9ZcMAAV,0016000001B9ZcHAAV,0016000001B9ZcCAAV,0016000001B9Zc7AAF,0016000001B9VazAAF,0016000001B9TpPAAV,0016000001B9NaCAAV,0016000001B9MIBAA3,0016000001B9MHrAAN,0016000001B9JvuAAF,0016000001B9JvfAAF,0016000001B9JvVAAV,0016000001B9JvLAAV,0016000001B9JvGAAV,0016000001B9Jv6AAF,0016000001B9JurAAF,0016000001B9FiDAAV,0016000001B9FgbAAF,0016000001B9FfxAAF,0016000001B9FfOAAV,0016000001B9FeVAAV,0016000001B9FZuAAN,0016000001B9FVEAA3,0016000001B9FUfAAN,0016000001B9FTSAA3,0016000001B9Dq4AAF,0016000001B9AtJAAV,0016000001B96kiAAB,0016000001B96kTAAR,0016000001B96kJAAR,00160000015Z3u5AAC,00160000015Z3u0AAC,00160000015Z3tvAAC,00160000015Z3tgAAC,00160000015Z3tWAAS,00160000015Z3tRAAS,00160000015Z3tMAAS,00160000015Z3tHAAS,00160000015Z3t7AAC,00160000015Z3t2AAC,00160000015Z3sxAAC,00160000015Z3snAAC,00160000015Z3sjAAC,00160000015Z3siAAC,00160000015Z3sdAAC,00160000015Z3sYAAS,00160000015Z3sTAAS,00160000015Z3sOAAS,00160000015Z3sJAAS,00160000015XOfVAAW,00160000015XObYAAW,00160000015XOW4AAO,00160000015XOUmAAO,00160000015XOSqAAO,00160000015XGfGAAW,00160000015XGMiAAO,00160000015XCtPAAW,00160000015XCkbAAG,00160000015XAq0AAG,00160000015X91gAAC,00160000015X8qRAAS,00160000015WqMCAA0,00160000014yVEMAA2,00160000014xCtMAAU,001600000142XMhAAM,001600000142XMDAA2,0016000001EYteHAAT,0016000001EYptIAAT,0016000001EYpt8AAD,0016000001EYphqAAD,0016000001EYmhmAAD,0016000001EYkgKAAT,0016000001EYkesAAD,0016000001EYWF7AAP,0016000001EYWCrAAP,0016000001EYUYpAAP,0016000001EYU54AAH,0016000001EYU4aAAH,0016000001EYTvcAAH,0016000001EYRVKAA5,0016000001EYRURAA5,0016000001EYLjrAAH,0016000001EYLjhAAH,0016000001EYLjXAAX,0016000001EYLj3AAH,0016000001EYLiZAAX,0016000001EYLi5AAH,0016000001EYLhbAAH,0016000001EYDAUAA5,0016000001EYC0KAAX,0016000001EYBzqAAH,0016000001EYBIOAA5,0016000001EYBIJAA5,0016000001EYBI9AAP,0016000001EYBI4AAP,0016000001EYBHuAAP,0016000001EYBHkAAP,0016000001EYBHaAAP,0016000001EY7pZAAT,0016000001EY7pUAAT,0016000001EY51QAAT,0016000001EY50wAAD,0016000001EXq14AAD,0016000001CsKCrAAN,0016000001CsKBKAA3,0016000001CsIUXAA3,0016000001CsIUDAA3,0016000001CsISgAAN,0016000001CsHldAAF,0016000001CsECUAA3,0016000001CsDr4AAF,0016000001CsDonAAF,0016000001Cs4loAAB,0016000001CryfQAAR,0016000001CryeqAAB,0016000001CryegAAB,0016000001CryeDAAR,0016000001CryMYAAZ,0016000001CryIlAAJ,0016000001Cry2jAAB,0016000001Crxp6AAB,0016000001CrwrAAAR,0016000001Cruv3AAB,0016000001CrushAAB,0016000001CrusIAAR,0016000001Crur5AAB,0016000001CrqUQAAZ,0016000001CrqU6AAJ,0016000001Crpb8AAB,0016000001CrobDAAR,0016000001CroZcAAJ,0016000001CroZNAAZ,0016000001CroZDAAZ,0016000001CrlPSAAZ,0016000001CrlKwAAJ,0016000001Crl9AAAR,0016000001Crh5nAAB,0016000001Crh5YAAR,0016000001Crh5JAAR,0016000001Crh54AAB,0016000001CrfECAAZ,0016000001CrfE7AAJ,0016000001CrfDxAAJ,0016000001CrfDnAAJ,0016000001CrfDdAAJ,0016000001CrfDTAAZ,0016000001CrfDJAAZ,0016000001CrfD9AAJ,0016000001CrfD4AAJ,001600000142XKHAA2,001600000142WkOAAU,001600000142WihAAE,00160000013HxAtAAK,00160000013HnpKAAS,00160000013G1qqAAC,00160000013G1p4AAC,00160000013FmBRAA0,00160000013FTNvAAO,00160000013F8lJAAS,00160000011jSW6AAM,00160000011ihotAAA,00160000011ihoKAAQ,00160000011haGnAAI,00160000011hWIqAAM,00160000010xy1nAAA,0016000000znHz4AAE,0016000000zmoa5AAA,0016000000wmBOwAAM,0016000000wEDyuAAG,0016000000uCgtKAAS,0016000000rx9TtAAI,0016000000rx9TsAAI,0016000000r8e1pAAA,0016000000qCimSAAS,0016000000mpK75AAE,0016000000mpK33AAE,0016000000m0BltAAE,0016000000lzca9AAA,0016000000lzK1EAAU,0016000000iq2ADAAY,0016000000inGynAAE,0016000000gdd3YAAQ,0016000000eYHRoAAO,0016000000djORMAA2,0016000000coPNFAA2,0016000000coPM7AAM,0016000000coPKaAAM,0016000000QSdFvAAL,0016000000QSdE9AAL,0016000000QSdAsAAL,0010z00001QhaWQAAZ,0010z00001Oz5AxAAJ,0016000001K7w5HAAR,0016000001G2ZqmAAF,0016000001G1bbeAAB,00160000018q10tAAA,00160000018q0xkAAA,00160000018pxjcAAA,00160000018pxjIAAQ,00160000018px4AAAQ,00160000018pwQ7AAI,00160000018pwIcAAI,00160000018pwFnAAI,00160000018pwCFAAY,00160000018pt7yAAA,00160000018pkRwAAI,00160000018pgAfAAI,00160000018pbORAAY,00160000018pbFeAAI,00160000018pajWAAQ,00160000018pahVAAQ,00160000018pTBiAAM,00160000018pSDnAAM,00160000018pBY8AAM,00160000018pBXKAA2,00160000018p8ndAAA,00160000018orc5AAA,00160000018ohVrAAI,00160000018oWv1AAE,00160000018oWlLAAU,00160000018oWOyAAM,00160000018oWJeAAM,00160000018oPFPAA2,00160000018oClKAAU,00160000018oClAAAU,00160000018o2J4AAI,00160000018o2IpAAI,00160000018nhJJAAY,00160000018nTSTAA2,00160000018nTSOAA2,00160000018nLy9AAE,00160000018nLy4AAE,00160000018nLxuAAE,00160000018nLxpAAE,00160000018nLxfAAE,00160000018n48yAAA,00160000018mEeYAAU,00160000017Q0ZLAA0,00160000017PutNAAS,00160000017PbPtAAK,00160000017Pb8sAAC,00160000017OJZoAAO,00160000017NzlTAAS,00160000017NzioAAC,00160000017NcY6AAK,00160000017NZnRAAW,00160000017NZnHAAW,00160000017NZlGAAW,00160000017NZlBAAW,00160000017NZl6AAG,00160000017NZl1AAG,00160000017NZkwAAG,00160000017NZkrAAG,00160000017NZkmAAG,00160000017NZkhAAG,00160000017NZkcAAG,00160000017NZkXAAW,00160000017NZkSAAW,00160000017NZkIAAW,00160000017NZkDAAW,00160000017NZk3AAG,00160000017NSgOAAW,00160000017MKy4AAG,00160000016XInkAAG,00160000016XIlAAAW,00160000016WGvcAAG,00160000016WFiiAAG,00160000016WFcpAAG,00160000016WF8NAAW,00160000016WDUUAA4,00160000016W0rSAAS,00160000016W0YXAA0,00160000016Vv9hAAC,00160000016ThqpAAC,00160000016ThlzAAC,00160000016ThdgAAC,00160000016ThcYAAS,00160000016ThaIAAS,00160000016TcwgAAC,00160000015aMaGAAU,00160000015aAV1AAM,00160000015Z3uPAAS,00160000015Z3uKAAS,00160000015Z3uFAAS,00160000014vpCOAAY,00160000014vp79AAA,00160000014uzYJAAY,00160000014uxtKAAQ,00160000014HzRzAAK,00160000014HYMtAAO,00160000014HXMYAA4,00160000014HXKNAA4,00160000014HXFNAA4,00160000014Fw7rAAC,00160000014Fw3uAAC,00160000014FR8CAAW,00160000014F3xHAAS,0016000001B94bJAAR,0016000001B94b4AAB,0016000001B94apAAB,0016000001B94akAAB,0016000001B94afAAB,0016000001B94aaAAB,0016000001B94aVAAR,0016000001B94aQAAR,0016000001B94aLAAR,0016000001B92gPAAR,0016000001B91uhAAB,0016000001B912zAAB,0016000001B912uAAB,0016000001B912pAAB,0016000001B912kAAB,0016000001B8vVuAAJ,00160000018qA9QAAU,00160000018q89kAAA,00160000018q89aAAA,00160000018q89QAAQ,00160000018q89GAAQ,00160000018q54WAAQ,00160000018q53JAAQ,00160000018q534AAA,00160000018q4jTAAQ,00160000018q4i6AAA,00160000018q3QsAAI,00160000018q11IAAQ,0016000000QSdFhAAL,0016000000nP9cGAAS,0016000000mpptgAAA,0016000000kpYwPAAU,0016000000eYHRqAAO,0016000000QT9E1AAL,0016000000QSdB7AAL,0016000000Q13F1AAJ,0016000000ObpAOAAZ,0016000000nOxxMAAS,0016000000qCjoBAAS,0016000000inGjNAAU,0016000000eYHR4AAO,0016000000Ug151AAB,0016000000Obu49AAB,0010z00001UucM7AAJ,0016000000mmiQaAAI,0016000000eYbwLAAS,0016000000eYHQBAA4,0016000000LcdjOAAR,0016000000inH1EAAU,0016000000KLntiAAD,0016000000rx9W4AAI,0016000001EZZBtAAP,0016000000inK5UAAU,0016000000MDYSCAA5,0016000000iq2C9AAI,0016000000iq27QAAQ,0016000000inH1AAAU,0016000000inH18AAE,0016000000eYHQGAA4,0016000000QSdB9AAL,0016000000QSdB6AAL,0016000000MDYTuAAP,0016000000KLnwXAAT,0016000000KLnrRAAT,0016000000KLnqzAAD,0016000000KLnlyAAD,0016000000KLnkPAAT,0016000000oDBiEAAW,0016000000nOxwUAAS,0016000000lSLzUAAW,0016000000QSdBAAA1,0016000000QSdB8AAL,0016000000MDYTtAAP,0016000001Lf13PAAR,0016000001L0lvTAAR,0016000000eYHPuAAO,0016000000eYHPtAAO,0016000000QSdAqAAL,0016000000Mhc6jAAB,0016000000KLnjiAAD,0010z00001QgLbqAAF,0010z00001QNIXpAAP,0010z00001NedZvAAJ,0016000001IzbeVAAR,0016000001G2ldnAAB,0016000001Crl79AAB,00160000011ihc4AAA,0016000000xfdyAAAQ,0016000000xfcofAAA,0016000001B9YfOAAV,00160000018ot4BAAQ,00160000016TabgAAC,00160000015ZkwJAAS,00160000015XG7tAAG,00160000011hrFdAAI,00160000011hrEBAAY,00160000011hr2jAAA,00160000011hWYAAA2,00160000011hWW9AAM,00160000011hWU3AAM,00160000011hWH4AAM,00160000011hWFhAAM,00160000011hWDWAA2,00160000011hW8MAAU,00160000011hW7dAAE,00160000011hW6BAAU,00160000011hW2xAAE,00160000011hW1pAAE,00160000011hVzKAAU,00160000011hVuZAAU,00160000011hVpeAAE,00160000011h8zUAAQ,00160000011gu1zAAA,00160000011gjxmAAA,00160000011gHGSAA2,00160000011gHFUAA2,00160000011gHESAA2,00160000011gHCkAAM,00160000011gHC1AAM,00160000011gHBSAA2,00160000011gHAtAAM,00160000011gH9vAAE,00160000011gH8nAAE,00160000011gH6rAAE,00160000011gH5yAAE,00160000011gH4vAAE,00160000011gH2GAAU,00160000010zQOOAA2,00160000010yzTIAAY,00160000010yamNAAQ,00160000010ya5sAAA,00160000010ya1qAAA,00160000010yZc7AAE,00160000010yN3eAAE,00160000010yN1OAAU,00160000010yMyFAAU,00160000010yMwnAAE,00160000010yMvQAAU,00160000010yMtUAAU,00160000010yMrYAAU,00160000010yMmEAAU,00160000010yMjeAAE,00160000010yJfNAAU,00160000010wnH2AAI,00160000010wTPKAA2,0016000000qBZKNAA4,0016000000pcDsZAAU,0016000000papgQAAQ,0016000000lSLzFAAW,0016000000lSLxtAAG,0016000000lSLwmAAG,0016000000lSLvNAAW,0016000000kpZxfAAE,0016000000ip9hxAAA,0016000000inGyoAAE,0016000000gfQHQAA2,0016000000fiFKGAA2,0016000000eYHRuAAO,0016000000eYHQCAA4,0016000000eYHPvAAO,0016000000eYHPsAAO,0016000000cn29YAAQ,0016000000QSdAtAAL,0016000000QSdArAAL,0016000000ObHz3AAF,0016000000LtpgxAAB,0016000000LBp0JAAT,0016000000LBhEIAA1,0016000000KqEvdAAF,0016000000KqEvcAAF,0016000000KqEvbAAF,0016000000KLntcAAD,0016000000KLnrJAAT,0016000000KLnrFAAT,0016000000KLnqoAAD,0016000000KLnoiAAD,0016000000KLnn4AAD,0016000000KLnn3AAD,0016000000KLnn2AAD,0016000000KLnmvAAD,0016000000KLnkMAAT,0016000000KLnkLAAT,0016000000KLnkKAAT,0016000000KLnjgAAD,0016000000KLnjfAAD,0010z00001QhaXiAAJ,0010z00001QhaX4AAJ,0010z00001QNH3rAAH,0010z00001QNH3SAAX,0010z00001QJSX2AAP,0010z00001QJ4TIAA1,0010z00001QJ4HMAA1,0010z00001Oz6zgAAB,0010z00001NeYrQAAV,0010z00001NeY92AAF,0016000001K7xKYAAZ,0016000001L0jwZAAR,0016000001K7h3xAAB,0016000001GmbdNAAR,0016000000inGOfAAM,0010z00001Qh0AbAAJ,0010z00001Qh05qAAB,0016000001NhvGaAAJ,0016000001LdyLSAAZ,0016000001L0K6NAAV,0016000001L0KHUAA3,0016000001L0K0uAAF,0016000001L0IXpAAN,0016000001L0HrBAAV,0010z00001RkpuIAAR,0010z00001R1zTYAAZ,0010z00001R1yixAAB,0010z00001R1xZAAAZ,0010z00001R1rh1AAB,0010z00001QhfjzAAB,0016000001L0K4sAAF,0016000001L0JynAAF,0016000001L0JymAAF,0016000001L0JMxAAN,0016000001L0IPyAAN,0016000001L0JybAAF,0016000001L0JZIAA3,0016000001L0IzYAAV,0016000001L0IzXAAV,0016000001L0IPOAA3,0016000001L0J7qAAF,0016000001L0HyRAAV,0016000001L0JJzAAN,0010z00001Qh0AlAAJ,0016000001HdyMaAAJ,0016000001GOsCGAA1,0010z00001RlZQQAA3,0016000001GO6RhAAL,0016000001L0mLeAAJ,0016000001L0mGEAAZ,0016000001L0mGDAAZ,0016000001L0mGCAAZ,0016000001L0mGAAAZ,0016000001L0mG9AAJ,0016000001L0I4PAAV,0016000001L0HrHAAV,0010z00001RlJuPAAV,0016000001L0KFeAAN,0016000001L0K8vAAF,0016000001L0K8rAAF,0016000001L0K8IAAV,0016000001L0K0wAAF,0016000001L0Jm2AAF,0016000001L0JjiAAF,0016000001L0JeAAAV,0016000001L0Je5AAF,0016000001L0IyUAAV,0016000001L0IpHAAV,0016000001L0IojAAF,0016000001L0IidAAF,0016000001L0IgbAAF,0016000001L0IdQAAV,0016000001L0IarAAF,0016000001L0IZoAAN,0016000001L0IUsAAN,0016000001L0INlAAN,0016000001L0IMEAA3,0016000001L0IKYAA3,0016000001L0IK0AAN,0016000001L0IAdAAN,0016000001L0HzBAAV,0016000001L0IxUAAV,0016000001L0IHbAAN,0016000001L0HypAAF,0016000001L0HyGAAV,0016000001L0HrcAAF,0016000001L0IJbAAN,0016000001L0Iz0AAF,0016000001L0HrNAAV,0016000001L0HrFAAV,0016000001L0KIbAAN,0016000001L0JhKAAV,0016000001L0J2yAAF,0016000001L0HrGAAV,0016000001LhHPTAA3}'::text[]))
  • Rows Removed by Filter: 593402
  • Heap Blocks: exact=34462
12. 128.126 128.126 ↓ 18.7 1,248,118 1

Bitmap Index Scan on maintenance_impact__c_multi_search_gin_idx (cost=0.00..155.99 rows=66,657 width=0) (actual time=128.126..128.126 rows=1,248,118 loops=1)

  • Index Cond: (((((((upper((expected_impact__c)::text) || ' '::text) || upper((a_location_clli__c)::text)) || ' '::text) || upper((z_location_clli__c)::text)) || ' '::text) || upper((circuit_id__c)::text)) ~~ '%ZYO%'::text)
13. 8.989 73.173 ↓ 26.2 32,779 2

Hash (cost=101.08..101.08 rows=1,249 width=34) (actual time=73.172..73.173 rows=32,779 loops=2)

  • Buckets: 65536 (originally 2048) Batches: 1 (originally 1) Memory Usage: 2625kB
14. 64.184 64.184 ↓ 26.2 32,779 2

Index Only Scan using case_multi_column_idx on "case" (cost=0.08..101.08 rows=1,249 width=34) (actual time=0.732..64.184 rows=32,779 loops=2)

  • Heap Fetches: 0
15. 0.027 0.027 ↓ 0.0 0 44,046

Index Scan using service_component__c_temp_later_delete_sfid_key on service_component__c sc (cost=0.08..2.74 rows=1 width=39) (actual time=0.027..0.027 rows=0 loops=44,046)

  • Index Cond: ((sfid)::text = (maintenance_impact__c.service_component__c)::text)
16. 0.049 0.049 ↑ 1.0 1 44,046

Index Scan using service__c_temp_later_delete_sfid_key on service__c s (cost=0.08..3.12 rows=1 width=47) (actual time=0.049..0.049 rows=1 loops=44,046)

  • Index Cond: ((sfid)::text = (maintenance_impact__c.service__c)::text)
17. 0.000 0.437 ↓ 0.0 0 1

Nested Loop Left Join (cost=98.31..6,813.82 rows=1 width=149) (actual time=0.437..0.437 rows=0 loops=1)

18. 0.001 0.437 ↓ 0.0 0 1

Nested Loop (cost=98.22..6,813.47 rows=1 width=157) (actual time=0.437..0.437 rows=0 loops=1)

19. 0.000 0.436 ↓ 0.0 0 1

Nested Loop (cost=98.14..6,795.67 rows=9 width=161) (actual time=0.436..0.436 rows=0 loops=1)

20. 0.002 0.436 ↓ 0.0 0 1

Bitmap Heap Scan on service__c s_1 (cost=98.05..165.28 rows=34 width=47) (actual time=0.436..0.436 rows=0 loops=1)

  • Recheck Cond: (((upper((name)::text) || ' '::text) || upper((legacy_circuit_id__c)::text)) ~~ '%/FEUB/012245/ /ZYO /%'::text)
21. 0.434 0.434 ↓ 0.0 0 1

Bitmap Index Scan on service__c_multi_search_gin_idx (cost=0.00..98.05 rows=34 width=0) (actual time=0.434..0.434 rows=0 loops=1)

  • Index Cond: (((upper((name)::text) || ' '::text) || upper((legacy_circuit_id__c)::text)) ~~ '%/FEUB/012245/ /ZYO /%'::text)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using maintenance_impact__c_service__c_idx on maintenance_impact__c maintenance_impact__c_1 (cost=0.09..194.99 rows=6 width=133) (never executed)

  • Index Cond: ((service__c)::text = (s_1.sfid)::text)
  • Filter: (((account__c IS NOT NULL) OR (corrected_account_name__c IS NOT NULL)) AND (NOT isdeleted) AND ((account__c IS NOT NULL) OR (corrected_account_name__c IS NOT NULL)) AND ((expected_impact__c)::text <> 'Remove'::text) AND ((account__c)::text = ANY ('{0016000001EYimkAAD,0016000001EYimJAAT,0016000001EYycmAAD,0016000001Lg8R6AAJ,0016000001JQLUfAAP,0016000001EYidXAAT,0016000001EYidZAAT,0016000001EYidYAAT,0016000001EYizxAAD,0016000001Cs2cJAAR,0016000001Cs2Z8AAJ,0016000001Cs2KfAAJ,0016000001MeTaWAAV,0016000001K5zbCAAR,0016000001CqwZSAAZ,0016000001CqwdlAAB,0016000001CqwbyAAB,00160000018pQDoAAM,00160000018pQDKAA2,00160000018pQBiAAM,00160000018pQ20AAE,00160000018pQ1CAAU,00160000018pQ17AAE,00160000018pQ0sAAE,00160000018pPzfAAE,00160000018pPxyAAE,00160000018mMewAAE,00160000018mMevAAE,00160000018mfsWAAQ,0016000001Cr4lPAAR,0016000001CqwgBAAR,0016000001B8tzLAAR,00160000018pxpzAAA,00160000018pQC2AAM,00160000018pQAGAA2,00160000018pQ9hAAE,00160000018pQ7QAAU,00160000018pQ2FAAU,00160000018pQ1qAAE,00160000018pPzGAAU,00160000018mMetAAE,00160000018mMesAAE,00160000018mMerAAE,00160000018pQ7GAAU,0016000001NhzrmAAB,00160000018mMeEAAU,00160000018mMeuAAE,0016000001CrYbiAAF,0016000001CrYbdAAF,00160000018mMeFAAU,00160000017Pn8cAAC,0016000001Ea06qAAB,0016000001K6XAMAA3,00160000016UbpWAAS,00160000016UbpRAAS,00160000016UbpMAAS,00160000016UbpCAAS,00160000018q8wDAAQ,00160000018pASXAA2,00160000016Ubp2AAC,00160000016UbonAAC,00160000015Zq5vAAC,0016000000zmpYtAAI,0016000000zmJwjAAE,0016000000zmJtRAAU,0016000000sesfGAAQ,0016000000seshpAAA,0016000001B9xxEAAR,00160000018pECyAAM,00160000018pbQwAAI,00160000018pbQmAAI,00160000018pbQcAAI,00160000018pbQXAAY,00160000018pbQSAAY,00160000018pbO7AAI,00160000018pRr4AAE,00160000018pRqzAAE,00160000018pPLLAA2,00160000018pF5SAAU,00160000018pCqbAAE,0016000000un1LhAAI,0016000000umU7OAAU,0016000000uC4dMAAS,0016000000oEOtWAAW,0016000000mppvCAAQ,0016000000tfpY5AAI,0016000000scJUXAA2,0016000000jzI1SAAU,0016000000jzI1RAAU,0016000000kpWk1AAE,0016000000iqgnfAAA,0016000000iqgohAAA,0016000000oEvJIAA0,0016000000inHEfAAM,0016000000inGIEAA2,0016000000inGXUAA2,0016000000konuWAAQ,0016000001CrKkSAAV,0016000000wjoelAAA,0016000000iq2DMAAY,0010z00001UjqaMAAR,0016000000orcoYAAQ,0016000000sc30rAAA,0016000000mppuYAAQ,0016000000QSd6aAAD,0010z00001Rkkw1AAB,0016000000ooKoAAAU,0016000000iq283AAA,0016000000iq1wqAAA,0016000000inGylAAE,0016000000eYHRjAAO,0016000000eYHRiAAO,0016000000eYHRgAAO,0016000000eYHR5AAO,0016000000eYHR3AAO,0016000000eYHPrAAO,0016000000eYHPqAAO,0016000000eYHPpAAO,0016000000eYHPoAAO,0016000000QSdAmAAL,0016000000MDYSDAA5,0016000000LZvwSAAT,0016000000KLntaAAD,0016000000KLnoJAAT,0016000000KLnn0AAD,0016000000KLnlYAAT,0016000000KLnjeAAD,0016000000KLnjNAAT,0010z00001Oz4XVAAZ,0016000000z2CRzAAM,0016000000yHj3eAAC,0016000000sblX6AAI,0016000001EZXlNAAX,0016000001B9pQZAAZ,0016000000sblXtAAI,0016000000sblXoAAI,0016000000sblXjAAI,0016000000sblXeAAI,0016000000sblSWAAY,0016000000r9OhIAAU,0016000000os6TdAAI,0016000000oDKteAAG,0016000000oDKtPAAW,0016000000mpprtAAA,0016000000mppgXAAQ,0016000000lyNU7AAM,0016000000ly7mwAAA,0016000000inGykAAE,0016000000eYHRhAAO,0016000000eYHR7AAO,0016000000eYHR6AAO,0016000000djsiGAAQ,0016000000QSdFsAAL,0016000000QSdFpAAL,0016000000QSdAuAAL,0016000000QSdApAAL,0016000000QSdAoAAL,0016000000QSdAnAAL,0016000000QSdAlAAL,0016000000QSd74AAD,0016000000QSd73AAD,0016000000QSd72AAD,0016000000Q13ExAAJ,0016000000MDYTzAAP,0016000000MDYTxAAP,0016000000MDYTrAAP,0016000000MDYSEAA5,0016000000LZvvFAAT,0016000000LBhQhAAL,0016000000Kr7yyAAB,0016000000KqG39AAF,0016000000KLnmlAAD,0016000000KLnkrAAD,0016000000yKequAAC,0016000000yIAQuAAO,0016000000yHfkbAAC,0016000000yHfhDAAS,0016000000xbtZEAAY,0016000000xbtJLAAY,0016000000sblXyAAI,0010z00001QJKrKAAX,0016000000WJkTCAA1,0016000000WJfNKAA1,0016000000NxBcHAAV,0016000000NxBb0AAF,0016000000NxBXNAA3,0016000000MDYTyAAP,0010z00001Qh7h8AAB,0010z00001NctC1AAJ,0016000000NxBbhAAF,0016000000zoP3UAAU,0016000000VOjfCAAT,0016000000MDYU0AAP,0016000000kpYqEAAU,0016000000coPNjAAM,0016000001EZBCiAAP,0016000001B8vjDAAR,00160000018pknCAAQ,00160000018nyX2AAI,00160000017Ph8fAAC,00160000014F2fUAAS,00160000013GVBjAAO,0016000000zoCf1AAE,0016000000znG9EAAU,0016000000z4sunAAA,0016000000z1pkoAAA,0016000000xfldzAAA,0016000001EZNytAAH,0016000001EZNyUAAX,0016000001EZNyPAAX,0016000001EZNxqAAH,0016000001EZNwOAAX,0016000001EZNvQAAX,0016000001EZNuwAAH,0016000001EZNuDAAX,0016000001EZNtUAAX,0016000001EZNiqAAH,0016000001EZNB7AAP,0016000001EZN7KAAX,0016000001EZMxxAAH,0016000001EZMrOAAX,0016000001EZMqkAAH,0016000001EZLRRAA5,0016000001EZLPoAAP,0016000001EZLKKAA5,0016000001EZLDwAAP,0016000001EZL9PAAX,0016000001EZ3SBAA1,0016000001EZ3OsAAL,0016000001EZ107AAD,0016000001EYxEUAA1,0016000001EYxDWAA1,0016000001EYuoIAAT,0016000001CrehsAAB,0016000001CrdywAAB,0016000001CrdgZAAR,0016000001Crb3VAAR,0016000001Crb3QAAR,0016000001Crb31AAB,0016000001Crb2cAAB,0016000001Crb2SAAR,0016000001CrapJAAR,0016000001CrYT5AAN,0016000001CrYSgAAN,0016000001CrYHmAAN,0016000001CrXt2AAF,0016000001CrVGgAAN,0016000001CrUabAAF,0016000001CrShIAAV,0016000001CrShDAAV,0016000001CrSh8AAF,0016000001CrSf2AAF,0016000001CrSZOAA3,0016000001CrSWXAA3,0016000001CrSQoAAN,0016000001CrSFFAA3,0016000001CrSD9AAN,0016000001CrSC6AAN,0016000001CrRtdAAF,0016000001CrP4JAAV,0016000001CrMFZAA3,0016000001CrMDEAA3,0016000001CrKlkAAF,0016000001CrKDoAAN,0016000001CrJjTAAV,0016000001CrJHXAA3,0016000001CrJHNAA3,0016000001CrJH8AAN,0016000001CrGUsAAN,0016000001CrFFJAA3,0016000001CrFCPAA3,0016000001CrFBMAA3,0016000001CrFAnAAN,0016000001CrFA4AAN,0016000001CrF9VAAV,0016000001CrF8VAAV,0016000001CrEtkAAF,0016000001CrDaKAAV,0016000001CrDWwAAN,0016000001CrDWSAA3,0016000001Cr8BxAAJ,0016000001Cr7wrAAB,0016000001Cr7k5AAB,0016000001Cr6YjAAJ,0016000001Cr6ObAAJ,0016000001Cr5ZQAAZ,0016000001Cr2BOAAZ,0016000001BA97WAAT,0016000001BA74KAAT,0016000001BA74FAAT,0016000001BA74AAAT,0016000001BA745AAD,0016000001BA740AAD,0016000001BA73qAAD,0016000001BA73lAAD,0016000001BA6aGAAT,0016000001BA6ZwAAL,0016000001BA3YcAAL,0016000001BA3WqAAL,0016000001BA2d5AAD,0016000001BA19cAAD,0016000001BA19XAAT,0016000001B9yyaAAB,0016000001B9ynHAAR,0016000001B9xOwAAJ,0016000001B9xOrAAJ,0016000001B9wnIAAR,0016000001B9wnDAAR,0016000001B9wn3AAB,0016000001B9wmyAAB,0016000001B9r4CAAR,0016000001B9nMtAAJ,0016000001B9m92AAB,0016000001B9hJIAAZ,0016000001B9ZtnAAF,0016000001B9Zn1AAF,0016000001B9Zd5AAF,0016000001B9ZcWAAV,0016000001B9ZcRAAV,0016000001B9ZcMAAV,0016000001B9ZcHAAV,0016000001B9ZcCAAV,0016000001B9Zc7AAF,0016000001B9VazAAF,0016000001B9TpPAAV,0016000001B9NaCAAV,0016000001B9MIBAA3,0016000001B9MHrAAN,0016000001B9JvuAAF,0016000001B9JvfAAF,0016000001B9JvVAAV,0016000001B9JvLAAV,0016000001B9JvGAAV,0016000001B9Jv6AAF,0016000001B9JurAAF,0016000001B9FiDAAV,0016000001B9FgbAAF,0016000001B9FfxAAF,0016000001B9FfOAAV,0016000001B9FeVAAV,0016000001B9FZuAAN,0016000001B9FVEAA3,0016000001B9FUfAAN,0016000001B9FTSAA3,0016000001B9Dq4AAF,0016000001B9AtJAAV,0016000001B96kiAAB,0016000001B96kTAAR,0016000001B96kJAAR,00160000015Z3u5AAC,00160000015Z3u0AAC,00160000015Z3tvAAC,00160000015Z3tgAAC,00160000015Z3tWAAS,00160000015Z3tRAAS,00160000015Z3tMAAS,00160000015Z3tHAAS,00160000015Z3t7AAC,00160000015Z3t2AAC,00160000015Z3sxAAC,00160000015Z3snAAC,00160000015Z3sjAAC,00160000015Z3siAAC,00160000015Z3sdAAC,00160000015Z3sYAAS,00160000015Z3sTAAS,00160000015Z3sOAAS,00160000015Z3sJAAS,00160000015XOfVAAW,00160000015XObYAAW,00160000015XOW4AAO,00160000015XOUmAAO,00160000015XOSqAAO,00160000015XGfGAAW,00160000015XGMiAAO,00160000015XCtPAAW,00160000015XCkbAAG,00160000015XAq0AAG,00160000015X91gAAC,00160000015X8qRAAS,00160000015WqMCAA0,00160000014yVEMAA2,00160000014xCtMAAU,001600000142XMhAAM,001600000142XMDAA2,0016000001EYteHAAT,0016000001EYptIAAT,0016000001EYpt8AAD,0016000001EYphqAAD,0016000001EYmhmAAD,0016000001EYkgKAAT,0016000001EYkesAAD,0016000001EYWF7AAP,0016000001EYWCrAAP,0016000001EYUYpAAP,0016000001EYU54AAH,0016000001EYU4aAAH,0016000001EYTvcAAH,0016000001EYRVKAA5,0016000001EYRURAA5,0016000001EYLjrAAH,0016000001EYLjhAAH,0016000001EYLjXAAX,0016000001EYLj3AAH,0016000001EYLiZAAX,0016000001EYLi5AAH,0016000001EYLhbAAH,0016000001EYDAUAA5,0016000001EYC0KAAX,0016000001EYBzqAAH,0016000001EYBIOAA5,0016000001EYBIJAA5,0016000001EYBI9AAP,0016000001EYBI4AAP,0016000001EYBHuAAP,0016000001EYBHkAAP,0016000001EYBHaAAP,0016000001EY7pZAAT,0016000001EY7pUAAT,0016000001EY51QAAT,0016000001EY50wAAD,0016000001EXq14AAD,0016000001CsKCrAAN,0016000001CsKBKAA3,0016000001CsIUXAA3,0016000001CsIUDAA3,0016000001CsISgAAN,0016000001CsHldAAF,0016000001CsECUAA3,0016000001CsDr4AAF,0016000001CsDonAAF,0016000001Cs4loAAB,0016000001CryfQAAR,0016000001CryeqAAB,0016000001CryegAAB,0016000001CryeDAAR,0016000001CryMYAAZ,0016000001CryIlAAJ,0016000001Cry2jAAB,0016000001Crxp6AAB,0016000001CrwrAAAR,0016000001Cruv3AAB,0016000001CrushAAB,0016000001CrusIAAR,0016000001Crur5AAB,0016000001CrqUQAAZ,0016000001CrqU6AAJ,0016000001Crpb8AAB,0016000001CrobDAAR,0016000001CroZcAAJ,0016000001CroZNAAZ,0016000001CroZDAAZ,0016000001CrlPSAAZ,0016000001CrlKwAAJ,0016000001Crl9AAAR,0016000001Crh5nAAB,0016000001Crh5YAAR,0016000001Crh5JAAR,0016000001Crh54AAB,0016000001CrfECAAZ,0016000001CrfE7AAJ,0016000001CrfDxAAJ,0016000001CrfDnAAJ,0016000001CrfDdAAJ,0016000001CrfDTAAZ,0016000001CrfDJAAZ,0016000001CrfD9AAJ,0016000001CrfD4AAJ,001600000142XKHAA2,001600000142WkOAAU,001600000142WihAAE,00160000013HxAtAAK,00160000013HnpKAAS,00160000013G1qqAAC,00160000013G1p4AAC,00160000013FmBRAA0,00160000013FTNvAAO,00160000013F8lJAAS,00160000011jSW6AAM,00160000011ihotAAA,00160000011ihoKAAQ,00160000011haGnAAI,00160000011hWIqAAM,00160000010xy1nAAA,0016000000znHz4AAE,0016000000zmoa5AAA,0016000000wmBOwAAM,0016000000wEDyuAAG,0016000000uCgtKAAS,0016000000rx9TtAAI,0016000000rx9TsAAI,0016000000r8e1pAAA,0016000000qCimSAAS,0016000000mpK75AAE,0016000000mpK33AAE,0016000000m0BltAAE,0016000000lzca9AAA,0016000000lzK1EAAU,0016000000iq2ADAAY,0016000000inGynAAE,0016000000gdd3YAAQ,0016000000eYHRoAAO,0016000000djORMAA2,0016000000coPNFAA2,0016000000coPM7AAM,0016000000coPKaAAM,0016000000QSdFvAAL,0016000000QSdE9AAL,0016000000QSdAsAAL,0010z00001QhaWQAAZ,0010z00001Oz5AxAAJ,0016000001K7w5HAAR,0016000001G2ZqmAAF,0016000001G1bbeAAB,00160000018q10tAAA,00160000018q0xkAAA,00160000018pxjcAAA,00160000018pxjIAAQ,00160000018px4AAAQ,00160000018pwQ7AAI,00160000018pwIcAAI,00160000018pwFnAAI,00160000018pwCFAAY,00160000018pt7yAAA,00160000018pkRwAAI,00160000018pgAfAAI,00160000018pbORAAY,00160000018pbFeAAI,00160000018pajWAAQ,00160000018pahVAAQ,00160000018pTBiAAM,00160000018pSDnAAM,00160000018pBY8AAM,00160000018pBXKAA2,00160000018p8ndAAA,00160000018orc5AAA,00160000018ohVrAAI,00160000018oWv1AAE,00160000018oWlLAAU,00160000018oWOyAAM,00160000018oWJeAAM,00160000018oPFPAA2,00160000018oClKAAU,00160000018oClAAAU,00160000018o2J4AAI,00160000018o2IpAAI,00160000018nhJJAAY,00160000018nTSTAA2,00160000018nTSOAA2,00160000018nLy9AAE,00160000018nLy4AAE,00160000018nLxuAAE,00160000018nLxpAAE,00160000018nLxfAAE,00160000018n48yAAA,00160000018mEeYAAU,00160000017Q0ZLAA0,00160000017PutNAAS,00160000017PbPtAAK,00160000017Pb8sAAC,00160000017OJZoAAO,00160000017NzlTAAS,00160000017NzioAAC,00160000017NcY6AAK,00160000017NZnRAAW,00160000017NZnHAAW,00160000017NZlGAAW,00160000017NZlBAAW,00160000017NZl6AAG,00160000017NZl1AAG,00160000017NZkwAAG,00160000017NZkrAAG,00160000017NZkmAAG,00160000017NZkhAAG,00160000017NZkcAAG,00160000017NZkXAAW,00160000017NZkSAAW,00160000017NZkIAAW,00160000017NZkDAAW,00160000017NZk3AAG,00160000017NSgOAAW,00160000017MKy4AAG,00160000016XInkAAG,00160000016XIlAAAW,00160000016WGvcAAG,00160000016WFiiAAG,00160000016WFcpAAG,00160000016WF8NAAW,00160000016WDUUAA4,00160000016W0rSAAS,00160000016W0YXAA0,00160000016Vv9hAAC,00160000016ThqpAAC,00160000016ThlzAAC,00160000016ThdgAAC,00160000016ThcYAAS,00160000016ThaIAAS,00160000016TcwgAAC,00160000015aMaGAAU,00160000015aAV1AAM,00160000015Z3uPAAS,00160000015Z3uKAAS,00160000015Z3uFAAS,00160000014vpCOAAY,00160000014vp79AAA,00160000014uzYJAAY,00160000014uxtKAAQ,00160000014HzRzAAK,00160000014HYMtAAO,00160000014HXMYAA4,00160000014HXKNAA4,00160000014HXFNAA4,00160000014Fw7rAAC,00160000014Fw3uAAC,00160000014FR8CAAW,00160000014F3xHAAS,0016000001B94bJAAR,0016000001B94b4AAB,0016000001B94apAAB,0016000001B94akAAB,0016000001B94afAAB,0016000001B94aaAAB,0016000001B94aVAAR,0016000001B94aQAAR,0016000001B94aLAAR,0016000001B92gPAAR,0016000001B91uhAAB,0016000001B912zAAB,0016000001B912uAAB,0016000001B912pAAB,0016000001B912kAAB,0016000001B8vVuAAJ,00160000018qA9QAAU,00160000018q89kAAA,00160000018q89aAAA,00160000018q89QAAQ,00160000018q89GAAQ,00160000018q54WAAQ,00160000018q53JAAQ,00160000018q534AAA,00160000018q4jTAAQ,00160000018q4i6AAA,00160000018q3QsAAI,00160000018q11IAAQ,0016000000QSdFhAAL,0016000000nP9cGAAS,0016000000mpptgAAA,0016000000kpYwPAAU,0016000000eYHRqAAO,0016000000QT9E1AAL,0016000000QSdB7AAL,0016000000Q13F1AAJ,0016000000ObpAOAAZ,0016000000nOxxMAAS,0016000000qCjoBAAS,0016000000inGjNAAU,0016000000eYHR4AAO,0016000000Ug151AAB,0016000000Obu49AAB,0010z00001UucM7AAJ,0016000000mmiQaAAI,0016000000eYbwLAAS,0016000000eYHQBAA4,0016000000LcdjOAAR,0016000000inH1EAAU,0016000000KLntiAAD,0016000000rx9W4AAI,0016000001EZZBtAAP,0016000000inK5UAAU,0016000000MDYSCAA5,0016000000iq2C9AAI,0016000000iq27QAAQ,0016000000inH1AAAU,0016000000inH18AAE,0016000000eYHQGAA4,0016000000QSdB9AAL,0016000000QSdB6AAL,0016000000MDYTuAAP,0016000000KLnwXAAT,0016000000KLnrRAAT,0016000000KLnqzAAD,0016000000KLnlyAAD,0016000000KLnkPAAT,0016000000oDBiEAAW,0016000000nOxwUAAS,0016000000lSLzUAAW,0016000000QSdBAAA1,0016000000QSdB8AAL,0016000000MDYTtAAP,0016000001Lf13PAAR,0016000001L0lvTAAR,0016000000eYHPuAAO,0016000000eYHPtAAO,0016000000QSdAqAAL,0016000000Mhc6jAAB,0016000000KLnjiAAD,0010z00001QgLbqAAF,0010z00001QNIXpAAP,0010z00001NedZvAAJ,0016000001IzbeVAAR,0016000001G2ldnAAB,0016000001Crl79AAB,00160000011ihc4AAA,0016000000xfdyAAAQ,0016000000xfcofAAA,0016000001B9YfOAAV,00160000018ot4BAAQ,00160000016TabgAAC,00160000015ZkwJAAS,00160000015XG7tAAG,00160000011hrFdAAI,00160000011hrEBAAY,00160000011hr2jAAA,00160000011hWYAAA2,00160000011hWW9AAM,00160000011hWU3AAM,00160000011hWH4AAM,00160000011hWFhAAM,00160000011hWDWAA2,00160000011hW8MAAU,00160000011hW7dAAE,00160000011hW6BAAU,00160000011hW2xAAE,00160000011hW1pAAE,00160000011hVzKAAU,00160000011hVuZAAU,00160000011hVpeAAE,00160000011h8zUAAQ,00160000011gu1zAAA,00160000011gjxmAAA,00160000011gHGSAA2,00160000011gHFUAA2,00160000011gHESAA2,00160000011gHCkAAM,00160000011gHC1AAM,00160000011gHBSAA2,00160000011gHAtAAM,00160000011gH9vAAE,00160000011gH8nAAE,00160000011gH6rAAE,00160000011gH5yAAE,00160000011gH4vAAE,00160000011gH2GAAU,00160000010zQOOAA2,00160000010yzTIAAY,00160000010yamNAAQ,00160000010ya5sAAA,00160000010ya1qAAA,00160000010yZc7AAE,00160000010yN3eAAE,00160000010yN1OAAU,00160000010yMyFAAU,00160000010yMwnAAE,00160000010yMvQAAU,00160000010yMtUAAU,00160000010yMrYAAU,00160000010yMmEAAU,00160000010yMjeAAE,00160000010yJfNAAU,00160000010wnH2AAI,00160000010wTPKAA2,0016000000qBZKNAA4,0016000000pcDsZAAU,0016000000papgQAAQ,0016000000lSLzFAAW,0016000000lSLxtAAG,0016000000lSLwmAAG,0016000000lSLvNAAW,0016000000kpZxfAAE,0016000000ip9hxAAA,0016000000inGyoAAE,0016000000gfQHQAA2,0016000000fiFKGAA2,0016000000eYHRuAAO,0016000000eYHQCAA4,0016000000eYHPvAAO,0016000000eYHPsAAO,0016000000cn29YAAQ,0016000000QSdAtAAL,0016000000QSdArAAL,0016000000ObHz3AAF,0016000000LtpgxAAB,0016000000LBp0JAAT,0016000000LBhEIAA1,0016000000KqEvdAAF,0016000000KqEvcAAF,0016000000KqEvbAAF,0016000000KLntcAAD,0016000000KLnrJAAT,0016000000KLnrFAAT,0016000000KLnqoAAD,0016000000KLnoiAAD,0016000000KLnn4AAD,0016000000KLnn3AAD,0016000000KLnn2AAD,0016000000KLnmvAAD,0016000000KLnkMAAT,0016000000KLnkLAAT,0016000000KLnkKAAT,0016000000KLnjgAAD,0016000000KLnjfAAD,0010z00001QhaXiAAJ,0010z00001QhaX4AAJ,0010z00001QNH3rAAH,0010z00001QNH3SAAX,0010z00001QJSX2AAP,0010z00001QJ4TIAA1,0010z00001QJ4HMAA1,0010z00001Oz6zgAAB,0010z00001NeYrQAAV,0010z00001NeY92AAF,0016000001K7xKYAAZ,0016000001L0jwZAAR,0016000001K7h3xAAB,0016000001GmbdNAAR,0016000000inGOfAAM,0010z00001Qh0AbAAJ,0010z00001Qh05qAAB,0016000001NhvGaAAJ,0016000001LdyLSAAZ,0016000001L0K6NAAV,0016000001L0KHUAA3,0016000001L0K0uAAF,0016000001L0IXpAAN,0016000001L0HrBAAV,0010z00001RkpuIAAR,0010z00001R1zTYAAZ,0010z00001R1yixAAB,0010z00001R1xZAAAZ,0010z00001R1rh1AAB,0010z00001QhfjzAAB,0016000001L0K4sAAF,0016000001L0JynAAF,0016000001L0JymAAF,0016000001L0JMxAAN,0016000001L0IPyAAN,0016000001L0JybAAF,0016000001L0JZIAA3,0016000001L0IzYAAV,0016000001L0IzXAAV,0016000001L0IPOAA3,0016000001L0J7qAAF,0016000001L0HyRAAV,0016000001L0JJzAAN,0010z00001Qh0AlAAJ,0016000001HdyMaAAJ,0016000001GOsCGAA1,0010z00001RlZQQAA3,0016000001GO6RhAAL,0016000001L0mLeAAJ,0016000001L0mGEAAZ,0016000001L0mGDAAZ,0016000001L0mGCAAZ,0016000001L0mGAAAZ,0016000001L0mG9AAJ,0016000001L0I4PAAV,0016000001L0HrHAAV,0010z00001RlJuPAAV,0016000001L0KFeAAN,0016000001L0K8vAAF,0016000001L0K8rAAF,0016000001L0K8IAAV,0016000001L0K0wAAF,0016000001L0Jm2AAF,0016000001L0JjiAAF,0016000001L0JeAAAV,0016000001L0Je5AAF,0016000001L0IyUAAV,0016000001L0IpHAAV,0016000001L0IojAAF,0016000001L0IidAAF,0016000001L0IgbAAF,0016000001L0IdQAAV,0016000001L0IarAAF,0016000001L0IZoAAN,0016000001L0IUsAAN,0016000001L0INlAAN,0016000001L0IMEAA3,0016000001L0IKYAA3,0016000001L0IK0AAN,0016000001L0IAdAAN,0016000001L0HzBAAV,0016000001L0IxUAAV,0016000001L0IHbAAN,0016000001L0HypAAF,0016000001L0HyGAAV,0016000001L0HrcAAF,0016000001L0IJbAAN,0016000001L0Iz0AAF,0016000001L0HrNAAV,0016000001L0HrFAAV,0016000001L0KIbAAN,0016000001L0JhKAAV,0016000001L0J2yAAF,0016000001L0HrGAAV,0016000001LhHPTAA3}'::text[])))
23. 0.000 0.000 ↓ 0.0 0

Index Only Scan using case_multi_column_idx on "case" case_1 (cost=0.08..1.98 rows=1 width=34) (never executed)

  • Index Cond: (sfid = (maintenance_impact__c_1.case__c)::text)
  • Heap Fetches: 0
24. 0.000 0.000 ↓ 0.0 0

Index Scan using service_component__c_temp_later_delete_sfid_key on service_component__c sc_1 (cost=0.08..0.35 rows=1 width=39) (never executed)

  • Index Cond: ((sfid)::text = (maintenance_impact__c_1.service_component__c)::text)
25. 0.001 0.307 ↓ 0.0 0 1

Nested Loop Left Join (cost=98.32..6,454.94 rows=1 width=149) (actual time=0.307..0.307 rows=0 loops=1)

26. 0.000 0.306 ↓ 0.0 0 1

Nested Loop (cost=98.23..6,454.22 rows=1 width=149) (actual time=0.306..0.306 rows=0 loops=1)

27. 0.001 0.306 ↓ 0.0 0 1

Nested Loop (cost=98.15..6,446.31 rows=4 width=153) (actual time=0.306..0.306 rows=0 loops=1)

28. 0.000 0.305 ↓ 0.0 0 1

Bitmap Heap Scan on service_component__c sc_2 (cost=98.06..176.26 rows=40 width=39) (actual time=0.305..0.305 rows=0 loops=1)

  • Recheck Cond: (upper((legacy_circuit_id__c)::text) ~~ '%/FEUB/012245/ /ZYO /%'::text)
29. 0.305 0.305 ↓ 0.0 0 1

Bitmap Index Scan on service_component__c_legacy_circuit_id__c_idx (cost=0.00..98.06 rows=40 width=0) (actual time=0.304..0.305 rows=0 loops=1)

  • Index Cond: (upper((legacy_circuit_id__c)::text) ~~ '%/FEUB/012245/ /ZYO /%'::text)
30. 0.000 0.000 ↓ 0.0 0

Index Scan using maintenance_impact__c_service_component__c_idx on maintenance_impact__c maintenance_impact__c_2 (cost=0.09..156.74 rows=5 width=133) (never executed)

  • Index Cond: ((service_component__c)::text = (sc_2.sfid)::text)
  • Filter: (((account__c IS NOT NULL) OR (corrected_account_name__c IS NOT NULL)) AND (NOT isdeleted) AND ((account__c IS NOT NULL) OR (corrected_account_name__c IS NOT NULL)) AND ((expected_impact__c)::text <> 'Remove'::text) AND ((account__c)::text = ANY ('{0016000001EYimkAAD,0016000001EYimJAAT,0016000001EYycmAAD,0016000001Lg8R6AAJ,0016000001JQLUfAAP,0016000001EYidXAAT,0016000001EYidZAAT,0016000001EYidYAAT,0016000001EYizxAAD,0016000001Cs2cJAAR,0016000001Cs2Z8AAJ,0016000001Cs2KfAAJ,0016000001MeTaWAAV,0016000001K5zbCAAR,0016000001CqwZSAAZ,0016000001CqwdlAAB,0016000001CqwbyAAB,00160000018pQDoAAM,00160000018pQDKAA2,00160000018pQBiAAM,00160000018pQ20AAE,00160000018pQ1CAAU,00160000018pQ17AAE,00160000018pQ0sAAE,00160000018pPzfAAE,00160000018pPxyAAE,00160000018mMewAAE,00160000018mMevAAE,00160000018mfsWAAQ,0016000001Cr4lPAAR,0016000001CqwgBAAR,0016000001B8tzLAAR,00160000018pxpzAAA,00160000018pQC2AAM,00160000018pQAGAA2,00160000018pQ9hAAE,00160000018pQ7QAAU,00160000018pQ2FAAU,00160000018pQ1qAAE,00160000018pPzGAAU,00160000018mMetAAE,00160000018mMesAAE,00160000018mMerAAE,00160000018pQ7GAAU,0016000001NhzrmAAB,00160000018mMeEAAU,00160000018mMeuAAE,0016000001CrYbiAAF,0016000001CrYbdAAF,00160000018mMeFAAU,00160000017Pn8cAAC,0016000001Ea06qAAB,0016000001K6XAMAA3,00160000016UbpWAAS,00160000016UbpRAAS,00160000016UbpMAAS,00160000016UbpCAAS,00160000018q8wDAAQ,00160000018pASXAA2,00160000016Ubp2AAC,00160000016UbonAAC,00160000015Zq5vAAC,0016000000zmpYtAAI,0016000000zmJwjAAE,0016000000zmJtRAAU,0016000000sesfGAAQ,0016000000seshpAAA,0016000001B9xxEAAR,00160000018pECyAAM,00160000018pbQwAAI,00160000018pbQmAAI,00160000018pbQcAAI,00160000018pbQXAAY,00160000018pbQSAAY,00160000018pbO7AAI,00160000018pRr4AAE,00160000018pRqzAAE,00160000018pPLLAA2,00160000018pF5SAAU,00160000018pCqbAAE,0016000000un1LhAAI,0016000000umU7OAAU,0016000000uC4dMAAS,0016000000oEOtWAAW,0016000000mppvCAAQ,0016000000tfpY5AAI,0016000000scJUXAA2,0016000000jzI1SAAU,0016000000jzI1RAAU,0016000000kpWk1AAE,0016000000iqgnfAAA,0016000000iqgohAAA,0016000000oEvJIAA0,0016000000inHEfAAM,0016000000inGIEAA2,0016000000inGXUAA2,0016000000konuWAAQ,0016000001CrKkSAAV,0016000000wjoelAAA,0016000000iq2DMAAY,0010z00001UjqaMAAR,0016000000orcoYAAQ,0016000000sc30rAAA,0016000000mppuYAAQ,0016000000QSd6aAAD,0010z00001Rkkw1AAB,0016000000ooKoAAAU,0016000000iq283AAA,0016000000iq1wqAAA,0016000000inGylAAE,0016000000eYHRjAAO,0016000000eYHRiAAO,0016000000eYHRgAAO,0016000000eYHR5AAO,0016000000eYHR3AAO,0016000000eYHPrAAO,0016000000eYHPqAAO,0016000000eYHPpAAO,0016000000eYHPoAAO,0016000000QSdAmAAL,0016000000MDYSDAA5,0016000000LZvwSAAT,0016000000KLntaAAD,0016000000KLnoJAAT,0016000000KLnn0AAD,0016000000KLnlYAAT,0016000000KLnjeAAD,0016000000KLnjNAAT,0010z00001Oz4XVAAZ,0016000000z2CRzAAM,0016000000yHj3eAAC,0016000000sblX6AAI,0016000001EZXlNAAX,0016000001B9pQZAAZ,0016000000sblXtAAI,0016000000sblXoAAI,0016000000sblXjAAI,0016000000sblXeAAI,0016000000sblSWAAY,0016000000r9OhIAAU,0016000000os6TdAAI,0016000000oDKteAAG,0016000000oDKtPAAW,0016000000mpprtAAA,0016000000mppgXAAQ,0016000000lyNU7AAM,0016000000ly7mwAAA,0016000000inGykAAE,0016000000eYHRhAAO,0016000000eYHR7AAO,0016000000eYHR6AAO,0016000000djsiGAAQ,0016000000QSdFsAAL,0016000000QSdFpAAL,0016000000QSdAuAAL,0016000000QSdApAAL,0016000000QSdAoAAL,0016000000QSdAnAAL,0016000000QSdAlAAL,0016000000QSd74AAD,0016000000QSd73AAD,0016000000QSd72AAD,0016000000Q13ExAAJ,0016000000MDYTzAAP,0016000000MDYTxAAP,0016000000MDYTrAAP,0016000000MDYSEAA5,0016000000LZvvFAAT,0016000000LBhQhAAL,0016000000Kr7yyAAB,0016000000KqG39AAF,0016000000KLnmlAAD,0016000000KLnkrAAD,0016000000yKequAAC,0016000000yIAQuAAO,0016000000yHfkbAAC,0016000000yHfhDAAS,0016000000xbtZEAAY,0016000000xbtJLAAY,0016000000sblXyAAI,0010z00001QJKrKAAX,0016000000WJkTCAA1,0016000000WJfNKAA1,0016000000NxBcHAAV,0016000000NxBb0AAF,0016000000NxBXNAA3,0016000000MDYTyAAP,0010z00001Qh7h8AAB,0010z00001NctC1AAJ,0016000000NxBbhAAF,0016000000zoP3UAAU,0016000000VOjfCAAT,0016000000MDYU0AAP,0016000000kpYqEAAU,0016000000coPNjAAM,0016000001EZBCiAAP,0016000001B8vjDAAR,00160000018pknCAAQ,00160000018nyX2AAI,00160000017Ph8fAAC,00160000014F2fUAAS,00160000013GVBjAAO,0016000000zoCf1AAE,0016000000znG9EAAU,0016000000z4sunAAA,0016000000z1pkoAAA,0016000000xfldzAAA,0016000001EZNytAAH,0016000001EZNyUAAX,0016000001EZNyPAAX,0016000001EZNxqAAH,0016000001EZNwOAAX,0016000001EZNvQAAX,0016000001EZNuwAAH,0016000001EZNuDAAX,0016000001EZNtUAAX,0016000001EZNiqAAH,0016000001EZNB7AAP,0016000001EZN7KAAX,0016000001EZMxxAAH,0016000001EZMrOAAX,0016000001EZMqkAAH,0016000001EZLRRAA5,0016000001EZLPoAAP,0016000001EZLKKAA5,0016000001EZLDwAAP,0016000001EZL9PAAX,0016000001EZ3SBAA1,0016000001EZ3OsAAL,0016000001EZ107AAD,0016000001EYxEUAA1,0016000001EYxDWAA1,0016000001EYuoIAAT,0016000001CrehsAAB,0016000001CrdywAAB,0016000001CrdgZAAR,0016000001Crb3VAAR,0016000001Crb3QAAR,0016000001Crb31AAB,0016000001Crb2cAAB,0016000001Crb2SAAR,0016000001CrapJAAR,0016000001CrYT5AAN,0016000001CrYSgAAN,0016000001CrYHmAAN,0016000001CrXt2AAF,0016000001CrVGgAAN,0016000001CrUabAAF,0016000001CrShIAAV,0016000001CrShDAAV,0016000001CrSh8AAF,0016000001CrSf2AAF,0016000001CrSZOAA3,0016000001CrSWXAA3,0016000001CrSQoAAN,0016000001CrSFFAA3,0016000001CrSD9AAN,0016000001CrSC6AAN,0016000001CrRtdAAF,0016000001CrP4JAAV,0016000001CrMFZAA3,0016000001CrMDEAA3,0016000001CrKlkAAF,0016000001CrKDoAAN,0016000001CrJjTAAV,0016000001CrJHXAA3,0016000001CrJHNAA3,0016000001CrJH8AAN,0016000001CrGUsAAN,0016000001CrFFJAA3,0016000001CrFCPAA3,0016000001CrFBMAA3,0016000001CrFAnAAN,0016000001CrFA4AAN,0016000001CrF9VAAV,0016000001CrF8VAAV,0016000001CrEtkAAF,0016000001CrDaKAAV,0016000001CrDWwAAN,0016000001CrDWSAA3,0016000001Cr8BxAAJ,0016000001Cr7wrAAB,0016000001Cr7k5AAB,0016000001Cr6YjAAJ,0016000001Cr6ObAAJ,0016000001Cr5ZQAAZ,0016000001Cr2BOAAZ,0016000001BA97WAAT,0016000001BA74KAAT,0016000001BA74FAAT,0016000001BA74AAAT,0016000001BA745AAD,0016000001BA740AAD,0016000001BA73qAAD,0016000001BA73lAAD,0016000001BA6aGAAT,0016000001BA6ZwAAL,0016000001BA3YcAAL,0016000001BA3WqAAL,0016000001BA2d5AAD,0016000001BA19cAAD,0016000001BA19XAAT,0016000001B9yyaAAB,0016000001B9ynHAAR,0016000001B9xOwAAJ,0016000001B9xOrAAJ,0016000001B9wnIAAR,0016000001B9wnDAAR,0016000001B9wn3AAB,0016000001B9wmyAAB,0016000001B9r4CAAR,0016000001B9nMtAAJ,0016000001B9m92AAB,0016000001B9hJIAAZ,0016000001B9ZtnAAF,0016000001B9Zn1AAF,0016000001B9Zd5AAF,0016000001B9ZcWAAV,0016000001B9ZcRAAV,0016000001B9ZcMAAV,0016000001B9ZcHAAV,0016000001B9ZcCAAV,0016000001B9Zc7AAF,0016000001B9VazAAF,0016000001B9TpPAAV,0016000001B9NaCAAV,0016000001B9MIBAA3,0016000001B9MHrAAN,0016000001B9JvuAAF,0016000001B9JvfAAF,0016000001B9JvVAAV,0016000001B9JvLAAV,0016000001B9JvGAAV,0016000001B9Jv6AAF,0016000001B9JurAAF,0016000001B9FiDAAV,0016000001B9FgbAAF,0016000001B9FfxAAF,0016000001B9FfOAAV,0016000001B9FeVAAV,0016000001B9FZuAAN,0016000001B9FVEAA3,0016000001B9FUfAAN,0016000001B9FTSAA3,0016000001B9Dq4AAF,0016000001B9AtJAAV,0016000001B96kiAAB,0016000001B96kTAAR,0016000001B96kJAAR,00160000015Z3u5AAC,00160000015Z3u0AAC,00160000015Z3tvAAC,00160000015Z3tgAAC,00160000015Z3tWAAS,00160000015Z3tRAAS,00160000015Z3tMAAS,00160000015Z3tHAAS,00160000015Z3t7AAC,00160000015Z3t2AAC,00160000015Z3sxAAC,00160000015Z3snAAC,00160000015Z3sjAAC,00160000015Z3siAAC,00160000015Z3sdAAC,00160000015Z3sYAAS,00160000015Z3sTAAS,00160000015Z3sOAAS,00160000015Z3sJAAS,00160000015XOfVAAW,00160000015XObYAAW,00160000015XOW4AAO,00160000015XOUmAAO,00160000015XOSqAAO,00160000015XGfGAAW,00160000015XGMiAAO,00160000015XCtPAAW,00160000015XCkbAAG,00160000015XAq0AAG,00160000015X91gAAC,00160000015X8qRAAS,00160000015WqMCAA0,00160000014yVEMAA2,00160000014xCtMAAU,001600000142XMhAAM,001600000142XMDAA2,0016000001EYteHAAT,0016000001EYptIAAT,0016000001EYpt8AAD,0016000001EYphqAAD,0016000001EYmhmAAD,0016000001EYkgKAAT,0016000001EYkesAAD,0016000001EYWF7AAP,0016000001EYWCrAAP,0016000001EYUYpAAP,0016000001EYU54AAH,0016000001EYU4aAAH,0016000001EYTvcAAH,0016000001EYRVKAA5,0016000001EYRURAA5,0016000001EYLjrAAH,0016000001EYLjhAAH,0016000001EYLjXAAX,0016000001EYLj3AAH,0016000001EYLiZAAX,0016000001EYLi5AAH,0016000001EYLhbAAH,0016000001EYDAUAA5,0016000001EYC0KAAX,0016000001EYBzqAAH,0016000001EYBIOAA5,0016000001EYBIJAA5,0016000001EYBI9AAP,0016000001EYBI4AAP,0016000001EYBHuAAP,0016000001EYBHkAAP,0016000001EYBHaAAP,0016000001EY7pZAAT,0016000001EY7pUAAT,0016000001EY51QAAT,0016000001EY50wAAD,0016000001EXq14AAD,0016000001CsKCrAAN,0016000001CsKBKAA3,0016000001CsIUXAA3,0016000001CsIUDAA3,0016000001CsISgAAN,0016000001CsHldAAF,0016000001CsECUAA3,0016000001CsDr4AAF,0016000001CsDonAAF,0016000001Cs4loAAB,0016000001CryfQAAR,0016000001CryeqAAB,0016000001CryegAAB,0016000001CryeDAAR,0016000001CryMYAAZ,0016000001CryIlAAJ,0016000001Cry2jAAB,0016000001Crxp6AAB,0016000001CrwrAAAR,0016000001Cruv3AAB,0016000001CrushAAB,0016000001CrusIAAR,0016000001Crur5AAB,0016000001CrqUQAAZ,0016000001CrqU6AAJ,0016000001Crpb8AAB,0016000001CrobDAAR,0016000001CroZcAAJ,0016000001CroZNAAZ,0016000001CroZDAAZ,0016000001CrlPSAAZ,0016000001CrlKwAAJ,0016000001Crl9AAAR,0016000001Crh5nAAB,0016000001Crh5YAAR,0016000001Crh5JAAR,0016000001Crh54AAB,0016000001CrfECAAZ,0016000001CrfE7AAJ,0016000001CrfDxAAJ,0016000001CrfDnAAJ,0016000001CrfDdAAJ,0016000001CrfDTAAZ,0016000001CrfDJAAZ,0016000001CrfD9AAJ,0016000001CrfD4AAJ,001600000142XKHAA2,001600000142WkOAAU,001600000142WihAAE,00160000013HxAtAAK,00160000013HnpKAAS,00160000013G1qqAAC,00160000013G1p4AAC,00160000013FmBRAA0,00160000013FTNvAAO,00160000013F8lJAAS,00160000011jSW6AAM,00160000011ihotAAA,00160000011ihoKAAQ,00160000011haGnAAI,00160000011hWIqAAM,00160000010xy1nAAA,0016000000znHz4AAE,0016000000zmoa5AAA,0016000000wmBOwAAM,0016000000wEDyuAAG,0016000000uCgtKAAS,0016000000rx9TtAAI,0016000000rx9TsAAI,0016000000r8e1pAAA,0016000000qCimSAAS,0016000000mpK75AAE,0016000000mpK33AAE,0016000000m0BltAAE,0016000000lzca9AAA,0016000000lzK1EAAU,0016000000iq2ADAAY,0016000000inGynAAE,0016000000gdd3YAAQ,0016000000eYHRoAAO,0016000000djORMAA2,0016000000coPNFAA2,0016000000coPM7AAM,0016000000coPKaAAM,0016000000QSdFvAAL,0016000000QSdE9AAL,0016000000QSdAsAAL,0010z00001QhaWQAAZ,0010z00001Oz5AxAAJ,0016000001K7w5HAAR,0016000001G2ZqmAAF,0016000001G1bbeAAB,00160000018q10tAAA,00160000018q0xkAAA,00160000018pxjcAAA,00160000018pxjIAAQ,00160000018px4AAAQ,00160000018pwQ7AAI,00160000018pwIcAAI,00160000018pwFnAAI,00160000018pwCFAAY,00160000018pt7yAAA,00160000018pkRwAAI,00160000018pgAfAAI,00160000018pbORAAY,00160000018pbFeAAI,00160000018pajWAAQ,00160000018pahVAAQ,00160000018pTBiAAM,00160000018pSDnAAM,00160000018pBY8AAM,00160000018pBXKAA2,00160000018p8ndAAA,00160000018orc5AAA,00160000018ohVrAAI,00160000018oWv1AAE,00160000018oWlLAAU,00160000018oWOyAAM,00160000018oWJeAAM,00160000018oPFPAA2,00160000018oClKAAU,00160000018oClAAAU,00160000018o2J4AAI,00160000018o2IpAAI,00160000018nhJJAAY,00160000018nTSTAA2,00160000018nTSOAA2,00160000018nLy9AAE,00160000018nLy4AAE,00160000018nLxuAAE,00160000018nLxpAAE,00160000018nLxfAAE,00160000018n48yAAA,00160000018mEeYAAU,00160000017Q0ZLAA0,00160000017PutNAAS,00160000017PbPtAAK,00160000017Pb8sAAC,00160000017OJZoAAO,00160000017NzlTAAS,00160000017NzioAAC,00160000017NcY6AAK,00160000017NZnRAAW,00160000017NZnHAAW,00160000017NZlGAAW,00160000017NZlBAAW,00160000017NZl6AAG,00160000017NZl1AAG,00160000017NZkwAAG,00160000017NZkrAAG,00160000017NZkmAAG,00160000017NZkhAAG,00160000017NZkcAAG,00160000017NZkXAAW,00160000017NZkSAAW,00160000017NZkIAAW,00160000017NZkDAAW,00160000017NZk3AAG,00160000017NSgOAAW,00160000017MKy4AAG,00160000016XInkAAG,00160000016XIlAAAW,00160000016WGvcAAG,00160000016WFiiAAG,00160000016WFcpAAG,00160000016WF8NAAW,00160000016WDUUAA4,00160000016W0rSAAS,00160000016W0YXAA0,00160000016Vv9hAAC,00160000016ThqpAAC,00160000016ThlzAAC,00160000016ThdgAAC,00160000016ThcYAAS,00160000016ThaIAAS,00160000016TcwgAAC,00160000015aMaGAAU,00160000015aAV1AAM,00160000015Z3uPAAS,00160000015Z3uKAAS,00160000015Z3uFAAS,00160000014vpCOAAY,00160000014vp79AAA,00160000014uzYJAAY,00160000014uxtKAAQ,00160000014HzRzAAK,00160000014HYMtAAO,00160000014HXMYAA4,00160000014HXKNAA4,00160000014HXFNAA4,00160000014Fw7rAAC,00160000014Fw3uAAC,00160000014FR8CAAW,00160000014F3xHAAS,0016000001B94bJAAR,0016000001B94b4AAB,0016000001B94apAAB,0016000001B94akAAB,0016000001B94afAAB,0016000001B94aaAAB,0016000001B94aVAAR,0016000001B94aQAAR,0016000001B94aLAAR,0016000001B92gPAAR,0016000001B91uhAAB,0016000001B912zAAB,0016000001B912uAAB,0016000001B912pAAB,0016000001B912kAAB,0016000001B8vVuAAJ,00160000018qA9QAAU,00160000018q89kAAA,00160000018q89aAAA,00160000018q89QAAQ,00160000018q89GAAQ,00160000018q54WAAQ,00160000018q53JAAQ,00160000018q534AAA,00160000018q4jTAAQ,00160000018q4i6AAA,00160000018q3QsAAI,00160000018q11IAAQ,0016000000QSdFhAAL,0016000000nP9cGAAS,0016000000mpptgAAA,0016000000kpYwPAAU,0016000000eYHRqAAO,0016000000QT9E1AAL,0016000000QSdB7AAL,0016000000Q13F1AAJ,0016000000ObpAOAAZ,0016000000nOxxMAAS,0016000000qCjoBAAS,0016000000inGjNAAU,0016000000eYHR4AAO,0016000000Ug151AAB,0016000000Obu49AAB,0010z00001UucM7AAJ,0016000000mmiQaAAI,0016000000eYbwLAAS,0016000000eYHQBAA4,0016000000LcdjOAAR,0016000000inH1EAAU,0016000000KLntiAAD,0016000000rx9W4AAI,0016000001EZZBtAAP,0016000000inK5UAAU,0016000000MDYSCAA5,0016000000iq2C9AAI,0016000000iq27QAAQ,0016000000inH1AAAU,0016000000inH18AAE,0016000000eYHQGAA4,0016000000QSdB9AAL,0016000000QSdB6AAL,0016000000MDYTuAAP,0016000000KLnwXAAT,0016000000KLnrRAAT,0016000000KLnqzAAD,0016000000KLnlyAAD,0016000000KLnkPAAT,0016000000oDBiEAAW,0016000000nOxwUAAS,0016000000lSLzUAAW,0016000000QSdBAAA1,0016000000QSdB8AAL,0016000000MDYTtAAP,0016000001Lf13PAAR,0016000001L0lvTAAR,0016000000eYHPuAAO,0016000000eYHPtAAO,0016000000QSdAqAAL,0016000000Mhc6jAAB,0016000000KLnjiAAD,0010z00001QgLbqAAF,0010z00001QNIXpAAP,0010z00001NedZvAAJ,0016000001IzbeVAAR,0016000001G2ldnAAB,0016000001Crl79AAB,00160000011ihc4AAA,0016000000xfdyAAAQ,0016000000xfcofAAA,0016000001B9YfOAAV,00160000018ot4BAAQ,00160000016TabgAAC,00160000015ZkwJAAS,00160000015XG7tAAG,00160000011hrFdAAI,00160000011hrEBAAY,00160000011hr2jAAA,00160000011hWYAAA2,00160000011hWW9AAM,00160000011hWU3AAM,00160000011hWH4AAM,00160000011hWFhAAM,00160000011hWDWAA2,00160000011hW8MAAU,00160000011hW7dAAE,00160000011hW6BAAU,00160000011hW2xAAE,00160000011hW1pAAE,00160000011hVzKAAU,00160000011hVuZAAU,00160000011hVpeAAE,00160000011h8zUAAQ,00160000011gu1zAAA,00160000011gjxmAAA,00160000011gHGSAA2,00160000011gHFUAA2,00160000011gHESAA2,00160000011gHCkAAM,00160000011gHC1AAM,00160000011gHBSAA2,00160000011gHAtAAM,00160000011gH9vAAE,00160000011gH8nAAE,00160000011gH6rAAE,00160000011gH5yAAE,00160000011gH4vAAE,00160000011gH2GAAU,00160000010zQOOAA2,00160000010yzTIAAY,00160000010yamNAAQ,00160000010ya5sAAA,00160000010ya1qAAA,00160000010yZc7AAE,00160000010yN3eAAE,00160000010yN1OAAU,00160000010yMyFAAU,00160000010yMwnAAE,00160000010yMvQAAU,00160000010yMtUAAU,00160000010yMrYAAU,00160000010yMmEAAU,00160000010yMjeAAE,00160000010yJfNAAU,00160000010wnH2AAI,00160000010wTPKAA2,0016000000qBZKNAA4,0016000000pcDsZAAU,0016000000papgQAAQ,0016000000lSLzFAAW,0016000000lSLxtAAG,0016000000lSLwmAAG,0016000000lSLvNAAW,0016000000kpZxfAAE,0016000000ip9hxAAA,0016000000inGyoAAE,0016000000gfQHQAA2,0016000000fiFKGAA2,0016000000eYHRuAAO,0016000000eYHQCAA4,0016000000eYHPvAAO,0016000000eYHPsAAO,0016000000cn29YAAQ,0016000000QSdAtAAL,0016000000QSdArAAL,0016000000ObHz3AAF,0016000000LtpgxAAB,0016000000LBp0JAAT,0016000000LBhEIAA1,0016000000KqEvdAAF,0016000000KqEvcAAF,0016000000KqEvbAAF,0016000000KLntcAAD,0016000000KLnrJAAT,0016000000KLnrFAAT,0016000000KLnqoAAD,0016000000KLnoiAAD,0016000000KLnn4AAD,0016000000KLnn3AAD,0016000000KLnn2AAD,0016000000KLnmvAAD,0016000000KLnkMAAT,0016000000KLnkLAAT,0016000000KLnkKAAT,0016000000KLnjgAAD,0016000000KLnjfAAD,0010z00001QhaXiAAJ,0010z00001QhaX4AAJ,0010z00001QNH3rAAH,0010z00001QNH3SAAX,0010z00001QJSX2AAP,0010z00001QJ4TIAA1,0010z00001QJ4HMAA1,0010z00001Oz6zgAAB,0010z00001NeYrQAAV,0010z00001NeY92AAF,0016000001K7xKYAAZ,0016000001L0jwZAAR,0016000001K7h3xAAB,0016000001GmbdNAAR,0016000000inGOfAAM,0010z00001Qh0AbAAJ,0010z00001Qh05qAAB,0016000001NhvGaAAJ,0016000001LdyLSAAZ,0016000001L0K6NAAV,0016000001L0KHUAA3,0016000001L0K0uAAF,0016000001L0IXpAAN,0016000001L0HrBAAV,0010z00001RkpuIAAR,0010z00001R1zTYAAZ,0010z00001R1yixAAB,0010z00001R1xZAAAZ,0010z00001R1rh1AAB,0010z00001QhfjzAAB,0016000001L0K4sAAF,0016000001L0JynAAF,0016000001L0JymAAF,0016000001L0JMxAAN,0016000001L0IPyAAN,0016000001L0JybAAF,0016000001L0JZIAA3,0016000001L0IzYAAV,0016000001L0IzXAAV,0016000001L0IPOAA3,0016000001L0J7qAAF,0016000001L0HyRAAV,0016000001L0JJzAAN,0010z00001Qh0AlAAJ,0016000001HdyMaAAJ,0016000001GOsCGAA1,0010z00001RlZQQAA3,0016000001GO6RhAAL,0016000001L0mLeAAJ,0016000001L0mGEAAZ,0016000001L0mGDAAZ,0016000001L0mGCAAZ,0016000001L0mGAAAZ,0016000001L0mG9AAJ,0016000001L0I4PAAV,0016000001L0HrHAAV,0010z00001RlJuPAAV,0016000001L0KFeAAN,0016000001L0K8vAAF,0016000001L0K8rAAF,0016000001L0K8IAAV,0016000001L0K0wAAF,0016000001L0Jm2AAF,0016000001L0JjiAAF,0016000001L0JeAAAV,0016000001L0Je5AAF,0016000001L0IyUAAV,0016000001L0IpHAAV,0016000001L0IojAAF,0016000001L0IidAAF,0016000001L0IgbAAF,0016000001L0IdQAAV,0016000001L0IarAAF,0016000001L0IZoAAN,0016000001L0IUsAAN,0016000001L0INlAAN,0016000001L0IMEAA3,0016000001L0IKYAA3,0016000001L0IK0AAN,0016000001L0IAdAAN,0016000001L0HzBAAV,0016000001L0IxUAAV,0016000001L0IHbAAN,0016000001L0HypAAF,0016000001L0HyGAAV,0016000001L0HrcAAF,0016000001L0IJbAAN,0016000001L0Iz0AAF,0016000001L0HrNAAV,0016000001L0HrFAAV,0016000001L0KIbAAN,0016000001L0JhKAAV,0016000001L0J2yAAF,0016000001L0HrGAAV,0016000001LhHPTAA3}'::text[])))
31. 0.000 0.000 ↓ 0.0 0

Index Only Scan using case_multi_column_idx on "case" case_2 (cost=0.08..1.98 rows=1 width=34) (never executed)

  • Index Cond: (sfid = (maintenance_impact__c_2.case__c)::text)
  • Heap Fetches: 0
32. 0.000 0.000 ↓ 0.0 0

Index Scan using service__c_temp_later_delete_sfid_key on service__c s_2 (cost=0.08..0.72 rows=1 width=47) (never executed)

  • Index Cond: ((sfid)::text = (maintenance_impact__c_2.service__c)::text)
Planning time : 21.889 ms