{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[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:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:20+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-2] #011                CREATE TEMPORARY TABLE \"_tmp_salesforce_user\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:20+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-3] #011                ON COMMIT PRESERVE ROWS", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:20+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-4] #011                AS", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:20+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-5] #011                  SELECT \"sfid\",\"managerid\",\"name\",\"isactive\",\"systemmodstamp\",\"username\",\"createddate\",\"slack_id__c\",\"email\", now() as deleteddate,", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:20+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-6] #011                  ''::varchar(20) AS __operation", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:20+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-7] #011                  FROM \"salesforce\".\"user\" WITH NO DATA", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:20+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-8]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:20+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[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", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:20+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [13-2] #011                         \"_tmp_salesforce_user\" (\"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:20+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[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\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:20+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[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:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[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\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [15-3] #011        FROM \"_tmp_salesforce_user\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [15-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t.\"systemmodstamp\" IS NULL OR s.\"systemmodstamp\" >= t.\"systemmodstamp\") AND", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [15-5] #011            ((t.\"sfid\" IS NOT NULL AND t.\"sfid\" = s.\"sfid\") )", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}
{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [15-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:30:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3276695", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}