2025-03-17T08:39:05+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [12-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:05.490 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984780" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [12-2] #011 CREATE TEMPORARY TABLE "_tmp_salesforce_goc__configuration_item__c" 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [12-3] #011 ON COMMIT PRESERVE ROWS 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [12-4] #011 AS 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app[postgres.3775215] [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-17T08:39:05+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [12-6] #011 ''::varchar(20) AS __operation 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [12-7] #011 FROM "salesforce"."goc__configuration_item__c" WITH NO DATA 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [12-8] 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [13-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:05.497 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984781" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE UNIQUE INDEX ON 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [13-2] #011 "_tmp_salesforce_goc__configuration_item__c" ("sfid") 2025-03-17T08:39:05+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [14-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:05.501 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984782" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE INDEX ON "_tmp_salesforce_goc__configuration_item__c" (__operation, "sfid") 2025-03-17T08:39:42+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [18-1] sql_error_code = 00000 time_ms = "2025-03-17 08:39:42.784 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984789" tid="2273657" log_line="10" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8614.884 ms statement: 2025-03-17T08:39:42+00:00 ip-10-1-102-204 app[postgres.3775215] [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-17T08:39:42+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [18-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s 2025-03-17T08:39:42+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [18-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND 2025-03-17T08:39:42+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [18-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") ) 2025-03-17T08:39:42+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [18-6] 2025-03-17T08:40:18+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [22-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:18.866 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984797" tid="2273673" log_line="14" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8696.811 ms statement: 2025-03-17T08:40:18+00:00 ip-10-1-102-204 app[postgres.3775215] [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-17T08:40:18+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [22-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s 2025-03-17T08:40:18+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [22-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND 2025-03-17T08:40:18+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [22-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") ) 2025-03-17T08:40:18+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [22-6] 2025-03-17T08:40:55+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [26-1] sql_error_code = 00000 time_ms = "2025-03-17 08:40:55.229 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984805" tid="2273692" log_line="18" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8676.329 ms statement: 2025-03-17T08:40:55+00:00 ip-10-1-102-204 app[postgres.3775215] [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-17T08:40:55+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [26-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s 2025-03-17T08:40:55+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [26-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND 2025-03-17T08:40:55+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [26-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") ) 2025-03-17T08:40:55+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [26-6] 2025-03-17T08:41:31+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [30-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:31.494 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984813" tid="2273705" log_line="22" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8517.792 ms statement: 2025-03-17T08:41:31+00:00 ip-10-1-102-204 app[postgres.3775215] [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-17T08:41:31+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [30-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s 2025-03-17T08:41:31+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [30-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND 2025-03-17T08:41:31+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [30-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") ) 2025-03-17T08:41:31+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [30-6] 2025-03-17T08:41:58+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [33-1] sql_error_code = 00000 time_ms = "2025-03-17 08:41:58.771 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984819" tid="2273714" log_line="25" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 8654.805 ms statement: 2025-03-17T08:41:58+00:00 ip-10-1-102-204 app[postgres.3775215] [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-17T08:41:58+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [33-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s 2025-03-17T08:41:58+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [33-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND 2025-03-17T08:41:58+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [33-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") ) 2025-03-17T08:41:58+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [33-6] 2025-03-17T08:42:30+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [37-1] sql_error_code = 00000 time_ms = "2025-03-17 08:42:30.164 UTC" pid="1452421" proc_start_time="2025-03-17 08:39:03 UTC" session_id="67d7dfa7.162985" vtid="6/5984827" tid="2273726" log_line="29" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(40078)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: duration: 3955.429 ms statement: 2025-03-17T08:42:30+00:00 ip-10-1-102-204 app[postgres.3775215] [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-17T08:42:30+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [37-3] #011 FROM "_tmp_salesforce_goc__configuration_item__c" AS s 2025-03-17T08:42:30+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [37-4] #011 WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND 2025-03-17T08:42:30+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [37-5] #011 ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") ) 2025-03-17T08:42:30+00:00 ip-10-1-102-204 app[postgres.3775215] [DATABASE] [37-6]