Debug line with all properties:
FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134,
syslogtag 'app[postgres.3747217]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3747217', MSGID: '-',
TIMESTAMP: 'Mar 17 05:35:34', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-17 05:35:34.701 UTC" pid="1449437" proc_start_time="2025-03-17 05:35:34 UTC" session_id="67d7b4a6.161ddd" vtid="5/2327883" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(43188)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement:'
escaped msg: '[DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-17 05:35:34.701 UTC" pid="1449437" proc_start_time="2025-03-17 05:35:34 UTC" session_id="67d7b4a6.161ddd" vtid="5/2327883" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(43188)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement:'
inputname: drain rawmsg: '<134>1 2025-03-17T05:35:34+00:00 ip-10-1-102-204 app postgres.3747217 - - [DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-17 05:35:34.701 UTC" pid="1449437" proc_start_time="2025-03-17 05:35:34 UTC" session_id="67d7b4a6.161ddd" vtid="5/2327883" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(43188)" 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": "c2fa4c79-f7d4-48e4-973b-92cb5a7feb44", "x-request-start": "1742189735290" }, "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 05:35:34.701 UTC\" pid=\"1449437\" proc_start_time=\"2025-03-17 05:35:34 UTC\" session_id=\"67d7b4a6.161ddd\" vtid=\"5\/2327883\" tid=\"0\" log_line=\"4\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(43188)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T05:35:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3747217", "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.3747217", "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.3747217]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3747217', MSGID: '-',
TIMESTAMP: 'Mar 17 05:35:34', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_adm_scrum_team_member__c"'
escaped msg: '[DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_adm_scrum_team_member__c"'
inputname: drain rawmsg: '<134>1 2025-03-17T05:35:34+00:00 ip-10-1-102-204 app postgres.3747217 - - [DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_adm_scrum_team_member__c"'
$!:{ "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": "c2fa4c79-f7d4-48e4-973b-92cb5a7feb44", "x-request-start": "1742189735290" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-2] #011                CREATE TEMPORARY TABLE \"_tmp_salesforce_adm_scrum_team_member__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T05:35:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3747217", "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.3747217", "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.3747217]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3747217', MSGID: '-',
TIMESTAMP: 'Mar 17 05:35:34', 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-17T05:35:34+00:00 ip-10-1-102-204 app postgres.3747217 - - [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": "c2fa4c79-f7d4-48e4-973b-92cb5a7feb44", "x-request-start": "1742189735290" }, "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-17T05:35:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3747217", "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.3747217", "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.3747217]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3747217', MSGID: '-',
TIMESTAMP: 'Mar 17 05:35:34', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-4] #011                AS'
escaped msg: '[DATABASE] [12-4] #011                AS'
inputname: drain rawmsg: '<134>1 2025-03-17T05:35:34+00:00 ip-10-1-102-204 app postgres.3747217 - - [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": "c2fa4c79-f7d4-48e4-973b-92cb5a7feb44", "x-request-start": "1742189735290" }, "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-17T05:35:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3747217", "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.3747217", "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.3747217]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3747217', MSGID: '-',
TIMESTAMP: 'Mar 17 05:35:34', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-5] #011                  SELECT "sfid","scrum_team__c","allocation__c","internal_email__c","name","member_name_formula__c","role__c","isdeleted","systemmodstamp","member_name__c","createddate","scrum_team_name__c","active__c","additional_roles__c", now() as deleteddate,'
escaped msg: '[DATABASE] [12-5] #011                  SELECT "sfid","scrum_team__c","allocation__c","internal_email__c","name","member_name_formula__c","role__c","isdeleted","systemmodstamp","member_name__c","createddate","scrum_team_name__c","active__c","additional_roles__c", now() as deleteddate,'
inputname: drain rawmsg: '<134>1 2025-03-17T05:35:34+00:00 ip-10-1-102-204 app postgres.3747217 - - [DATABASE] [12-5] #011                  SELECT "sfid","scrum_team__c","allocation__c","internal_email__c","name","member_name_formula__c","role__c","isdeleted","systemmodstamp","member_name__c","createddate","scrum_team_name__c","active__c","additional_roles__c", 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": "c2fa4c79-f7d4-48e4-973b-92cb5a7feb44", "x-request-start": "1742189735290" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-5] #011                  SELECT \"sfid\",\"scrum_team__c\",\"allocation__c\",\"internal_email__c\",\"name\",\"member_name_formula__c\",\"role__c\",\"isdeleted\",\"systemmodstamp\",\"member_name__c\",\"createddate\",\"scrum_team_name__c\",\"active__c\",\"additional_roles__c\", now() as deleteddate,", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T05:35:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3747217", "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.3747217", "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.3747217]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3747217', MSGID: '-',
TIMESTAMP: 'Mar 17 05:35:34', 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-17T05:35:34+00:00 ip-10-1-102-204 app postgres.3747217 - - [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": "c2fa4c79-f7d4-48e4-973b-92cb5a7feb44", "x-request-start": "1742189735290" }, "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-17T05:35:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3747217", "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.3747217", "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.3747217]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3747217', MSGID: '-',
TIMESTAMP: 'Mar 17 05:35:34', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-7] #011                  FROM "salesforce"."adm_scrum_team_member__c" WITH NO DATA'
escaped msg: '[DATABASE] [12-7] #011                  FROM "salesforce"."adm_scrum_team_member__c" WITH NO DATA'
inputname: drain rawmsg: '<134>1 2025-03-17T05:35:34+00:00 ip-10-1-102-204 app postgres.3747217 - - [DATABASE] [12-7] #011                  FROM "salesforce"."adm_scrum_team_member__c" 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": "c2fa4c79-f7d4-48e4-973b-92cb5a7feb44", "x-request-start": "1742189735290" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-7] #011                  FROM \"salesforce\".\"adm_scrum_team_member__c\" WITH NO DATA", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T05:35:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3747217", "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.3747217", "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.3747217]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3747217', MSGID: '-',
TIMESTAMP: 'Mar 17 05:35:34', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-8]'
escaped msg: '[DATABASE] [12-8]'
inputname: drain rawmsg: '<134>1 2025-03-17T05:35:34+00:00 ip-10-1-102-204 app postgres.3747217 - - [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": "c2fa4c79-f7d4-48e4-973b-92cb5a7feb44", "x-request-start": "1742189735290" }, "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-17T05:35:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3747217", "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.3747217", "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.3747217]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3747217', MSGID: '-',
TIMESTAMP: 'Mar 17 05:35:34', STRUCTURED-DATA: '-',
msg: '[DATABASE] [13-1]  sql_error_code = 00000 time_ms = "2025-03-17 05:35:34.708 UTC" pid="1449437" proc_start_time="2025-03-17 05:35:34 UTC" session_id="67d7b4a6.161ddd" vtid="5/2327884" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(43188)" 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 05:35:34.708 UTC" pid="1449437" proc_start_time="2025-03-17 05:35:34 UTC" session_id="67d7b4a6.161ddd" vtid="5/2327884" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(43188)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE UNIQUE INDEX ON'
inputname: drain rawmsg: '<134>1 2025-03-17T05:35:34+00:00 ip-10-1-102-204 app postgres.3747217 - - [DATABASE] [13-1]  sql_error_code = 00000 time_ms = "2025-03-17 05:35:34.708 UTC" pid="1449437" proc_start_time="2025-03-17 05:35:34 UTC" session_id="67d7b4a6.161ddd" vtid="5/2327884" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(43188)" 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": "c2fa4c79-f7d4-48e4-973b-92cb5a7feb44", "x-request-start": "1742189735290" }, "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 05:35:34.708 UTC\" pid=\"1449437\" proc_start_time=\"2025-03-17 05:35:34 UTC\" session_id=\"67d7b4a6.161ddd\" vtid=\"5\/2327884\" tid=\"0\" log_line=\"5\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(43188)\" 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-17T05:35:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3747217", "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.3747217", "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.3747217]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3747217', MSGID: '-',
TIMESTAMP: 'Mar 17 05:35:34', STRUCTURED-DATA: '-',
msg: '[DATABASE] [13-2] #011                         "_tmp_salesforce_adm_scrum_team_member__c" ("sfid")'
escaped msg: '[DATABASE] [13-2] #011                         "_tmp_salesforce_adm_scrum_team_member__c" ("sfid")'
inputname: drain rawmsg: '<134>1 2025-03-17T05:35:34+00:00 ip-10-1-102-204 app postgres.3747217 - - [DATABASE] [13-2] #011                         "_tmp_salesforce_adm_scrum_team_member__c" ("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": "c2fa4c79-f7d4-48e4-973b-92cb5a7feb44", "x-request-start": "1742189735290" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [13-2] #011                         \"_tmp_salesforce_adm_scrum_team_member__c\" (\"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T05:35:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3747217", "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.3747217", "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.3747217]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3747217', MSGID: '-',
TIMESTAMP: 'Mar 17 05:35:34', STRUCTURED-DATA: '-',
msg: '[DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-17 05:35:34.712 UTC" pid="1449437" proc_start_time="2025-03-17 05:35:34 UTC" session_id="67d7b4a6.161ddd" vtid="5/2327885" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(43188)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_adm_scrum_team_member__c" (__operation, "sfid")'
escaped msg: '[DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-17 05:35:34.712 UTC" pid="1449437" proc_start_time="2025-03-17 05:35:34 UTC" session_id="67d7b4a6.161ddd" vtid="5/2327885" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(43188)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_adm_scrum_team_member__c" (__operation, "sfid")'
inputname: drain rawmsg: '<134>1 2025-03-17T05:35:34+00:00 ip-10-1-102-204 app postgres.3747217 - - [DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-17 05:35:34.712 UTC" pid="1449437" proc_start_time="2025-03-17 05:35:34 UTC" session_id="67d7b4a6.161ddd" vtid="5/2327885" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(43188)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_adm_scrum_team_member__c" (__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": "c2fa4c79-f7d4-48e4-973b-92cb5a7feb44", "x-request-start": "1742189735290" }, "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 05:35:34.712 UTC\" pid=\"1449437\" proc_start_time=\"2025-03-17 05:35:34 UTC\" session_id=\"67d7b4a6.161ddd\" vtid=\"5\/2327885\" tid=\"0\" log_line=\"6\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(43188)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  statement: CREATE INDEX ON \"_tmp_salesforce_adm_scrum_team_member__c\" (__operation, \"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T05:35:34+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3747217", "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.3747217", "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" }
$/: