Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3740286]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3740286', MSGID: '-', TIMESTAMP: 'Mar 17 04:49:03', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-1] sql_error_code = 00000 time_ms = "2025-03-17 04:49:03.092 UTC" pid="1448849" proc_start_time="2025-03-17 04:49:02 UTC" session_id="67d7a9be.161b91" vtid="5/2323183" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.0.167.95(58366)" user="ue3280ufn31cpn" application_name="icc" LOG: statement: CREATE EXTENSION IF NOT EXISTS "uuid-ossp"' escaped msg: '[DATABASE] [12-1] sql_error_code = 00000 time_ms = "2025-03-17 04:49:03.092 UTC" pid="1448849" proc_start_time="2025-03-17 04:49:02 UTC" session_id="67d7a9be.161b91" vtid="5/2323183" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.0.167.95(58366)" user="ue3280ufn31cpn" application_name="icc" LOG: statement: CREATE EXTENSION IF NOT EXISTS "uuid-ossp"' inputname: drain rawmsg: '<134>1 2025-03-17T04:49:03+00:00 ip-10-1-102-204 app postgres.3740286 - - [DATABASE] [12-1] sql_error_code = 00000 time_ms = "2025-03-17 04:49:03.092 UTC" pid="1448849" proc_start_time="2025-03-17 04:49:02 UTC" session_id="67d7a9be.161b91" vtid="5/2323183" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.0.167.95(58366)" user="ue3280ufn31cpn" application_name="icc" LOG: statement: CREATE EXTENSION IF NOT EXISTS "uuid-ossp"' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "1dc888c7-df17-4b21-8d20-e1e449895d4e", "x-request-start": "1742186943802" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-1] sql_error_code = 00000 time_ms = \"2025-03-17 04:49:03.092 UTC\" pid=\"1448849\" proc_start_time=\"2025-03-17 04:49:02 UTC\" session_id=\"67d7a9be.161b91\" vtid=\"5\/2323183\" tid=\"0\" log_line=\"4\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.0.167.95(58366)\" user=\"ue3280ufn31cpn\" application_name=\"icc\" LOG: statement: CREATE EXTENSION IF NOT EXISTS \"uuid-ossp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T04:49:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3740286", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3740286", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 133, syslogtag 'app[postgres.3740286]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3740286', MSGID: '-', TIMESTAMP: 'Mar 17 04:49:03', STRUCTURED-DATA: '-', msg: '[DATABASE] [13-1] sql_error_code = 42710 time_ms = "2025-03-17 04:49:03.093 UTC" pid="1448849" proc_start_time="2025-03-17 04:49:02 UTC" session_id="67d7a9be.161b91" vtid="5/2323183" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.0.167.95(58366)" user="ue3280ufn31cpn" application_name="icc" NOTICE: extension "uuid-ossp" already exists, skipping' escaped msg: '[DATABASE] [13-1] sql_error_code = 42710 time_ms = "2025-03-17 04:49:03.093 UTC" pid="1448849" proc_start_time="2025-03-17 04:49:02 UTC" session_id="67d7a9be.161b91" vtid="5/2323183" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.0.167.95(58366)" user="ue3280ufn31cpn" application_name="icc" NOTICE: extension "uuid-ossp" already exists, skipping' inputname: drain rawmsg: '<133>1 2025-03-17T04:49:03+00:00 ip-10-1-102-204 app postgres.3740286 - - [DATABASE] [13-1] sql_error_code = 42710 time_ms = "2025-03-17 04:49:03.093 UTC" pid="1448849" proc_start_time="2025-03-17 04:49:02 UTC" session_id="67d7a9be.161b91" vtid="5/2323183" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.0.167.95(58366)" user="ue3280ufn31cpn" application_name="icc" NOTICE: extension "uuid-ossp" already exists, skipping' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "2", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "1dc888c7-df17-4b21-8d20-e1e449895d4e", "x-request-start": "1742186943802" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [13-1] sql_error_code = 42710 time_ms = \"2025-03-17 04:49:03.093 UTC\" pid=\"1448849\" proc_start_time=\"2025-03-17 04:49:02 UTC\" session_id=\"67d7a9be.161b91\" vtid=\"5\/2323183\" tid=\"0\" log_line=\"5\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.0.167.95(58366)\" user=\"ue3280ufn31cpn\" application_name=\"icc\" NOTICE: extension \"uuid-ossp\" already exists, skipping", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T04:49:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3740286", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "notice", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3740286", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: