2025-03-14T14:38:33+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [15-1]  sql_error_code = 00000 time_ms = "2025-03-14 14:38:33.229 UTC" pid="1401647" proc_start_time="2025-03-14 14:38:21 UTC" session_id="67d43f5d.15632f" vtid="12/173451" tid="2264298" log_line="7" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42962)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8667.940 ms  statement:
2025-03-14T14:38:33+00:00 ip-10-1-102-204 app[postgres.3183466] [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-14T14:38:33+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [15-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T14:38:33+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [15-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T14:38:33+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [15-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T14:38:33+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [15-6]
2025-03-14T14:38:42+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [16-1]  sql_error_code = 00000 time_ms = "2025-03-14 14:38:42.433 UTC" pid="1401647" proc_start_time="2025-03-14 14:38:21 UTC" session_id="67d43f5d.15632f" vtid="12/173453" tid="2264305" log_line="8" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42962)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8791.879 ms  statement:
2025-03-14T14:38:42+00:00 ip-10-1-102-204 app[postgres.3183466] [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-14T14:38:42+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [16-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T14:38:42+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [16-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T14:38:42+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [16-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T14:38:42+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [16-6]
2025-03-14T14:39:09+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [19-1]  sql_error_code = 00000 time_ms = "2025-03-14 14:39:09.400 UTC" pid="1401647" proc_start_time="2025-03-14 14:38:21 UTC" session_id="67d43f5d.15632f" vtid="12/173459" tid="2264321" log_line="11" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42962)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8555.121 ms  statement:
2025-03-14T14:39:09+00:00 ip-10-1-102-204 app[postgres.3183466] [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-14T14:39:09+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [19-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T14:39:09+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [19-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T14:39:09+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [19-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T14:39:09+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [19-6]
2025-03-14T14:39:18+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [20-1]  sql_error_code = 00000 time_ms = "2025-03-14 14:39:18.508 UTC" pid="1401647" proc_start_time="2025-03-14 14:38:21 UTC" session_id="67d43f5d.15632f" vtid="12/173461" tid="2264330" log_line="12" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42962)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8694.336 ms  statement:
2025-03-14T14:39:18+00:00 ip-10-1-102-204 app[postgres.3183466] [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-14T14:39:18+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [20-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T14:39:18+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [20-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T14:39:18+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [20-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T14:39:18+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [20-6]
2025-03-14T14:39:45+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [23-1]  sql_error_code = 00000 time_ms = "2025-03-14 14:39:45.411 UTC" pid="1401647" proc_start_time="2025-03-14 14:38:21 UTC" session_id="67d43f5d.15632f" vtid="12/173467" tid="2264348" log_line="15" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42962)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8537.842 ms  statement:
2025-03-14T14:39:45+00:00 ip-10-1-102-204 app[postgres.3183466] [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-14T14:39:45+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [23-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T14:39:45+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [23-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T14:39:45+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [23-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T14:39:45+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [23-6]
2025-03-14T14:39:54+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [24-1]  sql_error_code = 00000 time_ms = "2025-03-14 14:39:54.368 UTC" pid="1401647" proc_start_time="2025-03-14 14:38:21 UTC" session_id="67d43f5d.15632f" vtid="12/173469" tid="2264351" log_line="16" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42962)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8534.854 ms  statement:
2025-03-14T14:39:54+00:00 ip-10-1-102-204 app[postgres.3183466] [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-14T14:39:54+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [24-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T14:39:54+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [24-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T14:39:54+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [24-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T14:39:54+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [24-6]
2025-03-14T14:40:21+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [27-1]  sql_error_code = 00000 time_ms = "2025-03-14 14:40:21.330 UTC" pid="1401647" proc_start_time="2025-03-14 14:38:21 UTC" session_id="67d43f5d.15632f" vtid="12/173475" tid="2264363" log_line="19" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42962)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8576.226 ms  statement:
2025-03-14T14:40:21+00:00 ip-10-1-102-204 app[postgres.3183466] [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-14T14:40:21+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [27-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T14:40:21+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [27-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T14:40:21+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [27-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T14:40:21+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [27-6]
2025-03-14T14:40:48+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [30-1]  sql_error_code = 00000 time_ms = "2025-03-14 14:40:48.183 UTC" pid="1401647" proc_start_time="2025-03-14 14:38:21 UTC" session_id="67d43f5d.15632f" vtid="12/173481" tid="2264384" log_line="22" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42962)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8521.433 ms  statement:
2025-03-14T14:40:48+00:00 ip-10-1-102-204 app[postgres.3183466] [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-14T14:40:48+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [30-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T14:40:48+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [30-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T14:40:48+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [30-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T14:40:48+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [30-6]
2025-03-14T14:40:57+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [31-1]  sql_error_code = 00000 time_ms = "2025-03-14 14:40:57.166 UTC" pid="1401647" proc_start_time="2025-03-14 14:38:21 UTC" session_id="67d43f5d.15632f" vtid="12/173483" tid="2264388" log_line="23" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42962)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8572.667 ms  statement:
2025-03-14T14:40:57+00:00 ip-10-1-102-204 app[postgres.3183466] [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-14T14:40:57+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [31-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T14:40:57+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [31-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T14:40:57+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [31-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T14:40:57+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [31-6]
2025-03-14T14:41:24+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [34-1]  sql_error_code = 00000 time_ms = "2025-03-14 14:41:24.196 UTC" pid="1401647" proc_start_time="2025-03-14 14:38:21 UTC" session_id="67d43f5d.15632f" vtid="12/173489" tid="2264397" log_line="26" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42962)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8554.915 ms  statement:
2025-03-14T14:41:24+00:00 ip-10-1-102-204 app[postgres.3183466] [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-14T14:41:24+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [34-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T14:41:24+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [34-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T14:41:24+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [34-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T14:41:24+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [34-6]
2025-03-14T14:41:33+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [35-1]  sql_error_code = 00000 time_ms = "2025-03-14 14:41:33.147 UTC" pid="1401647" proc_start_time="2025-03-14 14:38:21 UTC" session_id="67d43f5d.15632f" vtid="12/173491" tid="2264400" log_line="27" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(42962)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8533.104 ms  statement:
2025-03-14T14:41:33+00:00 ip-10-1-102-204 app[postgres.3183466] [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-14T14:41:33+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [35-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-14T14:41:33+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [35-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-14T14:41:33+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [35-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-14T14:41:33+00:00 ip-10-1-102-204 app[postgres.3183466] [DATABASE] [35-6]