2025-03-14T12:38:30+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [15-1]  sql_error_code = 00000 time_ms = "2025-03-14 12:38:30.834 UTC" pid="1400151" proc_start_time="2025-03-14 12:38:20 UTC" session_id="67d4233c.155d57" vtid="6/5664969" tid="2264055" log_line="7" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(50660)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8583.273 ms  statement:
2025-03-14T12:38:30+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [15-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-14T12:38:30+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [15-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T12:38:30+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [15-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T12:38:30+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [15-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T12:38:30+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [15-6]
2025-03-14T12:39:06+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [19-1]  sql_error_code = 00000 time_ms = "2025-03-14 12:39:06.826 UTC" pid="1400151" proc_start_time="2025-03-14 12:38:20 UTC" session_id="67d4233c.155d57" vtid="6/5664977" tid="2264069" log_line="11" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(50660)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8523.579 ms  statement:
2025-03-14T12:39:06+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [19-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-14T12:39:06+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [19-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T12:39:06+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [19-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T12:39:06+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [19-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T12:39:06+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [19-6]
2025-03-14T12:39:42+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [23-1]  sql_error_code = 00000 time_ms = "2025-03-14 12:39:42.707 UTC" pid="1400151" proc_start_time="2025-03-14 12:38:20 UTC" session_id="67d4233c.155d57" vtid="6/5664985" tid="2264081" log_line="15" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(50660)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8520.570 ms  statement:
2025-03-14T12:39:42+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [23-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-14T12:39:42+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [23-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T12:39:42+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [23-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T12:39:42+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [23-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T12:39:42+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [23-6]
2025-03-14T12:40:19+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [27-1]  sql_error_code = 00000 time_ms = "2025-03-14 12:40:19.667 UTC" pid="1400151" proc_start_time="2025-03-14 12:38:20 UTC" session_id="67d4233c.155d57" vtid="6/5664993" tid="2264095" log_line="19" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(50660)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8556.848 ms  statement:
2025-03-14T12:40:19+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [27-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-14T12:40:19+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [27-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T12:40:19+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [27-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T12:40:19+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [27-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T12:40:19+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [27-6]
2025-03-14T12:40:55+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [31-1]  sql_error_code = 00000 time_ms = "2025-03-14 12:40:55.470 UTC" pid="1400151" proc_start_time="2025-03-14 12:38:20 UTC" session_id="67d4233c.155d57" vtid="6/5665001" tid="2264107" log_line="23" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(50660)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8535.867 ms  statement:
2025-03-14T12:40:55+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [31-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-14T12:40:55+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [31-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T12:40:55+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [31-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T12:40:55+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [31-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T12:40:55+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [31-6]
2025-03-14T12:41:31+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [35-1]  sql_error_code = 00000 time_ms = "2025-03-14 12:41:31.354 UTC" pid="1400151" proc_start_time="2025-03-14 12:38:20 UTC" session_id="67d4233c.155d57" vtid="6/5665009" tid="2264121" log_line="27" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(50660)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8531.321 ms  statement:
2025-03-14T12:41:31+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [35-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-14T12:41:31+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [35-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T12:41:31+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [35-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T12:41:31+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [35-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T12:41:31+00:00 ip-10-1-102-204 app[postgres.3165951] [DATABASE] [35-6]