2025-03-17T04:39:03+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:39:03.149 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322524" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement:
2025-03-17T04:39:03+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_goc__configuration_item__c"
2025-03-17T04:39:03+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [12-3] #011                ON COMMIT PRESERVE ROWS
2025-03-17T04:39:03+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [12-4] #011                AS
2025-03-17T04:39:03+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [12-5] #011                  SELECT "goc__configuration_item_type__c","goc__path__c","name","goc__parent_configuration_item__c","isdeleted","systemmodstamp","createddate","goc__status__c","goc__isactive__c","sfid","goc__root_node__c", now() as deleteddate,
2025-03-17T04:39:03+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [12-6] #011                  ''::varchar(20) AS __operation
2025-03-17T04:39:03+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [12-7] #011                  FROM "salesforce"."goc__configuration_item__c" WITH NO DATA
2025-03-17T04:39:03+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [12-8]
2025-03-17T04:39:03+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [13-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:39:03.155 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322525" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE UNIQUE INDEX ON
2025-03-17T04:39:03+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [13-2] #011                         "_tmp_salesforce_goc__configuration_item__c" ("sfid")
2025-03-17T04:39:03+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:39:03.158 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322526" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_goc__configuration_item__c" (__operation, "sfid")
2025-03-17T04:39:11+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [15-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:39:11.874 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322527" tid="2272908" log_line="7" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8659.721 ms  statement:
2025-03-17T04:39:11+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:39:11+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [15-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:39:11+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [15-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:39:11+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [15-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:39:11+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [15-6]
2025-03-17T04:39:20+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [16-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:39:20.990 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322529" tid="2272913" log_line="8" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8711.541 ms  statement:
2025-03-17T04:39:20+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:39:20+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [16-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:39:20+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [16-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:39:20+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [16-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:39:20+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [16-6]
2025-03-17T04:39:30+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [17-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:39:30.101 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322531" tid="2272917" log_line="9" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8718.591 ms  statement:
2025-03-17T04:39:30+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:39:30+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [17-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:39:30+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [17-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:39:30+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [17-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:39:30+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [17-6]
2025-03-17T04:39:39+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [18-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:39:39.224 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322533" tid="2272920" log_line="10" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8730.213 ms  statement:
2025-03-17T04:39:39+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [18-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-17T04:39:39+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [18-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:39:39+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [18-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:39:39+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [18-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:39:39+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [18-6]
2025-03-17T04:39:49+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [19-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:39:49.489 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322535" tid="2272923" log_line="11" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8686.370 ms  statement:
2025-03-17T04:39:49+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:39:49+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [19-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:39:49+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [19-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:39:49+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [19-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:39:49+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [19-6]
2025-03-17T04:40:07+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [21-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:40:07.670 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322539" tid="2272929" log_line="13" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8675.727 ms  statement:
2025-03-17T04:40:07+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:40:07+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [21-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:40:07+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [21-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:40:07+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [21-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:40:07+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [21-6]
2025-03-17T04:40:16+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [22-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:40:16.741 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322541" tid="2272932" log_line="14" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8666.697 ms  statement:
2025-03-17T04:40:16+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [22-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-17T04:40:16+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [22-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:40:16+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [22-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:40:16+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [22-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:40:16+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [22-6]
2025-03-17T04:40:25+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [23-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:40:25.719 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322543" tid="2272935" log_line="15" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8569.023 ms  statement:
2025-03-17T04:40:25+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:40:25+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [23-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:40:25+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [23-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:40:25+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [23-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:40:25+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [23-6]
2025-03-17T04:40:43+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [25-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:40:43.959 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322547" tid="2272941" log_line="17" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8720.925 ms  statement:
2025-03-17T04:40:43+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:40:43+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [25-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:40:43+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [25-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:40:43+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [25-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:40:43+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [25-6]
2025-03-17T04:40:53+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [26-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:40:53.084 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322549" tid="2272945" log_line="18" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8718.385 ms  statement:
2025-03-17T04:40:53+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [26-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-17T04:40:53+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [26-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:40:53+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [26-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:40:53+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [26-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:40:53+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [26-6]
2025-03-17T04:41:02+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [27-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:41:02.094 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322551" tid="2272948" log_line="19" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8587.586 ms  statement:
2025-03-17T04:41:02+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:41:02+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [27-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:41:02+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [27-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:41:02+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [27-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:41:02+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [27-6]
2025-03-17T04:41:20+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [29-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:41:20.229 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322555" tid="2272954" log_line="21" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8566.840 ms  statement:
2025-03-17T04:41:20+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:41:20+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [29-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:41:20+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [29-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:41:20+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [29-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:41:20+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [29-6]
2025-03-17T04:41:29+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [30-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:41:29.177 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322557" tid="2272957" log_line="22" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8543.235 ms  statement:
2025-03-17T04:41:29+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:41:29+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [30-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:41:29+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [30-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:41:29+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [30-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:41:29+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [30-6]
2025-03-17T04:41:38+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [31-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:41:38.128 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322559" tid="2272960" log_line="23" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8549.864 ms  statement:
2025-03-17T04:41:38+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:41:38+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [31-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:41:38+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [31-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:41:38+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [31-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:41:38+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [31-6]
2025-03-17T04:41:56+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [33-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:41:56.428 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322563" tid="2272967" log_line="25" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8697.965 ms  statement:
2025-03-17T04:41:56+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:41:56+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [33-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:41:56+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [33-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:41:56+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [33-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:41:56+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [33-6]
2025-03-17T04:42:05+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [34-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:42:05.559 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322565" tid="2272970" log_line="26" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8732.642 ms  statement:
2025-03-17T04:42:05+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:42:05+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [34-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:42:05+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [34-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:42:05+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [34-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:42:05+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [34-6]
2025-03-17T04:42:14+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [35-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:42:14.645 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322567" tid="2272973" log_line="27" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8683.200 ms  statement:
2025-03-17T04:42:14+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:42:14+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [35-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:42:14+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [35-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:42:14+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [35-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:42:14+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [35-6]
2025-03-17T04:42:28+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [37-1]  sql_error_code = 00000 time_ms = "2025-03-17 04:42:28.011 UTC" pid="1448654" proc_start_time="2025-03-17 04:39:01 UTC" session_id="67d7a765.161ace" vtid="5/2322571" tid="2272979" log_line="29" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(56040)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 3996.510 ms  statement:
2025-03-17T04:42:28+00:00 ip-10-1-102-204 app[postgres.3738726] [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-17T04:42:28+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [37-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-17T04:42:28+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [37-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-17T04:42:28+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [37-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-17T04:42:28+00:00 ip-10-1-102-204 app[postgres.3738726] [DATABASE] [37-6]