{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [15-1]  sql_error_code = 00000 time_ms = \"2025-03-14 16:30:27.304 UTC\" pid=\"1403453\" proc_start_time=\"2025-03-14 16:30:16 UTC\" session_id=\"67d45998.156a3d\" vtid=\"2\/1743642\" tid=\"2264751\" log_line=\"7\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(37142)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 3494.659 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:30:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3199945", "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-14T16:30:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3199945", "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-14T16:30:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3199945", "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-14T16:30:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3199945", "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-14T16:30:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3199945", "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-14T16:30:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3199945", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}