Debug line with all properties:
FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134,
syslogtag 'app[postgres.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:25', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:38:25.162 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692643" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement:'
escaped msg: '[DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:38:25.162 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692643" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement:'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:25+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [12-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:38:25.162 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692643" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" 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": "b164cd4e-de89-4291-83cf-a16aa3c2e2d2", "x-request-start": "1741977505786" }, "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-14 18:38:25.162 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692643\" tid=\"0\" log_line=\"4\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:38:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:25', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_goc__configuration_item__c"'
escaped msg: '[DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_goc__configuration_item__c"'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:25+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [12-2] #011                CREATE TEMPORARY TABLE "_tmp_salesforce_goc__configuration_item__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": "b164cd4e-de89-4291-83cf-a16aa3c2e2d2", "x-request-start": "1741977505786" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-2] #011                CREATE TEMPORARY TABLE \"_tmp_salesforce_goc__configuration_item__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:38:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:25', 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-14T18:38:25+00:00 ip-10-1-102-204 app postgres.3220717 - - [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": "b164cd4e-de89-4291-83cf-a16aa3c2e2d2", "x-request-start": "1741977505786" }, "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-14T18:38:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:25', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-4] #011                AS'
escaped msg: '[DATABASE] [12-4] #011                AS'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:25+00:00 ip-10-1-102-204 app postgres.3220717 - - [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": "b164cd4e-de89-4291-83cf-a16aa3c2e2d2", "x-request-start": "1741977505786" }, "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-14T18:38:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:25', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-5] #011                  SELECT "goc__configuration_item_type__c","goc__path__c","name","goc__parent_configuration_item__c","isdeleted","systemmodstamp","createddate","goc__status__c","goc__isactive__c","sfid","goc__root_node__c", now() as deleteddate,'
escaped msg: '[DATABASE] [12-5] #011                  SELECT "goc__configuration_item_type__c","goc__path__c","name","goc__parent_configuration_item__c","isdeleted","systemmodstamp","createddate","goc__status__c","goc__isactive__c","sfid","goc__root_node__c", now() as deleteddate,'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:25+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [12-5] #011                  SELECT "goc__configuration_item_type__c","goc__path__c","name","goc__parent_configuration_item__c","isdeleted","systemmodstamp","createddate","goc__status__c","goc__isactive__c","sfid","goc__root_node__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": "b164cd4e-de89-4291-83cf-a16aa3c2e2d2", "x-request-start": "1741977505786" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-5] #011                  SELECT \"goc__configuration_item_type__c\",\"goc__path__c\",\"name\",\"goc__parent_configuration_item__c\",\"isdeleted\",\"systemmodstamp\",\"createddate\",\"goc__status__c\",\"goc__isactive__c\",\"sfid\",\"goc__root_node__c\", now() as deleteddate,", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:38:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:25', 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-14T18:38:25+00:00 ip-10-1-102-204 app postgres.3220717 - - [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": "b164cd4e-de89-4291-83cf-a16aa3c2e2d2", "x-request-start": "1741977505786" }, "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-14T18:38:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:25', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-7] #011                  FROM "salesforce"."goc__configuration_item__c" WITH NO DATA'
escaped msg: '[DATABASE] [12-7] #011                  FROM "salesforce"."goc__configuration_item__c" WITH NO DATA'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:25+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [12-7] #011                  FROM "salesforce"."goc__configuration_item__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": "b164cd4e-de89-4291-83cf-a16aa3c2e2d2", "x-request-start": "1741977505786" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-7] #011                  FROM \"salesforce\".\"goc__configuration_item__c\" WITH NO DATA", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:38:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:25', STRUCTURED-DATA: '-',
msg: '[DATABASE] [12-8]'
escaped msg: '[DATABASE] [12-8]'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:25+00:00 ip-10-1-102-204 app postgres.3220717 - - [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": "b164cd4e-de89-4291-83cf-a16aa3c2e2d2", "x-request-start": "1741977505786" }, "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-14T18:38:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:25', STRUCTURED-DATA: '-',
msg: '[DATABASE] [13-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:38:25.166 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692644" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" 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-14 18:38:25.166 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692644" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE UNIQUE INDEX ON'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:25+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [13-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:38:25.166 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692644" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" 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": "b164cd4e-de89-4291-83cf-a16aa3c2e2d2", "x-request-start": "1741977505786" }, "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-14 18:38:25.166 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692644\" tid=\"0\" log_line=\"5\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" 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-14T18:38:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:25', STRUCTURED-DATA: '-',
msg: '[DATABASE] [13-2] #011                         "_tmp_salesforce_goc__configuration_item__c" ("sfid")'
escaped msg: '[DATABASE] [13-2] #011                         "_tmp_salesforce_goc__configuration_item__c" ("sfid")'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:25+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [13-2] #011                         "_tmp_salesforce_goc__configuration_item__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": "b164cd4e-de89-4291-83cf-a16aa3c2e2d2", "x-request-start": "1741977505786" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [13-2] #011                         \"_tmp_salesforce_goc__configuration_item__c\" (\"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:38:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:25', STRUCTURED-DATA: '-',
msg: '[DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:38:25.168 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692645" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_goc__configuration_item__c" (__operation, "sfid")'
escaped msg: '[DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:38:25.168 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692645" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_goc__configuration_item__c" (__operation, "sfid")'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:25+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [14-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:38:25.168 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692645" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  statement: CREATE INDEX ON "_tmp_salesforce_goc__configuration_item__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": "b164cd4e-de89-4291-83cf-a16aa3c2e2d2", "x-request-start": "1741977505786" }, "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-14 18:38:25.168 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692645\" tid=\"0\" log_line=\"6\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  statement: CREATE INDEX ON \"_tmp_salesforce_goc__configuration_item__c\" (__operation, \"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:38:25+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:52', STRUCTURED-DATA: '-',
msg: '[DATABASE] [17-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:38:52.084 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692650" tid="2265324" log_line="9" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8586.018 ms  statement:'
escaped msg: '[DATABASE] [17-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:38:52.084 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692650" tid="2265324" log_line="9" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8586.018 ms  statement:'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:52+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [17-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:38:52.084 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692650" tid="2265324" log_line="9" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8586.018 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": "a30be80b-35bd-4d51-b397-613a7b122b75", "x-request-start": "1741977532643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [17-1]  sql_error_code = 00000 time_ms = \"2025-03-14 18:38:52.084 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692650\" tid=\"2265324\" log_line=\"9\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8586.018 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:38:52+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:52', STRUCTURED-DATA: '-',
msg: '[DATABASE] [17-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"'
escaped msg: '[DATABASE] [17-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:52+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [17-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__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": "a30be80b-35bd-4d51-b397-613a7b122b75", "x-request-start": "1741977532643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [17-2] #011        UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:38:52+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:52', STRUCTURED-DATA: '-',
msg: '[DATABASE] [17-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s'
escaped msg: '[DATABASE] [17-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:52+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [17-3] #011        FROM "_tmp_salesforce_goc__configuration_item__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": "a30be80b-35bd-4d51-b397-613a7b122b75", "x-request-start": "1741977532643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [17-3] #011        FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:38:52+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:52', STRUCTURED-DATA: '-',
msg: '[DATABASE] [17-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND'
escaped msg: '[DATABASE] [17-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-14T18:38:52+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [17-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": "a30be80b-35bd-4d51-b397-613a7b122b75", "x-request-start": "1741977532643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [17-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-14T18:38:52+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:52', STRUCTURED-DATA: '-',
msg: '[DATABASE] [17-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
escaped msg: '[DATABASE] [17-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:52+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [17-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": "a30be80b-35bd-4d51-b397-613a7b122b75", "x-request-start": "1741977532643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [17-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-14T18:38:52+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:38:52', STRUCTURED-DATA: '-',
msg: '[DATABASE] [17-6]'
escaped msg: '[DATABASE] [17-6]'
inputname: drain rawmsg: '<134>1 2025-03-14T18:38:52+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [17-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": "a30be80b-35bd-4d51-b397-613a7b122b75", "x-request-start": "1741977532643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [17-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:38:52+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:39:28', STRUCTURED-DATA: '-',
msg: '[DATABASE] [21-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:39:28.087 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692658" tid="2265338" log_line="13" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8537.328 ms  statement:'
escaped msg: '[DATABASE] [21-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:39:28.087 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692658" tid="2265338" log_line="13" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8537.328 ms  statement:'
inputname: drain rawmsg: '<134>1 2025-03-14T18:39:28+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [21-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:39:28.087 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692658" tid="2265338" log_line="13" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8537.328 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": "a407301a-1320-4fdf-a954-6d93f2c67041", "x-request-start": "1741977568643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [21-1]  sql_error_code = 00000 time_ms = \"2025-03-14 18:39:28.087 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692658\" tid=\"2265338\" log_line=\"13\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8537.328 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:39:28+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:39:28', STRUCTURED-DATA: '-',
msg: '[DATABASE] [21-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"'
escaped msg: '[DATABASE] [21-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"'
inputname: drain rawmsg: '<134>1 2025-03-14T18:39:28+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [21-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__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": "a407301a-1320-4fdf-a954-6d93f2c67041", "x-request-start": "1741977568643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [21-2] #011        UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:39:28+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:39:28', STRUCTURED-DATA: '-',
msg: '[DATABASE] [21-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s'
escaped msg: '[DATABASE] [21-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s'
inputname: drain rawmsg: '<134>1 2025-03-14T18:39:28+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [21-3] #011        FROM "_tmp_salesforce_goc__configuration_item__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": "a407301a-1320-4fdf-a954-6d93f2c67041", "x-request-start": "1741977568643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [21-3] #011        FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:39:28+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:39:28', STRUCTURED-DATA: '-',
msg: '[DATABASE] [21-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND'
escaped msg: '[DATABASE] [21-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-14T18:39:28+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [21-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": "a407301a-1320-4fdf-a954-6d93f2c67041", "x-request-start": "1741977568643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [21-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-14T18:39:28+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:39:28', STRUCTURED-DATA: '-',
msg: '[DATABASE] [21-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
escaped msg: '[DATABASE] [21-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
inputname: drain rawmsg: '<134>1 2025-03-14T18:39:28+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [21-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": "a407301a-1320-4fdf-a954-6d93f2c67041", "x-request-start": "1741977568643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [21-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-14T18:39:28+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:39:28', STRUCTURED-DATA: '-',
msg: '[DATABASE] [21-6]'
escaped msg: '[DATABASE] [21-6]'
inputname: drain rawmsg: '<134>1 2025-03-14T18:39:28+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [21-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": "a407301a-1320-4fdf-a954-6d93f2c67041", "x-request-start": "1741977568643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [21-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:39:28+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:03', STRUCTURED-DATA: '-',
msg: '[DATABASE] [25-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:40:03.931 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692666" tid="2265351" log_line="17" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8561.248 ms  statement:'
escaped msg: '[DATABASE] [25-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:40:03.931 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692666" tid="2265351" log_line="17" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8561.248 ms  statement:'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:03+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [25-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:40:03.931 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692666" tid="2265351" log_line="17" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8561.248 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": "e68252bc-7699-4799-a2a8-29b912f354b8", "x-request-start": "1741977604643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [25-1]  sql_error_code = 00000 time_ms = \"2025-03-14 18:40:03.931 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692666\" tid=\"2265351\" log_line=\"17\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8561.248 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:03', STRUCTURED-DATA: '-',
msg: '[DATABASE] [25-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"'
escaped msg: '[DATABASE] [25-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:03+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [25-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__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": "e68252bc-7699-4799-a2a8-29b912f354b8", "x-request-start": "1741977604643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [25-2] #011        UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:03', STRUCTURED-DATA: '-',
msg: '[DATABASE] [25-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s'
escaped msg: '[DATABASE] [25-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:03+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [25-3] #011        FROM "_tmp_salesforce_goc__configuration_item__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": "e68252bc-7699-4799-a2a8-29b912f354b8", "x-request-start": "1741977604643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [25-3] #011        FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:03', STRUCTURED-DATA: '-',
msg: '[DATABASE] [25-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND'
escaped msg: '[DATABASE] [25-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-14T18:40:03+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [25-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": "e68252bc-7699-4799-a2a8-29b912f354b8", "x-request-start": "1741977604643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [25-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-14T18:40:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:03', STRUCTURED-DATA: '-',
msg: '[DATABASE] [25-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
escaped msg: '[DATABASE] [25-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:03+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [25-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": "e68252bc-7699-4799-a2a8-29b912f354b8", "x-request-start": "1741977604643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [25-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-14T18:40:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:03', STRUCTURED-DATA: '-',
msg: '[DATABASE] [25-6]'
escaped msg: '[DATABASE] [25-6]'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:03+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [25-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": "e68252bc-7699-4799-a2a8-29b912f354b8", "x-request-start": "1741977604643" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [25-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:30', STRUCTURED-DATA: '-',
msg: '[DATABASE] [28-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:40:30.731 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692672" tid="2265361" log_line="20" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8541.234 ms  statement:'
escaped msg: '[DATABASE] [28-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:40:30.731 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692672" tid="2265361" log_line="20" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8541.234 ms  statement:'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:30+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [28-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:40:30.731 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692672" tid="2265361" log_line="20" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8541.234 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": "16b0dfa2-3e69-4fb3-8d30-ff46d57f5b4a", "x-request-start": "1741977631393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [28-1]  sql_error_code = 00000 time_ms = \"2025-03-14 18:40:30.731 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692672\" tid=\"2265361\" log_line=\"20\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8541.234 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:30', STRUCTURED-DATA: '-',
msg: '[DATABASE] [28-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"'
escaped msg: '[DATABASE] [28-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:30+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [28-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__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": "16b0dfa2-3e69-4fb3-8d30-ff46d57f5b4a", "x-request-start": "1741977631393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [28-2] #011        UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:30', STRUCTURED-DATA: '-',
msg: '[DATABASE] [28-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s'
escaped msg: '[DATABASE] [28-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:30+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [28-3] #011        FROM "_tmp_salesforce_goc__configuration_item__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": "16b0dfa2-3e69-4fb3-8d30-ff46d57f5b4a", "x-request-start": "1741977631393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [28-3] #011        FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:30', STRUCTURED-DATA: '-',
msg: '[DATABASE] [28-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND'
escaped msg: '[DATABASE] [28-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-14T18:40:30+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [28-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": "16b0dfa2-3e69-4fb3-8d30-ff46d57f5b4a", "x-request-start": "1741977631393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [28-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-14T18:40:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:30', STRUCTURED-DATA: '-',
msg: '[DATABASE] [28-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
escaped msg: '[DATABASE] [28-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:30+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [28-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": "16b0dfa2-3e69-4fb3-8d30-ff46d57f5b4a", "x-request-start": "1741977631393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [28-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-14T18:40:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:30', STRUCTURED-DATA: '-',
msg: '[DATABASE] [28-6]'
escaped msg: '[DATABASE] [28-6]'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:30+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [28-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": "16b0dfa2-3e69-4fb3-8d30-ff46d57f5b4a", "x-request-start": "1741977631393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [28-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:30+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:57', STRUCTURED-DATA: '-',
msg: '[DATABASE] [31-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:40:57.759 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692678" tid="2265375" log_line="23" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8709.531 ms  statement:'
escaped msg: '[DATABASE] [31-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:40:57.759 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692678" tid="2265375" log_line="23" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8709.531 ms  statement:'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:57+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [31-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:40:57.759 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692678" tid="2265375" log_line="23" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8709.531 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": "c7a5c4a2-80ab-478f-b44e-02652fc24e62", "x-request-start": "1741977658393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [31-1]  sql_error_code = 00000 time_ms = \"2025-03-14 18:40:57.759 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692678\" tid=\"2265375\" log_line=\"23\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8709.531 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:57', STRUCTURED-DATA: '-',
msg: '[DATABASE] [31-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"'
escaped msg: '[DATABASE] [31-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:57+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [31-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__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": "c7a5c4a2-80ab-478f-b44e-02652fc24e62", "x-request-start": "1741977658393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [31-2] #011        UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:57', STRUCTURED-DATA: '-',
msg: '[DATABASE] [31-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s'
escaped msg: '[DATABASE] [31-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:57+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [31-3] #011        FROM "_tmp_salesforce_goc__configuration_item__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": "c7a5c4a2-80ab-478f-b44e-02652fc24e62", "x-request-start": "1741977658393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [31-3] #011        FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:57', STRUCTURED-DATA: '-',
msg: '[DATABASE] [31-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND'
escaped msg: '[DATABASE] [31-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-14T18:40:57+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [31-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": "c7a5c4a2-80ab-478f-b44e-02652fc24e62", "x-request-start": "1741977658393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [31-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-14T18:40:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:57', STRUCTURED-DATA: '-',
msg: '[DATABASE] [31-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
escaped msg: '[DATABASE] [31-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:57+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [31-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": "c7a5c4a2-80ab-478f-b44e-02652fc24e62", "x-request-start": "1741977658393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [31-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-14T18:40:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:40:57', STRUCTURED-DATA: '-',
msg: '[DATABASE] [31-6]'
escaped msg: '[DATABASE] [31-6]'
inputname: drain rawmsg: '<134>1 2025-03-14T18:40:57+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [31-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": "c7a5c4a2-80ab-478f-b44e-02652fc24e62", "x-request-start": "1741977658393" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [31-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:40:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:41:24', STRUCTURED-DATA: '-',
msg: '[DATABASE] [34-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:41:24.713 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692684" tid="2265387" log_line="26" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8594.810 ms  statement:'
escaped msg: '[DATABASE] [34-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:41:24.713 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692684" tid="2265387" log_line="26" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8594.810 ms  statement:'
inputname: drain rawmsg: '<134>1 2025-03-14T18:41:24+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [34-1]  sql_error_code = 00000 time_ms = "2025-03-14 18:41:24.713 UTC" pid="1405769" proc_start_time="2025-03-14 18:38:23 UTC" session_id="67d4779f.157349" vtid="6/5692684" tid="2265387" log_line="26" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(45154)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG:  duration: 8594.810 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": "473ab934-222e-4e8b-9689-5dc941137c05", "x-request-start": "1741977685388" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [34-1]  sql_error_code = 00000 time_ms = \"2025-03-14 18:41:24.713 UTC\" pid=\"1405769\" proc_start_time=\"2025-03-14 18:38:23 UTC\" session_id=\"67d4779f.157349\" vtid=\"6\/5692684\" tid=\"2265387\" log_line=\"26\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(45154)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG:  duration: 8594.810 ms  statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:41:24+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:41:24', STRUCTURED-DATA: '-',
msg: '[DATABASE] [34-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"'
escaped msg: '[DATABASE] [34-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__c"'
inputname: drain rawmsg: '<134>1 2025-03-14T18:41:24+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [34-2] #011        UPDATE "salesforce"."goc__configuration_item__c" AS t SET "sfid"=(CASE WHEN t."sfid" IS NULL THEN s."sfid" ELSE t."sfid" END),"goc__configuration_item_type__c"=s."goc__configuration_item_type__c","goc__path__c"=s."goc__path__c","name"=s."name","goc__parent_configuration_item__c"=s."goc__parent_configuration_item__c","isdeleted"=s."isdeleted","systemmodstamp"=s."systemmodstamp","createddate"=s."createddate","goc__status__c"=s."goc__status__c","goc__isactive__c"=s."goc__isactive__c","goc__root_node__c"=s."goc__root_node__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": "473ab934-222e-4e8b-9689-5dc941137c05", "x-request-start": "1741977685388" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [34-2] #011        UPDATE \"salesforce\".\"goc__configuration_item__c\" AS t SET \"sfid\"=(CASE WHEN t.\"sfid\" IS NULL THEN s.\"sfid\" ELSE t.\"sfid\" END),\"goc__configuration_item_type__c\"=s.\"goc__configuration_item_type__c\",\"goc__path__c\"=s.\"goc__path__c\",\"name\"=s.\"name\",\"goc__parent_configuration_item__c\"=s.\"goc__parent_configuration_item__c\",\"isdeleted\"=s.\"isdeleted\",\"systemmodstamp\"=s.\"systemmodstamp\",\"createddate\"=s.\"createddate\",\"goc__status__c\"=s.\"goc__status__c\",\"goc__isactive__c\"=s.\"goc__isactive__c\",\"goc__root_node__c\"=s.\"goc__root_node__c\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:41:24+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:41:24', STRUCTURED-DATA: '-',
msg: '[DATABASE] [34-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s'
escaped msg: '[DATABASE] [34-3] #011        FROM "_tmp_salesforce_goc__configuration_item__c" AS s'
inputname: drain rawmsg: '<134>1 2025-03-14T18:41:24+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [34-3] #011        FROM "_tmp_salesforce_goc__configuration_item__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": "473ab934-222e-4e8b-9689-5dc941137c05", "x-request-start": "1741977685388" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [34-3] #011        FROM \"_tmp_salesforce_goc__configuration_item__c\" AS s", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:41:24+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:41:24', STRUCTURED-DATA: '-',
msg: '[DATABASE] [34-4] #011        WHERE s.__operation in ('upsert', 'update') AND (t."systemmodstamp" IS NULL OR s."systemmodstamp" >= t."systemmodstamp") AND'
escaped msg: '[DATABASE] [34-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-14T18:41:24+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [34-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": "473ab934-222e-4e8b-9689-5dc941137c05", "x-request-start": "1741977685388" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [34-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-14T18:41:24+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:41:24', STRUCTURED-DATA: '-',
msg: '[DATABASE] [34-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
escaped msg: '[DATABASE] [34-5] #011            ((t."sfid" IS NOT NULL AND t."sfid" = s."sfid") )'
inputname: drain rawmsg: '<134>1 2025-03-14T18:41:24+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [34-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": "473ab934-222e-4e8b-9689-5dc941137c05", "x-request-start": "1741977685388" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [34-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-14T18:41:24+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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.3220717]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3220717', MSGID: '-',
TIMESTAMP: 'Mar 14 18:41:24', STRUCTURED-DATA: '-',
msg: '[DATABASE] [34-6]'
escaped msg: '[DATABASE] [34-6]'
inputname: drain rawmsg: '<134>1 2025-03-14T18:41:24+00:00 ip-10-1-102-204 app postgres.3220717 - - [DATABASE] [34-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": "473ab934-222e-4e8b-9689-5dc941137c05", "x-request-start": "1741977685388" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [34-6]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:41:24+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3220717", "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.3220717", "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" }
$/: