Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-', TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-1] sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.627 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963986" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement:' escaped msg: '[DATABASE] [12-1] sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.627 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963986" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement:' inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-1] sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.627 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963986" tid="0" log_line="4" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement:' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "11", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-1] sql_error_code = 00000 time_ms = \"2025-03-17 03:30:36.627 UTC\" pid=\"1447813\" proc_start_time=\"2025-03-17 03:30:28 UTC\" session_id=\"67d79754.161785\" vtid=\"6\/5963986\" tid=\"0\" log_line=\"4\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(33650)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: statement:", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-', TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-2] #011 CREATE TEMPORARY TABLE "_tmp_salesforce_user"' escaped msg: '[DATABASE] [12-2] #011 CREATE TEMPORARY TABLE "_tmp_salesforce_user"' inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-2] #011 CREATE TEMPORARY TABLE "_tmp_salesforce_user"' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "11", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-2] #011 CREATE TEMPORARY TABLE \"_tmp_salesforce_user\"", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-', TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-3] #011 ON COMMIT PRESERVE ROWS' escaped msg: '[DATABASE] [12-3] #011 ON COMMIT PRESERVE ROWS' inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-3] #011 ON COMMIT PRESERVE ROWS' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "11", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-3] #011 ON COMMIT PRESERVE ROWS", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-', TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-4] #011 AS' escaped msg: '[DATABASE] [12-4] #011 AS' inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-4] #011 AS' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "11", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-4] #011 AS", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-', TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-5] #011 SELECT "sfid","managerid","name","isactive","systemmodstamp","username","createddate","slack_id__c","email", now() as deleteddate,' escaped msg: '[DATABASE] [12-5] #011 SELECT "sfid","managerid","name","isactive","systemmodstamp","username","createddate","slack_id__c","email", now() as deleteddate,' inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-5] #011 SELECT "sfid","managerid","name","isactive","systemmodstamp","username","createddate","slack_id__c","email", now() as deleteddate,' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "11", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-5] #011 SELECT \"sfid\",\"managerid\",\"name\",\"isactive\",\"systemmodstamp\",\"username\",\"createddate\",\"slack_id__c\",\"email\", now() as deleteddate,", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-', TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-6] #011 ''::varchar(20) AS __operation' escaped msg: '[DATABASE] [12-6] #011 ''::varchar(20) AS __operation' inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-6] #011 ''::varchar(20) AS __operation' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "11", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-6] #011 ''::varchar(20) AS __operation", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-', TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-7] #011 FROM "salesforce"."user" WITH NO DATA' escaped msg: '[DATABASE] [12-7] #011 FROM "salesforce"."user" WITH NO DATA' inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-7] #011 FROM "salesforce"."user" WITH NO DATA' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "11", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-7] #011 FROM \"salesforce\".\"user\" WITH NO DATA", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-', TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-', msg: '[DATABASE] [12-8]' escaped msg: '[DATABASE] [12-8]' inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [12-8]' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "11", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [12-8]", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-', TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-', msg: '[DATABASE] [13-1] sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.633 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963987" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE UNIQUE INDEX ON' escaped msg: '[DATABASE] [13-1] sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.633 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963987" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE UNIQUE INDEX ON' inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [13-1] sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.633 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963987" tid="0" log_line="5" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE UNIQUE INDEX ON' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "11", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [13-1] sql_error_code = 00000 time_ms = \"2025-03-17 03:30:36.633 UTC\" pid=\"1447813\" proc_start_time=\"2025-03-17 03:30:28 UTC\" session_id=\"67d79754.161785\" vtid=\"6\/5963987\" tid=\"0\" log_line=\"5\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(33650)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: statement: CREATE UNIQUE INDEX ON", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-', TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-', msg: '[DATABASE] [13-2] #011 "_tmp_salesforce_user" ("sfid")' escaped msg: '[DATABASE] [13-2] #011 "_tmp_salesforce_user" ("sfid")' inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [13-2] #011 "_tmp_salesforce_user" ("sfid")' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "11", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [13-2] #011 \"_tmp_salesforce_user\" (\"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.3728740]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.3728740', MSGID: '-', TIMESTAMP: 'Mar 17 03:30:36', STRUCTURED-DATA: '-', msg: '[DATABASE] [14-1] sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.637 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963988" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE INDEX ON "_tmp_salesforce_user" (__operation, "sfid")' escaped msg: '[DATABASE] [14-1] sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.637 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963988" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE INDEX ON "_tmp_salesforce_user" (__operation, "sfid")' inputname: drain rawmsg: '<134>1 2025-03-17T03:30:36+00:00 ip-10-1-102-204 app postgres.3728740 - - [DATABASE] [14-1] sql_error_code = 00000 time_ms = "2025-03-17 03:30:36.637 UTC" pid="1447813" proc_start_time="2025-03-17 03:30:28 UTC" session_id="67d79754.161785" vtid="6/5963988" tid="0" log_line="6" database="dbgdbhuaqbckn5" connection_source="10.1.102.204(33650)" user="ue3280ufn31cpn" application_name="hc.fastworker" LOG: statement: CREATE INDEX ON "_tmp_salesforce_user" (__operation, "sfid")' $!:{ "metadata": { "httpheaders": { "host": "icc-log-drain.herokuapp.com", "user-agent": "log-shuttle\/v0.16.5 (go1.14.2; linux; amd64; gc)", "transfer-encoding": "chunked", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-msg-count": "11", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "053228ff-5568-4992-a86c-9c1883254c78", "x-request-start": "1742182237284" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [14-1] sql_error_code = 00000 time_ms = \"2025-03-17 03:30:36.637 UTC\" pid=\"1447813\" proc_start_time=\"2025-03-17 03:30:28 UTC\" session_id=\"67d79754.161785\" vtid=\"6\/5963988\" tid=\"0\" log_line=\"6\" database=\"dbgdbhuaqbckn5\" connection_source=\"10.1.102.204(33650)\" user=\"ue3280ufn31cpn\" application_name=\"hc.fastworker\" LOG: statement: CREATE INDEX ON \"_tmp_salesforce_user\" (__operation, \"sfid\")", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-17T03:30:36+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-102-204", "source": "app", "dyno": "postgres.3728740", "app": "-", "space": "icc-production-shield-oregon", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: