{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-1] sql_error_code = 00000 time_ms = \"2025-03-14 21:38:13.234 UTC\" pid=\"1408812\" proc_start_time=\"2025-03-14 21:38:07 UTC\" session_id=\"67d4a1bf.157f2c\" vtid=\"6\/5706671\" tid=\"0\" log_line=\"4\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(37370)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:38:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3251421", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-2] #011 CREATE TEMPORARY TABLE \"_tmp_salesforce_goc__configuration_item__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:38:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3251421", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-3] #011 ON COMMIT PRESERVE ROWS", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:38:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3251421", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-4] #011 AS", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:38:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3251421", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-5] #011 SELECT \"sfid\",\"goc__configuration_item_type__c\",\"goc__path__c\",\"name\",\"goc__parent_configuration_item__c\",\"isdeleted\",\"systemmodstamp\",\"createddate\",\"goc__status__c\",\"goc__isactive__c\",\"goc__root_node__c\", now() as deleteddate,", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:38:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3251421", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-6] #011 ''::varchar(20) AS __operation", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:38:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3251421", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-7] #011 FROM \"salesforce\".\"goc__configuration_item__c\" WITH NO DATA", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:38:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3251421", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [12-8]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:38:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3251421", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [13-1] sql_error_code = 00000 time_ms = \"2025-03-14 21:38:13.239 UTC\" pid=\"1408812\" proc_start_time=\"2025-03-14 21:38:07 UTC\" session_id=\"67d4a1bf.157f2c\" vtid=\"6\/5706672\" tid=\"0\" log_line=\"5\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(37370)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: statement: CREATE UNIQUE INDEX ON", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:38:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3251421", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [13-2] #011 \"_tmp_salesforce_goc__configuration_item__c\" (\"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:38:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3251421", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[DATABASE] [14-1] sql_error_code = 00000 time_ms = \"2025-03-14 21:38:13.242 UTC\" pid=\"1408812\" proc_start_time=\"2025-03-14 21:38:07 UTC\" session_id=\"67d4a1bf.157f2c\" vtid=\"6\/5706673\" tid=\"0\" log_line=\"6\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(37370)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: statement: CREATE INDEX ON \"_tmp_salesforce_goc__configuration_item__c\" (__operation, \"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:38:13+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3251421", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } }}