{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [17-1]  sql_error_code = 00000 time_ms = \"2025-03-14 16:38:51.290 UTC\" pid=\"1403620\" proc_start_time=\"2025-03-14 16:38:22 UTC\" session_id=\"67d45b7e.156ae4\" vtid=\"2\/1744547\" tid=\"2264812\" log_line=\"9\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(42238)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8844.623 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:38:51+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [17-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\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:38:51+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [17-3] #011        FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:38:51+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [17-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:38:51+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [17-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:38:51+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [17-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:38:51+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [21-1]  sql_error_code = 00000 time_ms = \"2025-03-14 16:39:27.791 UTC\" pid=\"1403620\" proc_start_time=\"2025-03-14 16:38:22 UTC\" session_id=\"67d45b7e.156ae4\" vtid=\"2\/1744555\" tid=\"2264826\" log_line=\"13\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(42238)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8761.449 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:39:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [21-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\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:39:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [21-3] #011        FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:39:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [21-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:39:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [21-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:39:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [21-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:39:27+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [25-1]  sql_error_code = 00000 time_ms = \"2025-03-14 16:40:04.162 UTC\" pid=\"1403620\" proc_start_time=\"2025-03-14 16:38:22 UTC\" session_id=\"67d45b7e.156ae4\" vtid=\"2\/1744563\" tid=\"2264840\" log_line=\"17\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(42238)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8668.520 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:40:04+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [25-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\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:40:04+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [25-3] #011        FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:40:04+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [25-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:40:04+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [25-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:40:04+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [25-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:40:04+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [29-1]  sql_error_code = 00000 time_ms = \"2025-03-14 16:40:41.576 UTC\" pid=\"1403620\" proc_start_time=\"2025-03-14 16:38:22 UTC\" session_id=\"67d45b7e.156ae4\" vtid=\"2\/1744571\" tid=\"2264852\" log_line=\"21\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(42238)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8602.191 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:40:41+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [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\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:40:41+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [29-3] #011        FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:40:41+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [29-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:40:41+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [29-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:40:41+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [29-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:40:41+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [33-1]  sql_error_code = 00000 time_ms = \"2025-03-14 16:41:17.503 UTC\" pid=\"1403620\" proc_start_time=\"2025-03-14 16:38:22 UTC\" session_id=\"67d45b7e.156ae4\" vtid=\"2\/1744579\" tid=\"2264865\" log_line=\"25\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(42238)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8581.312 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:41:17+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [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\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:41:17+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [33-3] #011        FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:41:17+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [33-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:41:17+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [33-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:41:17+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [33-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:41:17+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [37-1]  sql_error_code = 00000 time_ms = \"2025-03-14 16:41:50.511 UTC\" pid=\"1403620\" proc_start_time=\"2025-03-14 16:38:22 UTC\" session_id=\"67d45b7e.156ae4\" vtid=\"2\/1744587\" tid=\"2264877\" log_line=\"29\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(42238)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 5665.527 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:41:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [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\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:41:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [37-3] #011        FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:41:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [37-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:41:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [37-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:41:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "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] [37-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T16:41:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3201195", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}