2025-03-15T00:30:20+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:30:20.936 UTC" pid="1411386" proc_start_time="2025-03-15 00:30:17 UTC" session_id="67d4ca19.15893a" vtid="2/1762686" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(57644)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement:
2025-03-15T00:30:20+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_user"
2025-03-15T00:30:20+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [12-3] #011                ON COMMIT PRESERVE ROWS
2025-03-15T00:30:20+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [12-4] #011                AS
2025-03-15T00:30:20+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [12-5] #011                  SELECT "sfid","managerid","name","isactive","systemmodstamp","username","createddate","slack_id__c","email", now() as deleteddate,
2025-03-15T00:30:20+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [12-6] #011                  ''::varchar(20) AS __operation
2025-03-15T00:30:20+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [12-7] #011                  FROM "salesforce"."user" WITH NO DATA
2025-03-15T00:30:20+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [12-8]
2025-03-15T00:30:20+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [13-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:30:20.939 UTC" pid="1411386" proc_start_time="2025-03-15 00:30:17 UTC" session_id="67d4ca19.15893a" vtid="2/1762687" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(57644)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE UNIQUE INDEX ON
2025-03-15T00:30:20+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [13-2] #011                         "_tmp_salesforce_user" ("sfid")
2025-03-15T00:30:20+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:30:20.942 UTC" pid="1411386" proc_start_time="2025-03-15 00:30:17 UTC" session_id="67d4ca19.15893a" vtid="2/1762688" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(57644)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_user" (__operation, "sfid")
2025-03-15T00:30:23+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [15-1]  sql_error_code = 00000 time_ms = "2025-03-15 00:30:23.008 UTC" pid="1411386" proc_start_time="2025-03-15 00:30:17 UTC" session_id="67d4ca19.15893a" vtid="2/1762689" tid="2267369" log_line="7" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(57644)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 2018.332 ms  statement:
2025-03-15T00:30:23+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [15-2] #011        UPDATE "salesforce"."user" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"managerid"=s."managerid","name"=s."name","isactive"=s."isactive","systemmodstamp"=s."systemmodstamp","username"=s."username","createddate"=s."createddate","slack_id__c"=s."slack_id__c","email"=s."email"
2025-03-15T00:30:23+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [15-3] #011        FROM "_tmp_salesforce_user" AS s
2025-03-15T00:30:23+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [15-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND
2025-03-15T00:30:23+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [15-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )
2025-03-15T00:30:23+00:00 ip-10-1-102-204 app[postgres.3276695] [DATABASE] [15-6]