Debug line with all properties:
FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134,
syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-',
TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.627 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963986" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement:'
escaped msg: '[DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.627 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963986" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement:'
inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.627 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963986" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement:'
$!:{ "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": "11", "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": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "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 03:30:36.627 UTC\" pid=\"1447813\" proc_start_time=\"2025-03-17 03:30:28 UTC\" session_id=\"67d79754.161785\" vtid=\"6\/5963986\" tid=\"0\" log_line=\"4\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(33650)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "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.3728740", "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: 134,
syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-',
TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_user"'
escaped msg: '[DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_user"'
inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_user"'
$!:{ "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": "11", "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": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-2] #011                CREATE TEMPORARY TABLE \"_tmp_salesforce_user\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "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.3728740", "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: 134,
syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-',
TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-3] #011                ON COMMIT PRESERVE ROWS'
escaped msg: '[DATABASE] [12-3] #011                ON COMMIT PRESERVE ROWS'
inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-3] #011                ON COMMIT PRESERVE ROWS'
$!:{ "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": "11", "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": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-3] #011                ON COMMIT PRESERVE ROWS", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "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.3728740", "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: 134,
syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-',
TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-4] #011                AS'
escaped msg: '[DATABASE] [12-4] #011                AS'
inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-4] #011                AS'
$!:{ "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": "11", "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": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-4] #011                AS", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "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.3728740", "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: 134,
syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-',
TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-5] #011                  SELECT "sfid","managerid","name","isactive","systemmodstamp","username","createddate","slack_id__c","email", now() as deleteddate,'
escaped msg: '[DATABASE] [12-5] #011                  SELECT "sfid","managerid","name","isactive","systemmodstamp","username","createddate","slack_id__c","email", now() as deleteddate,'
inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-5] #011                  SELECT "sfid","managerid","name","isactive","systemmodstamp","username","createddate","slack_id__c","email", now() as deleteddate,'
$!:{ "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": "11", "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": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-5] #011                  SELECT \"sfid\",\"managerid\",\"name\",\"isactive\",\"systemmodstamp\",\"username\",\"createddate\",\"slack_id__c\",\"email\", now() as deleteddate,", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "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.3728740", "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: 134,
syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-',
TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-6] #011                  ''::varchar(20) AS __operation'
escaped msg: '[DATABASE] [12-6] #011                  ''::varchar(20) AS __operation'
inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-6] #011                  ''::varchar(20) AS __operation'
$!:{ "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": "11", "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": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-6] #011                  ''::varchar(20) AS __operation", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "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.3728740", "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: 134,
syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-',
TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-7] #011                  FROM "salesforce"."user" WITH NO DATA'
escaped msg: '[DATABASE] [12-7] #011                  FROM "salesforce"."user" WITH NO DATA'
inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-7] #011                  FROM "salesforce"."user" WITH NO DATA'
$!:{ "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": "11", "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": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-7] #011                  FROM \"salesforce\".\"user\" WITH NO DATA", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "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.3728740", "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: 134,
syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-',
TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-8]'
escaped msg: '[DATABASE] [12-8]'
inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-8]'
$!:{ "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": "11", "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": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-8]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "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.3728740", "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: 134,
syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-',
TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-',
msg: '[DATABASE] [13-1]  sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.633 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963987" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE UNIQUE INDEX ON'
escaped msg: '[DATABASE] [13-1]  sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.633 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963987" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE UNIQUE INDEX ON'
inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [13-1]  sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.633 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963987" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE UNIQUE INDEX ON'
$!:{ "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": "11", "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": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [13-1]  sql_error_code = 00000 time_ms = \"2025-03-17 03:30:36.633 UTC\" pid=\"1447813\" proc_start_time=\"2025-03-17 03:30:28 UTC\" session_id=\"67d79754.161785\" vtid=\"6\/5963987\" tid=\"0\" log_line=\"5\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(33650)\" 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-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "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.3728740", "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: 134,
syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-',
TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-',
msg: '[DATABASE] [13-2] #011                         "_tmp_salesforce_user" ("sfid")'
escaped msg: '[DATABASE] [13-2] #011                         "_tmp_salesforce_user" ("sfid")'
inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [13-2] #011                         "_tmp_salesforce_user" ("sfid")'
$!:{ "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": "11", "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": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [13-2] #011                         \"_tmp_salesforce_user\" (\"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "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.3728740", "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: 134,
syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-',
TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-',
msg: '[DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.637 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963988" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_user" (__operation, "sfid")'
escaped msg: '[DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.637 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963988" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_user" (__operation, "sfid")'
inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.637 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963988" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_user" (__operation, "sfid")'
$!:{ "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": "11", "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": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [14-1]  sql_error_code = 00000 time_ms = \"2025-03-17 03:30:36.637 UTC\" pid=\"1447813\" proc_start_time=\"2025-03-17 03:30:28 UTC\" session_id=\"67d79754.161785\" vtid=\"6\/5963988\" tid=\"0\" log_line=\"6\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(33650)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  statement: CREATE INDEX ON \"_tmp_salesforce_user\" (__operation, \"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "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.3728740", "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" }
$/: