Debug line with all properties:
FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134,
syslogtag 'app[postgres.3748768]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3748768', MSGID: '-',
TIMESTAMP: 'Mar 17 05:46:40', STRUCTURED-DATA: '-',
msg: '[DATABASE] [15-1]  sql_error_code = 00000 time_ms = "2025-03-17 05:46:40.338 UTC" pid="1449602" proc_start_time="2025-03-17 05:46:34 UTC" session_id="67d7b73a.161e82" vtid="6/5973670" tid="2273065" log_line="7" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(58142)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 2023.574 ms  statement:'
escaped msg: '[DATABASE] [15-1]  sql_error_code = 00000 time_ms = "2025-03-17 05:46:40.338 UTC" pid="1449602" proc_start_time="2025-03-17 05:46:34 UTC" session_id="67d7b73a.161e82" vtid="6/5973670" tid="2273065" log_line="7" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(58142)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 2023.574 ms  statement:'
inputname: drain rawmsg: '<134>1 2025-03-17T05:46:40+00:00 ip-10-1-102-204 app postgres.3748768 - - [DATABASE] [15-1]  sql_error_code = 00000 time_ms = "2025-03-17 05:46:40.338 UTC" pid="1449602" proc_start_time="2025-03-17 05:46:34 UTC" session_id="67d7b73a.161e82" vtid="6/5973670" tid="2273065" log_line="7" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(58142)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 2023.574 ms  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": "6", "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": "9b70e5c0-f2fb-4279-a70c-d3c99fbcc3b4", "x-request-start": "1742190401004" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [15-1]  sql_error_code = 00000 time_ms = \"2025-03-17 05:46:40.338 UTC\" pid=\"1449602\" proc_start_time=\"2025-03-17 05:46:34 UTC\" session_id=\"67d7b73a.161e82\" vtid=\"6\/5973670\" tid=\"2273065\" log_line=\"7\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(58142)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 2023.574 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T05:46:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3748768", "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.3748768", "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.3748768]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3748768', MSGID: '-',
TIMESTAMP: 'Mar 17 05:46:40', STRUCTURED-DATA: '-',
msg: '[DATABASE] [15-2] #011        UPDATE "salesforce"."adm_scrum_team__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"product_owner__c"=s."product_owner__c","pagerduty_escalation_service_url__c"=s."pagerduty_escalation_service_url__c","engineering_manager__c"=s."engineering_manager__c","parent_cloud__c"=s."parent_cloud__c","public_slack_channel__c"=s."public_slack_channel__c","quip_url__c"=s."quip_url__c","distribution_lists__c"=s."distribution_lists__c","name"=s."name","cloud__c"=s."cloud__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","pagerduty_primary_team_url__c"=s."pagerduty_primary_team_url__c","createddate"=s."createddate","scrum_master__c"=s."scrum_master__c","active__c"=s."active__c"'
escaped msg: '[DATABASE] [15-2] #011        UPDATE "salesforce"."adm_scrum_team__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"product_owner__c"=s."product_owner__c","pagerduty_escalation_service_url__c"=s."pagerduty_escalation_service_url__c","engineering_manager__c"=s."engineering_manager__c","parent_cloud__c"=s."parent_cloud__c","public_slack_channel__c"=s."public_slack_channel__c","quip_url__c"=s."quip_url__c","distribution_lists__c"=s."distribution_lists__c","name"=s."name","cloud__c"=s."cloud__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","pagerduty_primary_team_url__c"=s."pagerduty_primary_team_url__c","createddate"=s."createddate","scrum_master__c"=s."scrum_master__c","active__c"=s."active__c"'
inputname: drain rawmsg: '<134>1 2025-03-17T05:46:40+00:00 ip-10-1-102-204 app postgres.3748768 - - [DATABASE] [15-2] #011        UPDATE "salesforce"."adm_scrum_team__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"product_owner__c"=s."product_owner__c","pagerduty_escalation_service_url__c"=s."pagerduty_escalation_service_url__c","engineering_manager__c"=s."engineering_manager__c","parent_cloud__c"=s."parent_cloud__c","public_slack_channel__c"=s."public_slack_channel__c","quip_url__c"=s."quip_url__c","distribution_lists__c"=s."distribution_lists__c","name"=s."name","cloud__c"=s."cloud__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","pagerduty_primary_team_url__c"=s."pagerduty_primary_team_url__c","createddate"=s."createddate","scrum_master__c"=s."scrum_master__c","active__c"=s."active__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": "6", "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": "9b70e5c0-f2fb-4279-a70c-d3c99fbcc3b4", "x-request-start": "1742190401004" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [15-2] #011        UPDATE \"salesforce\".\"adm_scrum_team__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"product_owner__c\"=s.\"product_owner__c\",\"pagerduty_escalation_service_url__c\"=s.\"pagerduty_escalation_service_url__c\",\"engineering_manager__c\"=s.\"engineering_manager__c\",\"parent_cloud__c\"=s.\"parent_cloud__c\",\"public_slack_channel__c\"=s.\"public_slack_channel__c\",\"quip_url__c\"=s.\"quip_url__c\",\"distribution_lists__c\"=s.\"distribution_lists__c\",\"name\"=s.\"name\",\"cloud__c\"=s.\"cloud__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"pagerduty_primary_team_url__c\"=s.\"pagerduty_primary_team_url__c\",\"createddate\"=s.\"createddate\",\"scrum_master__c\"=s.\"scrum_master__c\",\"active__c\"=s.\"active__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T05:46:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3748768", "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.3748768", "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.3748768]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3748768', MSGID: '-',
TIMESTAMP: 'Mar 17 05:46:40', STRUCTURED-DATA: '-',
msg: '[DATABASE] [15-3] #011        FROM "_tmp_salesforce_adm_scrum_team__c" AS s'
escaped msg: '[DATABASE] [15-3] #011        FROM "_tmp_salesforce_adm_scrum_team__c" AS s'
inputname: drain rawmsg: '<134>1 2025-03-17T05:46:40+00:00 ip-10-1-102-204 app postgres.3748768 - - [DATABASE] [15-3] #011        FROM "_tmp_salesforce_adm_scrum_team__c" AS s'
$!:{ "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": "6", "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": "9b70e5c0-f2fb-4279-a70c-d3c99fbcc3b4", "x-request-start": "1742190401004" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [15-3] #011        FROM \"_tmp_salesforce_adm_scrum_team__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T05:46:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3748768", "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.3748768", "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.3748768]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3748768', MSGID: '-',
TIMESTAMP: 'Mar 17 05:46:40', STRUCTURED-DATA: '-',
msg: '[DATABASE] [15-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND'
escaped msg: '[DATABASE] [15-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND'
inputname: drain rawmsg: '<134>1 2025-03-17T05:46:40+00:00 ip-10-1-102-204 app postgres.3748768 - - [DATABASE] [15-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND'
$!:{ "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": "6", "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": "9b70e5c0-f2fb-4279-a70c-d3c99fbcc3b4", "x-request-start": "1742190401004" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "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-17T05:46:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3748768", "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.3748768", "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.3748768]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3748768', MSGID: '-',
TIMESTAMP: 'Mar 17 05:46:40', STRUCTURED-DATA: '-',
msg: '[DATABASE] [15-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
escaped msg: '[DATABASE] [15-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
inputname: drain rawmsg: '<134>1 2025-03-17T05:46:40+00:00 ip-10-1-102-204 app postgres.3748768 - - [DATABASE] [15-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."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": "6", "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": "9b70e5c0-f2fb-4279-a70c-d3c99fbcc3b4", "x-request-start": "1742190401004" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "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-17T05:46:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3748768", "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.3748768", "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.3748768]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3748768', MSGID: '-',
TIMESTAMP: 'Mar 17 05:46:40', STRUCTURED-DATA: '-',
msg: '[DATABASE] [15-6]'
escaped msg: '[DATABASE] [15-6]'
inputname: drain rawmsg: '<134>1 2025-03-17T05:46:40+00:00 ip-10-1-102-204 app postgres.3748768 - - [DATABASE] [15-6]'
$!:{ "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": "6", "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": "9b70e5c0-f2fb-4279-a70c-d3c99fbcc3b4", "x-request-start": "1742190401004" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [15-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T05:46:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3748768", "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.3748768", "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" }
$/: