2025-03-14T16:38:51+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [17-1]  sql_error_code = 00000 time_ms = "2025-03-14 16:38:51.290 UTC" pid="1403620" proc_start_time="2025-03-14 16:38:22 UTC" session_id="67d45b7e.156ae4" vtid="2/1744547" tid="2264812" log_line="9" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42238)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8844.623 ms  statement:
2025-03-14T16:38:51+00:00 ip-10-1-102-204 app[postgres.3201195] [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-14T16:38:51+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [17-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T16:38:51+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [17-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T16:38:51+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [17-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T16:38:51+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [17-6]
2025-03-14T16:39:27+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [21-1]  sql_error_code = 00000 time_ms = "2025-03-14 16:39:27.791 UTC" pid="1403620" proc_start_time="2025-03-14 16:38:22 UTC" session_id="67d45b7e.156ae4" vtid="2/1744555" tid="2264826" log_line="13" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42238)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8761.449 ms  statement:
2025-03-14T16:39:27+00:00 ip-10-1-102-204 app[postgres.3201195] [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-14T16:39:27+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [21-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T16:39:27+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [21-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T16:39:27+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [21-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T16:39:27+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [21-6]
2025-03-14T16:40:04+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [25-1]  sql_error_code = 00000 time_ms = "2025-03-14 16:40:04.162 UTC" pid="1403620" proc_start_time="2025-03-14 16:38:22 UTC" session_id="67d45b7e.156ae4" vtid="2/1744563" tid="2264840" log_line="17" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42238)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8668.520 ms  statement:
2025-03-14T16:40:04+00:00 ip-10-1-102-204 app[postgres.3201195] [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-14T16:40:04+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [25-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T16:40:04+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [25-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T16:40:04+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [25-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T16:40:04+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [25-6]
2025-03-14T16:40:41+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [29-1]  sql_error_code = 00000 time_ms = "2025-03-14 16:40:41.576 UTC" pid="1403620" proc_start_time="2025-03-14 16:38:22 UTC" session_id="67d45b7e.156ae4" vtid="2/1744571" tid="2264852" log_line="21" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42238)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8602.191 ms  statement:
2025-03-14T16:40:41+00:00 ip-10-1-102-204 app[postgres.3201195] [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-14T16:40:41+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [29-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T16:40:41+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [29-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T16:40:41+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [29-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T16:40:41+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [29-6]
2025-03-14T16:41:17+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [33-1]  sql_error_code = 00000 time_ms = "2025-03-14 16:41:17.503 UTC" pid="1403620" proc_start_time="2025-03-14 16:38:22 UTC" session_id="67d45b7e.156ae4" vtid="2/1744579" tid="2264865" log_line="25" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42238)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8581.312 ms  statement:
2025-03-14T16:41:17+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [33-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-14T16:41:17+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [33-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T16:41:17+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [33-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T16:41:17+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [33-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T16:41:17+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [33-6]
2025-03-14T16:41:50+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [37-1]  sql_error_code = 00000 time_ms = "2025-03-14 16:41:50.511 UTC" pid="1403620" proc_start_time="2025-03-14 16:38:22 UTC" session_id="67d45b7e.156ae4" vtid="2/1744587" tid="2264877" log_line="29" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42238)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 5665.527 ms  statement:
2025-03-14T16:41:50+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [37-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-14T16:41:50+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [37-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T16:41:50+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [37-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T16:41:50+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [37-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T16:41:50+00:00 ip-10-1-102-204 app[postgres.3201195] [DATABASE] [37-6]