Debug line with all properties:
FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134,
syslogtag 'app[postgres.3768203]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3768203', MSGID: '-',
TIMESTAMP: 'Mar 17 07:51:50', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-17 07:51:50.823 UTC" pid="1451721" proc_start_time="2025-03-17 07:51:50 UTC" session_id="67d7d496.1626c9" vtid="7/3094933" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45972)" user="ue3280ufn31cpn" application_name="hc.driftworker" LOG:  statement:'
escaped msg: '[DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-17 07:51:50.823 UTC" pid="1451721" proc_start_time="2025-03-17 07:51:50 UTC" session_id="67d7d496.1626c9" vtid="7/3094933" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45972)" user="ue3280ufn31cpn" application_name="hc.driftworker" LOG:  statement:'
inputname: drain rawmsg: '<134>1 2025-03-17T07:51:50+00:00 ip-10-1-102-204 app postgres.3768203 - - [DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-17 07:51:50.823 UTC" pid="1451721" proc_start_time="2025-03-17 07:51:50 UTC" session_id="67d7d496.1626c9" vtid="7/3094933" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45972)" user="ue3280ufn31cpn" application_name="hc.driftworker" 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": "af91c237-bc00-4edb-83df-3bb7ebf9872f", "x-request-start": "1742197911542" }, "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 07:51:50.823 UTC\" pid=\"1451721\" proc_start_time=\"2025-03-17 07:51:50 UTC\" session_id=\"67d7d496.1626c9\" vtid=\"7\/3094933\" tid=\"0\" log_line=\"4\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45972)\" user=\"ue3280ufn31cpn\" application_name=\"hc.driftworker\" LOG:  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T07:51:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3768203", "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.3768203", "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.3768203]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3768203', MSGID: '-',
TIMESTAMP: 'Mar 17 07:51:50', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_adm_scrum_team__c"'
escaped msg: '[DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_adm_scrum_team__c"'
inputname: drain rawmsg: '<134>1 2025-03-17T07:51:50+00:00 ip-10-1-102-204 app postgres.3768203 - - [DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_adm_scrum_team__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": "af91c237-bc00-4edb-83df-3bb7ebf9872f", "x-request-start": "1742197911542" }, "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__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T07:51:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3768203", "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.3768203", "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.3768203]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3768203', MSGID: '-',
TIMESTAMP: 'Mar 17 07:51:50', 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-17T07:51:50+00:00 ip-10-1-102-204 app postgres.3768203 - - [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": "af91c237-bc00-4edb-83df-3bb7ebf9872f", "x-request-start": "1742197911542" }, "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-17T07:51:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3768203", "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.3768203", "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.3768203]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3768203', MSGID: '-',
TIMESTAMP: 'Mar 17 07:51:50', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-4] #011                AS'
escaped msg: '[DATABASE] [12-4] #011                AS'
inputname: drain rawmsg: '<134>1 2025-03-17T07:51:50+00:00 ip-10-1-102-204 app postgres.3768203 - - [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": "af91c237-bc00-4edb-83df-3bb7ebf9872f", "x-request-start": "1742197911542" }, "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-17T07:51:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3768203", "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.3768203", "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.3768203]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3768203', MSGID: '-',
TIMESTAMP: 'Mar 17 07:51:50', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-5] #011                  SELECT "sfid","product_owner__c","pagerduty_escalation_service_url__c","engineering_manager__c","parent_cloud__c","public_slack_channel__c","quip_url__c","distribution_lists__c","name","cloud__c","isdeleted","systemmodstamp","pagerduty_primary_team_url__c","createddate","scrum_master__c","active__c", now() as deleteddate,'
escaped msg: '[DATABASE] [12-5] #011                  SELECT "sfid","product_owner__c","pagerduty_escalation_service_url__c","engineering_manager__c","parent_cloud__c","public_slack_channel__c","quip_url__c","distribution_lists__c","name","cloud__c","isdeleted","systemmodstamp","pagerduty_primary_team_url__c","createddate","scrum_master__c","active__c", now() as deleteddate,'
inputname: drain rawmsg: '<134>1 2025-03-17T07:51:50+00:00 ip-10-1-102-204 app postgres.3768203 - - [DATABASE] [12-5] #011                  SELECT "sfid","product_owner__c","pagerduty_escalation_service_url__c","engineering_manager__c","parent_cloud__c","public_slack_channel__c","quip_url__c","distribution_lists__c","name","cloud__c","isdeleted","systemmodstamp","pagerduty_primary_team_url__c","createddate","scrum_master__c","active__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": "af91c237-bc00-4edb-83df-3bb7ebf9872f", "x-request-start": "1742197911542" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-5] #011                  SELECT \"sfid\",\"product_owner__c\",\"pagerduty_escalation_service_url__c\",\"engineering_manager__c\",\"parent_cloud__c\",\"public_slack_channel__c\",\"quip_url__c\",\"distribution_lists__c\",\"name\",\"cloud__c\",\"isdeleted\",\"systemmodstamp\",\"pagerduty_primary_team_url__c\",\"createddate\",\"scrum_master__c\",\"active__c\", now() as deleteddate,", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T07:51:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3768203", "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.3768203", "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.3768203]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3768203', MSGID: '-',
TIMESTAMP: 'Mar 17 07:51:50', 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-17T07:51:50+00:00 ip-10-1-102-204 app postgres.3768203 - - [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": "af91c237-bc00-4edb-83df-3bb7ebf9872f", "x-request-start": "1742197911542" }, "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-17T07:51:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3768203", "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.3768203", "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.3768203]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3768203', MSGID: '-',
TIMESTAMP: 'Mar 17 07:51:50', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-7] #011                  FROM "salesforce"."adm_scrum_team__c" WITH NO DATA'
escaped msg: '[DATABASE] [12-7] #011                  FROM "salesforce"."adm_scrum_team__c" WITH NO DATA'
inputname: drain rawmsg: '<134>1 2025-03-17T07:51:50+00:00 ip-10-1-102-204 app postgres.3768203 - - [DATABASE] [12-7] #011                  FROM "salesforce"."adm_scrum_team__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": "af91c237-bc00-4edb-83df-3bb7ebf9872f", "x-request-start": "1742197911542" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-7] #011                  FROM \"salesforce\".\"adm_scrum_team__c\" WITH NO DATA", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T07:51:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3768203", "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.3768203", "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.3768203]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3768203', MSGID: '-',
TIMESTAMP: 'Mar 17 07:51:50', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-8]'
escaped msg: '[DATABASE] [12-8]'
inputname: drain rawmsg: '<134>1 2025-03-17T07:51:50+00:00 ip-10-1-102-204 app postgres.3768203 - - [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": "af91c237-bc00-4edb-83df-3bb7ebf9872f", "x-request-start": "1742197911542" }, "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-17T07:51:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3768203", "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.3768203", "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.3768203]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3768203', MSGID: '-',
TIMESTAMP: 'Mar 17 07:51:50', STRUCTURED-DATA: '-',
msg: '[DATABASE] [13-1]  sql_error_code = 00000 time_ms = "2025-03-17 07:51:50.829 UTC" pid="1451721" proc_start_time="2025-03-17 07:51:50 UTC" session_id="67d7d496.1626c9" vtid="7/3094934" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45972)" user="ue3280ufn31cpn" application_name="hc.driftworker" LOG:  statement: CREATE UNIQUE INDEX ON'
escaped msg: '[DATABASE] [13-1]  sql_error_code = 00000 time_ms = "2025-03-17 07:51:50.829 UTC" pid="1451721" proc_start_time="2025-03-17 07:51:50 UTC" session_id="67d7d496.1626c9" vtid="7/3094934" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45972)" user="ue3280ufn31cpn" application_name="hc.driftworker" LOG:  statement: CREATE UNIQUE INDEX ON'
inputname: drain rawmsg: '<134>1 2025-03-17T07:51:50+00:00 ip-10-1-102-204 app postgres.3768203 - - [DATABASE] [13-1]  sql_error_code = 00000 time_ms = "2025-03-17 07:51:50.829 UTC" pid="1451721" proc_start_time="2025-03-17 07:51:50 UTC" session_id="67d7d496.1626c9" vtid="7/3094934" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45972)" user="ue3280ufn31cpn" application_name="hc.driftworker" 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": "af91c237-bc00-4edb-83df-3bb7ebf9872f", "x-request-start": "1742197911542" }, "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 07:51:50.829 UTC\" pid=\"1451721\" proc_start_time=\"2025-03-17 07:51:50 UTC\" session_id=\"67d7d496.1626c9\" vtid=\"7\/3094934\" tid=\"0\" log_line=\"5\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45972)\" user=\"ue3280ufn31cpn\" application_name=\"hc.driftworker\" LOG:  statement: CREATE UNIQUE INDEX ON", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T07:51:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3768203", "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.3768203", "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.3768203]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3768203', MSGID: '-',
TIMESTAMP: 'Mar 17 07:51:50', STRUCTURED-DATA: '-',
msg: '[DATABASE] [13-2] #011                         "_tmp_salesforce_adm_scrum_team__c" ("sfid")'
escaped msg: '[DATABASE] [13-2] #011                         "_tmp_salesforce_adm_scrum_team__c" ("sfid")'
inputname: drain rawmsg: '<134>1 2025-03-17T07:51:50+00:00 ip-10-1-102-204 app postgres.3768203 - - [DATABASE] [13-2] #011                         "_tmp_salesforce_adm_scrum_team__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": "af91c237-bc00-4edb-83df-3bb7ebf9872f", "x-request-start": "1742197911542" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [13-2] #011                         \"_tmp_salesforce_adm_scrum_team__c\" (\"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T07:51:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3768203", "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.3768203", "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.3768203]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3768203', MSGID: '-',
TIMESTAMP: 'Mar 17 07:51:50', STRUCTURED-DATA: '-',
msg: '[DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-17 07:51:50.833 UTC" pid="1451721" proc_start_time="2025-03-17 07:51:50 UTC" session_id="67d7d496.1626c9" vtid="7/3094935" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45972)" user="ue3280ufn31cpn" application_name="hc.driftworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_adm_scrum_team__c" (__operation, "sfid")'
escaped msg: '[DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-17 07:51:50.833 UTC" pid="1451721" proc_start_time="2025-03-17 07:51:50 UTC" session_id="67d7d496.1626c9" vtid="7/3094935" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45972)" user="ue3280ufn31cpn" application_name="hc.driftworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_adm_scrum_team__c" (__operation, "sfid")'
inputname: drain rawmsg: '<134>1 2025-03-17T07:51:50+00:00 ip-10-1-102-204 app postgres.3768203 - - [DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-17 07:51:50.833 UTC" pid="1451721" proc_start_time="2025-03-17 07:51:50 UTC" session_id="67d7d496.1626c9" vtid="7/3094935" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45972)" user="ue3280ufn31cpn" application_name="hc.driftworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_adm_scrum_team__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": "af91c237-bc00-4edb-83df-3bb7ebf9872f", "x-request-start": "1742197911542" }, "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 07:51:50.833 UTC\" pid=\"1451721\" proc_start_time=\"2025-03-17 07:51:50 UTC\" session_id=\"67d7d496.1626c9\" vtid=\"7\/3094935\" tid=\"0\" log_line=\"6\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45972)\" user=\"ue3280ufn31cpn\" application_name=\"hc.driftworker\" LOG:  statement: CREATE INDEX ON \"_tmp_salesforce_adm_scrum_team__c\" (__operation, \"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T07:51:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3768203", "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.3768203", "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" }
$/: