Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-58-156', PRI: 134, syslogtag 'app[postgres.4433]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.4433', MSGID: '-', TIMESTAMP: 'Mar 17 16:41:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [2292-1] sql_error_code = 00000 time_ms = "2025-03-17 16:41:49.303 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2409" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [2292-1] sql_error_code = 00000 time_ms = "2025-03-17 16:41:49.303 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2409" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-17T16:41:49+00:00 ip-10-1-58-156 app postgres.4433 - - [DATABASE] [2292-1] sql_error_code = 00000 time_ms = "2025-03-17 16:41:49.303 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2409" LOG: checkpoint starting: time' $!:{ "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": "2", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "54.156.16.153", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "be069b11-8e4c-4372-b717-105c511dc7e2", "x-request-start": "1742229709778" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-sandbox-shield-virginia" } }, "data": { "event": "[DATABASE] [2292-1] sql_error_code = 00000 time_ms = \"2025-03-17 16:41:49.303 UTC\" pid=\"6\" proc_start_time=\"2025-01-05 07:46:19 UTC\" session_id=\"677a38cb.6\" vtid=\"\" tid=\"0\" log_line=\"2409\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-58-156", "agent_timestamp": "2025-03-17T16:41:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.4433", "app": "-", "space": "icc-sandbox-shield-virginia", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-58-156", "source": "app", "dyno": "postgres.4433", "app": "-", "space": "icc-sandbox-shield-virginia", "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-58-156', PRI: 134, syslogtag 'app[postgres.4433]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.4433', MSGID: '-', TIMESTAMP: 'Mar 17 16:41:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [2293-1] sql_error_code = 00000 time_ms = "2025-03-17 16:41:49.517 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2410" LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.203 s, sync=0.003 s, total=0.214 s; sync files=1, longest=0.003 s, average=0.003 s; distance=32768 kB, estimate=72581 kB; lsn=E1/1A000060, redo lsn=E1/1A000028' escaped msg: '[DATABASE] [2293-1] sql_error_code = 00000 time_ms = "2025-03-17 16:41:49.517 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2410" LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.203 s, sync=0.003 s, total=0.214 s; sync files=1, longest=0.003 s, average=0.003 s; distance=32768 kB, estimate=72581 kB; lsn=E1/1A000060, redo lsn=E1/1A000028' inputname: drain rawmsg: '<134>1 2025-03-17T16:41:49+00:00 ip-10-1-58-156 app postgres.4433 - - [DATABASE] [2293-1] sql_error_code = 00000 time_ms = "2025-03-17 16:41:49.517 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2410" LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.203 s, sync=0.003 s, total=0.214 s; sync files=1, longest=0.003 s, average=0.003 s; distance=32768 kB, estimate=72581 kB; lsn=E1/1A000060, redo lsn=E1/1A000028' $!:{ "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": "2", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "54.156.16.153", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "be069b11-8e4c-4372-b717-105c511dc7e2", "x-request-start": "1742229709778" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-sandbox-shield-virginia" } }, "data": { "event": "[DATABASE] [2293-1] sql_error_code = 00000 time_ms = \"2025-03-17 16:41:49.517 UTC\" pid=\"6\" proc_start_time=\"2025-01-05 07:46:19 UTC\" session_id=\"677a38cb.6\" vtid=\"\" tid=\"0\" log_line=\"2410\" LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.203 s, sync=0.003 s, total=0.214 s; sync files=1, longest=0.003 s, average=0.003 s; distance=32768 kB, estimate=72581 kB; lsn=E1\/1A000060, redo lsn=E1\/1A000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-58-156", "agent_timestamp": "2025-03-17T16:41:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.4433", "app": "-", "space": "icc-sandbox-shield-virginia", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-58-156", "source": "app", "dyno": "postgres.4433", "app": "-", "space": "icc-sandbox-shield-virginia", "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-58-156', PRI: 134, syslogtag 'app[postgres.4433]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.4433', MSGID: '-', TIMESTAMP: 'Mar 17 22:04:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [2296-1] sql_error_code = 00000 time_ms = "2025-03-17 22:04:49.277 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2413" LOG: checkpoint starting: force wait' escaped msg: '[DATABASE] [2296-1] sql_error_code = 00000 time_ms = "2025-03-17 22:04:49.277 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2413" LOG: checkpoint starting: force wait' inputname: drain rawmsg: '<134>1 2025-03-17T22:04:49+00:00 ip-10-1-58-156 app postgres.4433 - - [DATABASE] [2296-1] sql_error_code = 00000 time_ms = "2025-03-17 22:04:49.277 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2413" LOG: checkpoint starting: force wait' $!:{ "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": "2", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "54.156.16.153", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "75e0fa11-e0be-4550-84fb-07bf93ff6d7c", "x-request-start": "1742249089682" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-sandbox-shield-virginia" } }, "data": { "event": "[DATABASE] [2296-1] sql_error_code = 00000 time_ms = \"2025-03-17 22:04:49.277 UTC\" pid=\"6\" proc_start_time=\"2025-01-05 07:46:19 UTC\" session_id=\"677a38cb.6\" vtid=\"\" tid=\"0\" log_line=\"2413\" LOG: checkpoint starting: force wait", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-58-156", "agent_timestamp": "2025-03-17T22:04:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.4433", "app": "-", "space": "icc-sandbox-shield-virginia", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-58-156", "source": "app", "dyno": "postgres.4433", "app": "-", "space": "icc-sandbox-shield-virginia", "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-58-156', PRI: 134, syslogtag 'app[postgres.4433]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.4433', MSGID: '-', TIMESTAMP: 'Mar 17 22:04:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [2297-1] sql_error_code = 00000 time_ms = "2025-03-17 22:04:49.294 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2414" LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.003 s, sync=0.001 s, total=0.018 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16384 kB, estimate=63378 kB; lsn=E1/1D000060, redo lsn=E1/1D000028' escaped msg: '[DATABASE] [2297-1] sql_error_code = 00000 time_ms = "2025-03-17 22:04:49.294 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2414" LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.003 s, sync=0.001 s, total=0.018 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16384 kB, estimate=63378 kB; lsn=E1/1D000060, redo lsn=E1/1D000028' inputname: drain rawmsg: '<134>1 2025-03-17T22:04:49+00:00 ip-10-1-58-156 app postgres.4433 - - [DATABASE] [2297-1] sql_error_code = 00000 time_ms = "2025-03-17 22:04:49.294 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2414" LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.003 s, sync=0.001 s, total=0.018 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16384 kB, estimate=63378 kB; lsn=E1/1D000060, redo lsn=E1/1D000028' $!:{ "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": "2", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "54.156.16.153", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "75e0fa11-e0be-4550-84fb-07bf93ff6d7c", "x-request-start": "1742249089682" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-sandbox-shield-virginia" } }, "data": { "event": "[DATABASE] [2297-1] sql_error_code = 00000 time_ms = \"2025-03-17 22:04:49.294 UTC\" pid=\"6\" proc_start_time=\"2025-01-05 07:46:19 UTC\" session_id=\"677a38cb.6\" vtid=\"\" tid=\"0\" log_line=\"2414\" LOG: checkpoint complete: wrote 0 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.003 s, sync=0.001 s, total=0.018 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16384 kB, estimate=63378 kB; lsn=E1\/1D000060, redo lsn=E1\/1D000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-58-156", "agent_timestamp": "2025-03-17T22:04:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.4433", "app": "-", "space": "icc-sandbox-shield-virginia", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-58-156", "source": "app", "dyno": "postgres.4433", "app": "-", "space": "icc-sandbox-shield-virginia", "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-58-156', PRI: 134, syslogtag 'app[postgres.4433]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.4433', MSGID: '-', TIMESTAMP: 'Mar 18 03:24:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [2300-1] sql_error_code = 00000 time_ms = "2025-03-18 03:24:49.398 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2417" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [2300-1] sql_error_code = 00000 time_ms = "2025-03-18 03:24:49.398 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2417" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-18T03:24:49+00:00 ip-10-1-58-156 app postgres.4433 - - [DATABASE] [2300-1] sql_error_code = 00000 time_ms = "2025-03-18 03:24:49.398 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2417" LOG: checkpoint starting: time' $!:{ "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": "1", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "54.156.16.153", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "48c06233-e0f8-4dee-81f6-2c615236a166", "x-request-start": "1742268290058" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-sandbox-shield-virginia" } }, "data": { "event": "[DATABASE] [2300-1] sql_error_code = 00000 time_ms = \"2025-03-18 03:24:49.398 UTC\" pid=\"6\" proc_start_time=\"2025-01-05 07:46:19 UTC\" session_id=\"677a38cb.6\" vtid=\"\" tid=\"0\" log_line=\"2417\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-58-156", "agent_timestamp": "2025-03-18T03:24:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.4433", "app": "-", "space": "icc-sandbox-shield-virginia", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-58-156", "source": "app", "dyno": "postgres.4433", "app": "-", "space": "icc-sandbox-shield-virginia", "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-58-156', PRI: 134, syslogtag 'app[postgres.4433]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.4433', MSGID: '-', TIMESTAMP: 'Mar 18 05:41:42', STRUCTURED-DATA: '-', msg: '[DATABASE] [2309-1] sql_error_code = 00000 time_ms = "2025-03-18 05:41:42.259 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2426" LOG: checkpoint complete: wrote 65 buffers (0.0%); 0 WAL file(s) added, 0 removed, 4 recycled; write=6.325 s, sync=0.003 s, total=6.339 s; sync files=30, longest=0.002 s, average=0.001 s; distance=65535 kB, estimate=65535 kB; lsn=E1/2B000060, redo lsn=E1/2B000028' escaped msg: '[DATABASE] [2309-1] sql_error_code = 00000 time_ms = "2025-03-18 05:41:42.259 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2426" LOG: checkpoint complete: wrote 65 buffers (0.0%); 0 WAL file(s) added, 0 removed, 4 recycled; write=6.325 s, sync=0.003 s, total=6.339 s; sync files=30, longest=0.002 s, average=0.001 s; distance=65535 kB, estimate=65535 kB; lsn=E1/2B000060, redo lsn=E1/2B000028' inputname: drain rawmsg: '<134>1 2025-03-18T05:41:42+00:00 ip-10-1-58-156 app postgres.4433 - - [DATABASE] [2309-1] sql_error_code = 00000 time_ms = "2025-03-18 05:41:42.259 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2426" LOG: checkpoint complete: wrote 65 buffers (0.0%); 0 WAL file(s) added, 0 removed, 4 recycled; write=6.325 s, sync=0.003 s, total=6.339 s; sync files=30, longest=0.002 s, average=0.001 s; distance=65535 kB, estimate=65535 kB; lsn=E1/2B000060, redo lsn=E1/2B000028' $!:{ "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": "1", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "54.156.16.153", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "f86063da-c9b7-4980-a9e0-f3206714aef9", "x-request-start": "1742276502812" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-sandbox-shield-virginia" } }, "data": { "event": "[DATABASE] [2309-1] sql_error_code = 00000 time_ms = \"2025-03-18 05:41:42.259 UTC\" pid=\"6\" proc_start_time=\"2025-01-05 07:46:19 UTC\" session_id=\"677a38cb.6\" vtid=\"\" tid=\"0\" log_line=\"2426\" LOG: checkpoint complete: wrote 65 buffers (0.0%); 0 WAL file(s) added, 0 removed, 4 recycled; write=6.325 s, sync=0.003 s, total=6.339 s; sync files=30, longest=0.002 s, average=0.001 s; distance=65535 kB, estimate=65535 kB; lsn=E1\/2B000060, redo lsn=E1\/2B000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-58-156", "agent_timestamp": "2025-03-18T05:41:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.4433", "app": "-", "space": "icc-sandbox-shield-virginia", "region": "-", "severity": "info", "uuid": "cd1b58c7-ffaf-4ef7-a8f4-72c5e2f70810" }, "owner": { "service": "icc", "team": "ICC", "environment": "-", "cloud": "ACE" } } } $.:{ "app_id": "ip-10-1-58-156", "source": "app", "dyno": "postgres.4433", "app": "-", "space": "icc-sandbox-shield-virginia", "region": "-", "team": "ICC", "service": "icc", "sourcetype": "-", "environment": "-", "cloud": "ACE", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: