{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [15-1]  sql_error_code = 00000 time_ms = \"2025-03-14 18:38:33.877 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692646\" tid=\"2265312\" log_line=\"7\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8654.799 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:38:33+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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\".\"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-14T18:38:33+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:38:33+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:38:33+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:38:33+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:38:33+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-1]  sql_error_code = 00000 time_ms = \"2025-03-14 18:38:43.097 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692648\" tid=\"2265321\" log_line=\"8\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8802.886 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:38:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:38:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:38:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:38:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:38:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:38:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [19-1]  sql_error_code = 00000 time_ms = \"2025-03-14 18:39:10.123 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692654\" tid=\"2265332\" log_line=\"11\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8561.750 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:39:10+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [19-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-14T18:39:10+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [19-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-14T18:39:10+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [19-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-14T18:39:10+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [19-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-14T18:39:10+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [19-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:39:10+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14 18:39:19.156 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692656\" tid=\"2265335\" log_line=\"12\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8630.463 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:39:19+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:39:19+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:39:19+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:39:19+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:39:19+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:39:19+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [23-1]  sql_error_code = 00000 time_ms = \"2025-03-14 18:39:46.019 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692662\" tid=\"2265345\" log_line=\"15\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8516.869 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:39:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [23-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-14T18:39:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [23-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-14T18:39:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [23-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-14T18:39:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [23-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-14T18:39:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [23-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:39:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14 18:39:54.971 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692664\" tid=\"2265348\" log_line=\"16\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8549.763 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:39:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:39:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:39:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:39:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:39:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:39:54+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14 18:40:21.794 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692670\" tid=\"2265358\" log_line=\"19\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8524.038 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:21+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:40:21+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:40:21+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:40:21+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:40:21+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:40:21+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14 18:40:48.649 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692676\" tid=\"2265372\" log_line=\"22\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8582.401 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:48+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:40:48+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:40:48+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:40:48+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:40:48+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:40:48+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [32-1]  sql_error_code = 00000 time_ms = \"2025-03-14 18:41:06.773 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692680\" tid=\"2265381\" log_line=\"24\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8615.449 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:41:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [32-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-14T18:41:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [32-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-14T18:41:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [32-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-14T18:41:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [32-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-14T18:41:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [32-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:41:06+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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 18:41:15.718 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692682\" tid=\"2265384\" log_line=\"25\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8540.529 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:41:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:41:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:41:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:41:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:41:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:41:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [36-1]  sql_error_code = 00000 time_ms = \"2025-03-14 18:41:43.570 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692688\" tid=\"2265393\" log_line=\"28\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8540.276 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:41:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [36-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-14T18:41:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [36-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-14T18:41:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [36-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-14T18:41:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [36-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-14T18:41:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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] [36-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:41:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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 18:41:47.748 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692690\" tid=\"2265396\" log_line=\"29\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 3934.216 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:41:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:41:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:41:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:41:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:41:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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-14T18:41:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}