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 04:44:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [2302-1] sql_error_code = 00000 time_ms = "2025-03-18 04:44:49.622 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2419" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [2302-1] sql_error_code = 00000 time_ms = "2025-03-18 04:44:49.622 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2419" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-18T04:44:49+00:00 ip-10-1-58-156 app postgres.4433 - - [DATABASE] [2302-1] sql_error_code = 00000 time_ms = "2025-03-18 04:44:49.622 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2419" 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": "5fa638e3-7b98-4fcf-ae7e-e60ed5e3208b", "x-request-start": "1742273090316" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-sandbox-shield-virginia" } }, "data": { "event": "[DATABASE] [2302-1] sql_error_code = 00000 time_ms = \"2025-03-18 04:44:49.622 UTC\" pid=\"6\" proc_start_time=\"2025-01-05 07:46:19 UTC\" session_id=\"677a38cb.6\" vtid=\"\" tid=\"0\" log_line=\"2419\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-58-156", "agent_timestamp": "2025-03-18T04:44: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 04:44:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [2303-1] sql_error_code = 00000 time_ms = "2025-03-18 04:44:49.735 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2420" LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.103 s, sync=0.003 s, total=0.114 s; sync files=1, longest=0.003 s, average=0.003 s; distance=32768 kB, estimate=62259 kB; lsn=E1/25000060, redo lsn=E1/25000028' escaped msg: '[DATABASE] [2303-1] sql_error_code = 00000 time_ms = "2025-03-18 04:44:49.735 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2420" LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.103 s, sync=0.003 s, total=0.114 s; sync files=1, longest=0.003 s, average=0.003 s; distance=32768 kB, estimate=62259 kB; lsn=E1/25000060, redo lsn=E1/25000028' inputname: drain rawmsg: '<134>1 2025-03-18T04:44:49+00:00 ip-10-1-58-156 app postgres.4433 - - [DATABASE] [2303-1] sql_error_code = 00000 time_ms = "2025-03-18 04:44:49.735 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2420" LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.103 s, sync=0.003 s, total=0.114 s; sync files=1, longest=0.003 s, average=0.003 s; distance=32768 kB, estimate=62259 kB; lsn=E1/25000060, redo lsn=E1/25000028' $!:{ "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": "5fa638e3-7b98-4fcf-ae7e-e60ed5e3208b", "x-request-start": "1742273090316" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-sandbox-shield-virginia" } }, "data": { "event": "[DATABASE] [2303-1] sql_error_code = 00000 time_ms = \"2025-03-18 04:44:49.735 UTC\" pid=\"6\" proc_start_time=\"2025-01-05 07:46:19 UTC\" session_id=\"677a38cb.6\" vtid=\"\" tid=\"0\" log_line=\"2420\" LOG: checkpoint complete: wrote 1 buffers (0.0%); 0 WAL file(s) added, 0 removed, 2 recycled; write=0.103 s, sync=0.003 s, total=0.114 s; sync files=1, longest=0.003 s, average=0.003 s; distance=32768 kB, estimate=62259 kB; lsn=E1\/25000060, redo lsn=E1\/25000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-58-156", "agent_timestamp": "2025-03-18T04:44: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:01:35', STRUCTURED-DATA: '-', msg: '[DATABASE] [2304-1] sql_error_code = 00000 time_ms = "2025-03-18 05:01:35.204 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2421" LOG: checkpoint starting: force wait' escaped msg: '[DATABASE] [2304-1] sql_error_code = 00000 time_ms = "2025-03-18 05:01:35.204 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2421" LOG: checkpoint starting: force wait' inputname: drain rawmsg: '<134>1 2025-03-18T05:01:35+00:00 ip-10-1-58-156 app postgres.4433 - - [DATABASE] [2304-1] sql_error_code = 00000 time_ms = "2025-03-18 05:01:35.204 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2421" 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": "c23b2dd3-fe50-4439-b616-890d4d6e4cbd", "x-request-start": "1742274095704" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-sandbox-shield-virginia" } }, "data": { "event": "[DATABASE] [2304-1] sql_error_code = 00000 time_ms = \"2025-03-18 05:01:35.204 UTC\" pid=\"6\" proc_start_time=\"2025-01-05 07:46:19 UTC\" session_id=\"677a38cb.6\" vtid=\"\" tid=\"0\" log_line=\"2421\" LOG: checkpoint starting: force wait", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-58-156", "agent_timestamp": "2025-03-18T05:01:35+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:01:35', STRUCTURED-DATA: '-', msg: '[DATABASE] [2305-1] sql_error_code = 00000 time_ms = "2025-03-18 05:01:35.214 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2422" 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.010 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16384 kB, estimate=57671 kB; lsn=E1/26000060, redo lsn=E1/26000028' escaped msg: '[DATABASE] [2305-1] sql_error_code = 00000 time_ms = "2025-03-18 05:01:35.214 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2422" 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.010 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16384 kB, estimate=57671 kB; lsn=E1/26000060, redo lsn=E1/26000028' inputname: drain rawmsg: '<134>1 2025-03-18T05:01:35+00:00 ip-10-1-58-156 app postgres.4433 - - [DATABASE] [2305-1] sql_error_code = 00000 time_ms = "2025-03-18 05:01:35.214 UTC" pid="6" proc_start_time="2025-01-05 07:46:19 UTC" session_id="677a38cb.6" vtid="" tid="0" log_line="2422" 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.010 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16384 kB, estimate=57671 kB; lsn=E1/26000060, redo lsn=E1/26000028' $!:{ "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": "c23b2dd3-fe50-4439-b616-890d4d6e4cbd", "x-request-start": "1742274095704" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-sandbox-shield-virginia" } }, "data": { "event": "[DATABASE] [2305-1] sql_error_code = 00000 time_ms = \"2025-03-18 05:01:35.214 UTC\" pid=\"6\" proc_start_time=\"2025-01-05 07:46:19 UTC\" session_id=\"677a38cb.6\" vtid=\"\" tid=\"0\" log_line=\"2422\" 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.010 s; sync files=0, longest=0.000 s, average=0.000 s; distance=16384 kB, estimate=57671 kB; lsn=E1\/26000060, redo lsn=E1\/26000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-58-156", "agent_timestamp": "2025-03-18T05:01:35+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" } $/: