2025-03-15T00:38:47+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [16-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:38:47.308 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763521" tid="2267403" log_line="8" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8654.500 ms  statement:
2025-03-15T00:38:47+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [16-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-15T00:38:47+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [16-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-15T00:38:47+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [16-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:38:47+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [16-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:38:47+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [16-6]
2025-03-15T00:39:23+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [20-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:39:23.323 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763529" tid="2267415" log_line="12" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8613.780 ms  statement:
2025-03-15T00:39:23+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [20-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-15T00:39:23+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [20-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-15T00:39:23+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [20-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:39:23+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [20-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:39:23+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [20-6]
2025-03-15T00:39:59+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [24-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:39:59.238 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763537" tid="2267427" log_line="16" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8592.196 ms  statement:
2025-03-15T00:39:59+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [24-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-15T00:39:59+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [24-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-15T00:39:59+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [24-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:39:59+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [24-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:39:59+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [24-6]
2025-03-15T00:40:26+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [27-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:40:26.386 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763543" tid="2267437" log_line="19" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8656.273 ms  statement:
2025-03-15T00:40:26+00:00 ip-10-1-102-204 app[postgres.3277931] [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-15T00:40:26+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [27-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-15T00:40:26+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [27-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:40:26+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [27-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:40:26+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [27-6]
2025-03-15T00:40:54+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [30-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:40:54.568 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763549" tid="2267451" log_line="22" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8714.313 ms  statement:
2025-03-15T00:40:54+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [30-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-15T00:40:54+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [30-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-15T00:40:54+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [30-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:40:54+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [30-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:40:54+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [30-6]
2025-03-15T00:41:30+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [34-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:41:30.711 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763557" tid="2267464" log_line="26" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8625.955 ms  statement:
2025-03-15T00:41:30+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [34-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-15T00:41:30+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [34-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-15T00:41:30+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [34-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:41:30+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [34-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:41:30+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [34-6]
2025-03-15T00:42:06+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [38-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:42:06.069 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763565" tid="2267476" log_line="30" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 7867.075 ms  statement:
2025-03-15T00:42:06+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [38-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-15T00:42:06+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [38-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-15T00:42:06+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [38-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:42:06+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [38-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:42:06+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [38-6]