2025-03-17T08:39:32+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [17-1]  sql_error_code = 00000 time_ms = "2025-03-17 08:39:32.319 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984787" tid="2273646" log_line="9" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8738.889 ms  statement:
2025-03-17T08:39:32+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [17-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"
2025-03-17T08:39:32+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [17-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T08:39:32+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [17-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T08:39:32+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [17-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T08:39:32+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [17-6]
2025-03-17T08:40:09+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [21-1]  sql_error_code = 00000 time_ms = "2025-03-17 08:40:09.741 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984795" tid="2273670" log_line="13" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8515.906 ms  statement:
2025-03-17T08:40:09+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [21-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"
2025-03-17T08:40:09+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [21-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T08:40:09+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [21-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T08:40:09+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [21-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T08:40:09+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [21-6]
2025-03-17T08:40:46+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [25-1]  sql_error_code = 00000 time_ms = "2025-03-17 08:40:46.120 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984803" tid="2273689" log_line="17" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8599.407 ms  statement:
2025-03-17T08:40:46+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [25-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"
2025-03-17T08:40:46+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [25-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T08:40:46+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [25-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T08:40:46+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [25-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T08:40:46+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [25-6]
2025-03-17T08:41:22+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [29-1]  sql_error_code = 00000 time_ms = "2025-03-17 08:41:22.553 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984811" tid="2273702" log_line="21" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8672.811 ms  statement:
2025-03-17T08:41:22+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [29-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"
2025-03-17T08:41:22+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [29-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T08:41:22+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [29-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T08:41:22+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [29-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T08:41:22+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [29-6]
2025-03-17T08:41:49+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [32-1]  sql_error_code = 00000 time_ms = "2025-03-17 08:41:49.693 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984817" tid="2273711" log_line="24" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8708.604 ms  statement:
2025-03-17T08:41:49+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [32-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"
2025-03-17T08:41:49+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [32-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T08:41:49+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [32-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T08:41:49+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [32-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T08:41:49+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [32-6]
2025-03-17T08:42:25+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [36-1]  sql_error_code = 00000 time_ms = "2025-03-17 08:42:25.958 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984825" tid="2273723" log_line="28" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8509.479 ms  statement:
2025-03-17T08:42:25+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [36-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"
2025-03-17T08:42:25+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [36-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T08:42:25+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [36-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T08:42:25+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [36-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T08:42:25+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [36-6]