2025-03-15T00:38:29+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:38:29.566 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763516" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement:
2025-03-15T00:38:29+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_goc__configuration_item__c"
2025-03-15T00:38:29+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [12-3] #011                ON COMMIT PRESERVE ROWS
2025-03-15T00:38:29+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [12-4] #011                AS
2025-03-15T00:38:29+00:00 ip-10-1-102-204 app[postgres.3277931] [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-15T00:38:29+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [12-6] #011                  ''::varchar(20) AS __operation
2025-03-15T00:38:29+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [12-7] #011                  FROM "salesforce"."goc__configuration_item__c" WITH NO DATA
2025-03-15T00:38:29+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [12-8]
2025-03-15T00:38:29+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [13-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:38:29.570 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763517" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE UNIQUE INDEX ON
2025-03-15T00:38:29+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [13-2] #011                         "_tmp_salesforce_goc__configuration_item__c" ("sfid")
2025-03-15T00:38:29+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:38:29.572 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763518" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_goc__configuration_item__c" (__operation, "sfid")
2025-03-15T00:39:05+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [18-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:39:05.330 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763525" tid="2267409" log_line="10" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8576.714 ms  statement:
2025-03-15T00:39:05+00:00 ip-10-1-102-204 app[postgres.3277931] [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-15T00:39:05+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [18-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-15T00:39:05+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [18-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:39:05+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [18-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:39:05+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [18-6]
2025-03-15T00:39:41+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [22-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:39:41.287 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763533" tid="2267421" log_line="14" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8581.700 ms  statement:
2025-03-15T00:39:41+00:00 ip-10-1-102-204 app[postgres.3277931] [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-15T00:39:41+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [22-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-15T00:39:41+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [22-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:39:41+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [22-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:39:41+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [22-6]
2025-03-15T00:40:17+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [26-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:40:17.339 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763541" tid="2267433" log_line="18" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8580.774 ms  statement:
2025-03-15T00:40:17+00:00 ip-10-1-102-204 app[postgres.3277931] [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-15T00:40:17+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [26-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-15T00:40:17+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [26-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:40:17+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [26-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:40:17+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [26-6]
2025-03-15T00:40:45+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [29-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:40:45.447 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763547" tid="2267448" log_line="21" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8593.905 ms  statement:
2025-03-15T00:40:45+00:00 ip-10-1-102-204 app[postgres.3277931] [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-15T00:40:45+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [29-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-15T00:40:45+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [29-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:40:45+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [29-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:40:45+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [29-6]
2025-03-15T00:41:12+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [32-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:41:12.646 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763553" tid="2267458" log_line="24" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8628.123 ms  statement:
2025-03-15T00:41:12+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [32-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:12+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [32-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-15T00:41:12+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [32-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:41:12+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [32-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:41:12+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [32-6]
2025-03-15T00:41:48+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [36-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:41:48.766 UTC" pid="1411542" proc_start_time="2025-03-15 00:38:27 UTC" session_id="67d4cc03.1589d6" vtid="2/1763561" tid="2267470" log_line="28" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(49722)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8664.521 ms  statement:
2025-03-15T00:41:48+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [36-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:48+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [36-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s
2025-03-15T00:41:48+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [36-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:41:48+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [36-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:41:48+00:00 ip-10-1-102-204 app[postgres.3277931] [DATABASE] [36-6]