{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [16-1] sql_error_code = 00000 time_ms = \"2025-03-15 00:38:47.308 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763521\" tid=\"2267403\" log_line=\"8\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8654.500 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:38:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [16-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-15T00:38:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [16-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-15T00:38:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [16-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:38:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [16-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:38:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [16-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:38:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [20-1] sql_error_code = 00000 time_ms = \"2025-03-15 00:39:23.323 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763529\" tid=\"2267415\" log_line=\"12\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8613.780 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:39:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [20-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-15T00:39:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [20-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-15T00:39:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [20-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:39:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [20-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:39:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [20-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:39:23+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [24-1] sql_error_code = 00000 time_ms = \"2025-03-15 00:39:59.238 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763537\" tid=\"2267427\" log_line=\"16\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8592.196 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:39:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [24-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-15T00:39:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [24-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-15T00:39:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [24-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:39:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [24-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:39:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [24-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:39:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [27-1] sql_error_code = 00000 time_ms = \"2025-03-15 00:40:26.386 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763543\" tid=\"2267437\" log_line=\"19\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8656.273 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [27-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-15T00:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [27-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-15T00:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [27-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:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [27-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:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [27-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:40:26+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [30-1] sql_error_code = 00000 time_ms = \"2025-03-15 00:40:54.568 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763549\" tid=\"2267451\" log_line=\"22\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8714.313 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:40:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [30-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-15T00:40:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [30-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-15T00:40:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [30-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:40:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [30-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:40:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [30-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:40:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [34-1] sql_error_code = 00000 time_ms = \"2025-03-15 00:41:30.711 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763557\" tid=\"2267464\" log_line=\"26\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 8625.955 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:41:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [34-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-15T00:41:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [34-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-15T00:41:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [34-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:41:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [34-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:41:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [34-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:41:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [38-1] sql_error_code = 00000 time_ms = \"2025-03-15 00:42:06.069 UTC\" pid=\"1411542\" proc_start_time=\"2025-03-15 00:38:27 UTC\" session_id=\"67d4cc03.1589d6\" vtid=\"2\/1763565\" tid=\"2267476\" log_line=\"30\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(49722)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: duration: 7867.075 ms statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [38-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-15T00:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [38-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-15T00:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [38-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:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [38-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:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "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] [38-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:42:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3277931", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}