Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'ip-10-1-102-204', PRI: 134, syslogtag 'app[postgres.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 18:30:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [18239-1] sql_error_code = 00000 time_ms = "2025-03-14 18:30:46.692 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18959" LOG: checkpoint starting: force wait' escaped msg: '[DATABASE] [18239-1] sql_error_code = 00000 time_ms = "2025-03-14 18:30:46.692 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18959" LOG: checkpoint starting: force wait' inputname: drain rawmsg: '<134>1 2025-03-14T18:30:46+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18239-1] sql_error_code = 00000 time_ms = "2025-03-14 18:30:46.692 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18959" 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": "1", "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": "76a59d68-2119-4f31-a86e-510c0c45e8db", "x-request-start": "1741977047289" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18239-1] sql_error_code = 00000 time_ms = \"2025-03-14 18:30:46.692 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"18959\" LOG: checkpoint starting: force wait", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:30:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 18:32:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [18240-1] sql_error_code = 00000 time_ms = "2025-03-14 18:32:46.627 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18960" LOG: checkpoint complete: wrote 1200 buffers (0.1%); 0 WAL file(s) added, 1 removed, 6 recycled; write=119.920 s, sync=0.002 s, total=119.936 s; sync files=37, longest=0.002 s, average=0.001 s; distance=81920 kB, estimate=136051 kB; lsn=8C1/65000060, redo lsn=8C1/63000028' escaped msg: '[DATABASE] [18240-1] sql_error_code = 00000 time_ms = "2025-03-14 18:32:46.627 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18960" LOG: checkpoint complete: wrote 1200 buffers (0.1%); 0 WAL file(s) added, 1 removed, 6 recycled; write=119.920 s, sync=0.002 s, total=119.936 s; sync files=37, longest=0.002 s, average=0.001 s; distance=81920 kB, estimate=136051 kB; lsn=8C1/65000060, redo lsn=8C1/63000028' inputname: drain rawmsg: '<134>1 2025-03-14T18:32:46+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18240-1] sql_error_code = 00000 time_ms = "2025-03-14 18:32:46.627 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18960" LOG: checkpoint complete: wrote 1200 buffers (0.1%); 0 WAL file(s) added, 1 removed, 6 recycled; write=119.920 s, sync=0.002 s, total=119.936 s; sync files=37, longest=0.002 s, average=0.001 s; distance=81920 kB, estimate=136051 kB; lsn=8C1/65000060, redo lsn=8C1/63000028' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "3927ddcf-227c-4f6a-86d9-43ce9ed9f28f", "x-request-start": "1741977167286" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18240-1] sql_error_code = 00000 time_ms = \"2025-03-14 18:32:46.627 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"18960\" LOG: checkpoint complete: wrote 1200 buffers (0.1%); 0 WAL file(s) added, 1 removed, 6 recycled; write=119.920 s, sync=0.002 s, total=119.936 s; sync files=37, longest=0.002 s, average=0.001 s; distance=81920 kB, estimate=136051 kB; lsn=8C1\/65000060, redo lsn=8C1\/63000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:32:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 18:56:03', STRUCTURED-DATA: '-', msg: '[DATABASE] [18244-1] sql_error_code = 00000 time_ms = "2025-03-14 18:56:03.772 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18964" LOG: checkpoint complete: wrote 3171 buffers (0.3%); 0 WAL file(s) added, 0 removed, 8 recycled; write=317.426 s, sync=0.004 s, total=317.442 s; sync files=91, longest=0.002 s, average=0.001 s; distance=187201 kB, estimate=189387 kB; lsn=8C1/7F000168, redo lsn=8C1/7A000028' escaped msg: '[DATABASE] [18244-1] sql_error_code = 00000 time_ms = "2025-03-14 18:56:03.772 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18964" LOG: checkpoint complete: wrote 3171 buffers (0.3%); 0 WAL file(s) added, 0 removed, 8 recycled; write=317.426 s, sync=0.004 s, total=317.442 s; sync files=91, longest=0.002 s, average=0.001 s; distance=187201 kB, estimate=189387 kB; lsn=8C1/7F000168, redo lsn=8C1/7A000028' inputname: drain rawmsg: '<134>1 2025-03-14T18:56:03+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18244-1] sql_error_code = 00000 time_ms = "2025-03-14 18:56:03.772 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18964" LOG: checkpoint complete: wrote 3171 buffers (0.3%); 0 WAL file(s) added, 0 removed, 8 recycled; write=317.426 s, sync=0.004 s, total=317.442 s; sync files=91, longest=0.002 s, average=0.001 s; distance=187201 kB, estimate=189387 kB; lsn=8C1/7F000168, redo lsn=8C1/7A000028' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "42c1f8d2-e01a-4cb2-a599-461ceb0747c3", "x-request-start": "1741978564543" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18244-1] sql_error_code = 00000 time_ms = \"2025-03-14 18:56:03.772 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"18964\" LOG: checkpoint complete: wrote 3171 buffers (0.3%); 0 WAL file(s) added, 0 removed, 8 recycled; write=317.426 s, sync=0.004 s, total=317.442 s; sync files=91, longest=0.002 s, average=0.001 s; distance=187201 kB, estimate=189387 kB; lsn=8C1\/7F000168, redo lsn=8C1\/7A000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T18:56:03+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 19:10:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [18247-1] sql_error_code = 00000 time_ms = "2025-03-14 19:10:46.810 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18967" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [18247-1] sql_error_code = 00000 time_ms = "2025-03-14 19:10:46.810 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18967" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-14T19:10:46+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18247-1] sql_error_code = 00000 time_ms = "2025-03-14 19:10:46.810 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18967" 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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "8a2b2532-8cba-44d3-891d-79579245097a", "x-request-start": "1741979447543" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18247-1] sql_error_code = 00000 time_ms = \"2025-03-14 19:10:46.810 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"18967\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T19:10:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 19:20:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [18249-1] sql_error_code = 00000 time_ms = "2025-03-14 19:20:46.922 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18969" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [18249-1] sql_error_code = 00000 time_ms = "2025-03-14 19:20:46.922 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18969" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-14T19:20:46+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18249-1] sql_error_code = 00000 time_ms = "2025-03-14 19:20:46.922 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18969" 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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "74b24f01-bf8a-4bb5-b902-eec69b17f122", "x-request-start": "1741980047797" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18249-1] sql_error_code = 00000 time_ms = \"2025-03-14 19:20:46.922 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"18969\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T19:20:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 19:20:48', STRUCTURED-DATA: '-', msg: '[DATABASE] [18250-1] sql_error_code = 00000 time_ms = "2025-03-14 19:20:48.353 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18970" LOG: checkpoint complete: wrote 15 buffers (0.0%); 0 WAL file(s) added, 0 removed, 5 recycled; write=1.419 s, sync=0.002 s, total=1.432 s; sync files=11, longest=0.001 s, average=0.001 s; distance=81920 kB, estimate=171322 kB; lsn=8C1/91000060, redo lsn=8C1/91000028' escaped msg: '[DATABASE] [18250-1] sql_error_code = 00000 time_ms = "2025-03-14 19:20:48.353 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18970" LOG: checkpoint complete: wrote 15 buffers (0.0%); 0 WAL file(s) added, 0 removed, 5 recycled; write=1.419 s, sync=0.002 s, total=1.432 s; sync files=11, longest=0.001 s, average=0.001 s; distance=81920 kB, estimate=171322 kB; lsn=8C1/91000060, redo lsn=8C1/91000028' inputname: drain rawmsg: '<134>1 2025-03-14T19:20:48+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18250-1] sql_error_code = 00000 time_ms = "2025-03-14 19:20:48.353 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18970" LOG: checkpoint complete: wrote 15 buffers (0.0%); 0 WAL file(s) added, 0 removed, 5 recycled; write=1.419 s, sync=0.002 s, total=1.432 s; sync files=11, longest=0.001 s, average=0.001 s; distance=81920 kB, estimate=171322 kB; lsn=8C1/91000060, redo lsn=8C1/91000028' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "a7f58dd3-7888-4f98-bdf1-354025a225a1", "x-request-start": "1741980049025" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18250-1] sql_error_code = 00000 time_ms = \"2025-03-14 19:20:48.353 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"18970\" LOG: checkpoint complete: wrote 15 buffers (0.0%); 0 WAL file(s) added, 0 removed, 5 recycled; write=1.419 s, sync=0.002 s, total=1.432 s; sync files=11, longest=0.001 s, average=0.001 s; distance=81920 kB, estimate=171322 kB; lsn=8C1\/91000060, redo lsn=8C1\/91000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T19:20:48+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 19:32:52', STRUCTURED-DATA: '-', msg: '[DATABASE] [18252-1] sql_error_code = 00000 time_ms = "2025-03-14 19:32:52.355 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18972" LOG: checkpoint complete: wrote 1257 buffers (0.1%); 0 WAL file(s) added, 0 removed, 11 recycled; write=125.415 s, sync=0.003 s, total=125.433 s; sync files=62, longest=0.002 s, average=0.001 s; distance=147456 kB, estimate=168936 kB; lsn=8C1/9C023F80, redo lsn=8C1/9A000028' escaped msg: '[DATABASE] [18252-1] sql_error_code = 00000 time_ms = "2025-03-14 19:32:52.355 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18972" LOG: checkpoint complete: wrote 1257 buffers (0.1%); 0 WAL file(s) added, 0 removed, 11 recycled; write=125.415 s, sync=0.003 s, total=125.433 s; sync files=62, longest=0.002 s, average=0.001 s; distance=147456 kB, estimate=168936 kB; lsn=8C1/9C023F80, redo lsn=8C1/9A000028' inputname: drain rawmsg: '<134>1 2025-03-14T19:32:52+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18252-1] sql_error_code = 00000 time_ms = "2025-03-14 19:32:52.355 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18972" LOG: checkpoint complete: wrote 1257 buffers (0.1%); 0 WAL file(s) added, 0 removed, 11 recycled; write=125.415 s, sync=0.003 s, total=125.433 s; sync files=62, longest=0.002 s, average=0.001 s; distance=147456 kB, estimate=168936 kB; lsn=8C1/9C023F80, redo lsn=8C1/9A000028' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "f3395327-b3a3-4c08-a1e8-4ac37aed2216", "x-request-start": "1741980773050" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18252-1] sql_error_code = 00000 time_ms = \"2025-03-14 19:32:52.355 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"18972\" LOG: checkpoint complete: wrote 1257 buffers (0.1%); 0 WAL file(s) added, 0 removed, 11 recycled; write=125.415 s, sync=0.003 s, total=125.433 s; sync files=62, longest=0.002 s, average=0.001 s; distance=147456 kB, estimate=168936 kB; lsn=8C1\/9C023F80, redo lsn=8C1\/9A000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T19:32:52+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 19:50:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [18255-1] sql_error_code = 00000 time_ms = "2025-03-14 19:50:46.593 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18975" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [18255-1] sql_error_code = 00000 time_ms = "2025-03-14 19:50:46.593 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18975" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-14T19:50:46+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18255-1] sql_error_code = 00000 time_ms = "2025-03-14 19:50:46.593 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18975" 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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "bd9dd43b-6068-4218-bc57-a165a532ce30", "x-request-start": "1741981847282" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18255-1] sql_error_code = 00000 time_ms = \"2025-03-14 19:50:46.593 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"18975\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T19:50:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 20:10:48', STRUCTURED-DATA: '-', msg: '[DATABASE] [18260-1] sql_error_code = 00000 time_ms = "2025-03-14 20:10:48.649 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18980" LOG: checkpoint complete: wrote 20 buffers (0.0%); 0 WAL file(s) added, 0 removed, 7 recycled; write=1.920 s, sync=0.002 s, total=1.936 s; sync files=16, longest=0.001 s, average=0.001 s; distance=114688 kB, estimate=151209 kB; lsn=8C1/B7000060, redo lsn=8C1/B7000028' escaped msg: '[DATABASE] [18260-1] sql_error_code = 00000 time_ms = "2025-03-14 20:10:48.649 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18980" LOG: checkpoint complete: wrote 20 buffers (0.0%); 0 WAL file(s) added, 0 removed, 7 recycled; write=1.920 s, sync=0.002 s, total=1.936 s; sync files=16, longest=0.001 s, average=0.001 s; distance=114688 kB, estimate=151209 kB; lsn=8C1/B7000060, redo lsn=8C1/B7000028' inputname: drain rawmsg: '<134>1 2025-03-14T20:10:48+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18260-1] sql_error_code = 00000 time_ms = "2025-03-14 20:10:48.649 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18980" LOG: checkpoint complete: wrote 20 buffers (0.0%); 0 WAL file(s) added, 0 removed, 7 recycled; write=1.920 s, sync=0.002 s, total=1.936 s; sync files=16, longest=0.001 s, average=0.001 s; distance=114688 kB, estimate=151209 kB; lsn=8C1/B7000060, redo lsn=8C1/B7000028' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "a259ca37-16f6-4d33-a3c1-523509496161", "x-request-start": "1741983049518" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18260-1] sql_error_code = 00000 time_ms = \"2025-03-14 20:10:48.649 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"18980\" LOG: checkpoint complete: wrote 20 buffers (0.0%); 0 WAL file(s) added, 0 removed, 7 recycled; write=1.920 s, sync=0.002 s, total=1.936 s; sync files=16, longest=0.001 s, average=0.001 s; distance=114688 kB, estimate=151209 kB; lsn=8C1\/B7000060, redo lsn=8C1\/B7000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T20:10:48+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 20:20:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [18261-1] sql_error_code = 00000 time_ms = "2025-03-14 20:20:46.107 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18981" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [18261-1] sql_error_code = 00000 time_ms = "2025-03-14 20:20:46.107 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18981" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-14T20:20:46+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18261-1] sql_error_code = 00000 time_ms = "2025-03-14 20:20:46.107 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18981" 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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "cc06e861-2e3a-44a9-a040-fbcc7425427e", "x-request-start": "1741983646658" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18261-1] sql_error_code = 00000 time_ms = \"2025-03-14 20:20:46.107 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"18981\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T20:20:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 20:20:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [18262-1] sql_error_code = 00000 time_ms = "2025-03-14 20:20:46.232 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18982" LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.116 s, sync=0.003 s, total=0.125 s; sync files=2, longest=0.002 s, average=0.002 s; distance=16384 kB, estimate=137726 kB; lsn=8C1/B8000060, redo lsn=8C1/B8000028' escaped msg: '[DATABASE] [18262-1] sql_error_code = 00000 time_ms = "2025-03-14 20:20:46.232 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18982" LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.116 s, sync=0.003 s, total=0.125 s; sync files=2, longest=0.002 s, average=0.002 s; distance=16384 kB, estimate=137726 kB; lsn=8C1/B8000060, redo lsn=8C1/B8000028' inputname: drain rawmsg: '<134>1 2025-03-14T20:20:46+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18262-1] sql_error_code = 00000 time_ms = "2025-03-14 20:20:46.232 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18982" LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.116 s, sync=0.003 s, total=0.125 s; sync files=2, longest=0.002 s, average=0.002 s; distance=16384 kB, estimate=137726 kB; lsn=8C1/B8000060, redo lsn=8C1/B8000028' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "cc06e861-2e3a-44a9-a040-fbcc7425427e", "x-request-start": "1741983646658" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18262-1] sql_error_code = 00000 time_ms = \"2025-03-14 20:20:46.232 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"18982\" LOG: checkpoint complete: wrote 2 buffers (0.0%); 0 WAL file(s) added, 0 removed, 1 recycled; write=0.116 s, sync=0.003 s, total=0.125 s; sync files=2, longest=0.002 s, average=0.002 s; distance=16384 kB, estimate=137726 kB; lsn=8C1\/B8000060, redo lsn=8C1\/B8000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T20:20:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 21:40:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [18277-1] sql_error_code = 00000 time_ms = "2025-03-14 21:40:46.727 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18997" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [18277-1] sql_error_code = 00000 time_ms = "2025-03-14 21:40:46.727 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18997" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-14T21:40:46+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18277-1] sql_error_code = 00000 time_ms = "2025-03-14 21:40:46.727 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18997" 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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "f6a5cf6b-d83e-4c85-a79d-effad56b5e77", "x-request-start": "1741988447270" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18277-1] sql_error_code = 00000 time_ms = \"2025-03-14 21:40:46.727 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"18997\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:40:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 21:45:55', STRUCTURED-DATA: '-', msg: '[DATABASE] [18278-1] sql_error_code = 00000 time_ms = "2025-03-14 21:45:55.027 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18998" LOG: checkpoint complete: wrote 3083 buffers (0.3%); 0 WAL file(s) added, 0 removed, 11 recycled; write=308.284 s, sync=0.002 s, total=308.301 s; sync files=55, longest=0.001 s, average=0.001 s; distance=131097 kB, estimate=161461 kB; lsn=8C1/F3000098, redo lsn=8C1/EF006540' escaped msg: '[DATABASE] [18278-1] sql_error_code = 00000 time_ms = "2025-03-14 21:45:55.027 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18998" LOG: checkpoint complete: wrote 3083 buffers (0.3%); 0 WAL file(s) added, 0 removed, 11 recycled; write=308.284 s, sync=0.002 s, total=308.301 s; sync files=55, longest=0.001 s, average=0.001 s; distance=131097 kB, estimate=161461 kB; lsn=8C1/F3000098, redo lsn=8C1/EF006540' inputname: drain rawmsg: '<134>1 2025-03-14T21:45:55+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18278-1] sql_error_code = 00000 time_ms = "2025-03-14 21:45:55.027 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="18998" LOG: checkpoint complete: wrote 3083 buffers (0.3%); 0 WAL file(s) added, 0 removed, 11 recycled; write=308.284 s, sync=0.002 s, total=308.301 s; sync files=55, longest=0.001 s, average=0.001 s; distance=131097 kB, estimate=161461 kB; lsn=8C1/F3000098, redo lsn=8C1/EF006540' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7087f707-dacb-492b-8dff-6df8c040771e", "x-request-start": "1741988755775" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18278-1] sql_error_code = 00000 time_ms = \"2025-03-14 21:45:55.027 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"18998\" LOG: checkpoint complete: wrote 3083 buffers (0.3%); 0 WAL file(s) added, 0 removed, 11 recycled; write=308.284 s, sync=0.002 s, total=308.301 s; sync files=55, longest=0.001 s, average=0.001 s; distance=131097 kB, estimate=161461 kB; lsn=8C1\/F3000098, redo lsn=8C1\/EF006540", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:45:55+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 21:52:59', STRUCTURED-DATA: '-', msg: '[DATABASE] [18280-1] sql_error_code = 00000 time_ms = "2025-03-14 21:52:59.434 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19000" LOG: checkpoint complete: wrote 1331 buffers (0.1%); 0 WAL file(s) added, 0 removed, 3 recycled; write=133.162 s, sync=0.002 s, total=133.172 s; sync files=34, longest=0.002 s, average=0.001 s; distance=98278 kB, estimate=155143 kB; lsn=8C1/F60018E0, redo lsn=8C1/F5000028' escaped msg: '[DATABASE] [18280-1] sql_error_code = 00000 time_ms = "2025-03-14 21:52:59.434 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19000" LOG: checkpoint complete: wrote 1331 buffers (0.1%); 0 WAL file(s) added, 0 removed, 3 recycled; write=133.162 s, sync=0.002 s, total=133.172 s; sync files=34, longest=0.002 s, average=0.001 s; distance=98278 kB, estimate=155143 kB; lsn=8C1/F60018E0, redo lsn=8C1/F5000028' inputname: drain rawmsg: '<134>1 2025-03-14T21:52:59+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18280-1] sql_error_code = 00000 time_ms = "2025-03-14 21:52:59.434 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19000" LOG: checkpoint complete: wrote 1331 buffers (0.1%); 0 WAL file(s) added, 0 removed, 3 recycled; write=133.162 s, sync=0.002 s, total=133.172 s; sync files=34, longest=0.002 s, average=0.001 s; distance=98278 kB, estimate=155143 kB; lsn=8C1/F60018E0, redo lsn=8C1/F5000028' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "4216e68d-d301-4b53-a4a4-082e2f6b4b3c", "x-request-start": "1741989180286" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18280-1] sql_error_code = 00000 time_ms = \"2025-03-14 21:52:59.434 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19000\" LOG: checkpoint complete: wrote 1331 buffers (0.1%); 0 WAL file(s) added, 0 removed, 3 recycled; write=133.162 s, sync=0.002 s, total=133.172 s; sync files=34, longest=0.002 s, average=0.001 s; distance=98278 kB, estimate=155143 kB; lsn=8C1\/F60018E0, redo lsn=8C1\/F5000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T21:52:59+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 22:10:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [18283-1] sql_error_code = 00000 time_ms = "2025-03-14 22:10:46.395 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19003" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [18283-1] sql_error_code = 00000 time_ms = "2025-03-14 22:10:46.395 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19003" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-14T22:10:46+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18283-1] sql_error_code = 00000 time_ms = "2025-03-14 22:10:46.395 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19003" 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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "6cd4826b-46da-4496-b2ca-65d9f274d21c", "x-request-start": "1741990247298" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18283-1] sql_error_code = 00000 time_ms = \"2025-03-14 22:10:46.395 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19003\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T22:10:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 22:10:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [18284-1] sql_error_code = 00000 time_ms = "2025-03-14 22:10:46.621 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19004" LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.216 s, sync=0.003 s, total=0.227 s; sync files=2, longest=0.002 s, average=0.002 s; distance=49152 kB, estimate=140903 kB; lsn=8C1/FF000060, redo lsn=8C1/FF000028' escaped msg: '[DATABASE] [18284-1] sql_error_code = 00000 time_ms = "2025-03-14 22:10:46.621 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19004" LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.216 s, sync=0.003 s, total=0.227 s; sync files=2, longest=0.002 s, average=0.002 s; distance=49152 kB, estimate=140903 kB; lsn=8C1/FF000060, redo lsn=8C1/FF000028' inputname: drain rawmsg: '<134>1 2025-03-14T22:10:46+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18284-1] sql_error_code = 00000 time_ms = "2025-03-14 22:10:46.621 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19004" LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.216 s, sync=0.003 s, total=0.227 s; sync files=2, longest=0.002 s, average=0.002 s; distance=49152 kB, estimate=140903 kB; lsn=8C1/FF000060, redo lsn=8C1/FF000028' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "6cd4826b-46da-4496-b2ca-65d9f274d21c", "x-request-start": "1741990247298" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18284-1] sql_error_code = 00000 time_ms = \"2025-03-14 22:10:46.621 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19004\" LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.216 s, sync=0.003 s, total=0.227 s; sync files=2, longest=0.002 s, average=0.002 s; distance=49152 kB, estimate=140903 kB; lsn=8C1\/FF000060, redo lsn=8C1\/FF000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T22:10:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 22:20:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [18285-1] sql_error_code = 00000 time_ms = "2025-03-14 22:20:46.039 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19005" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [18285-1] sql_error_code = 00000 time_ms = "2025-03-14 22:20:46.039 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19005" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-14T22:20:46+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18285-1] sql_error_code = 00000 time_ms = "2025-03-14 22:20:46.039 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19005" 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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "b02be8c1-515f-4fb0-bc4d-2b4feafd8c27", "x-request-start": "1741990846804" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18285-1] sql_error_code = 00000 time_ms = \"2025-03-14 22:20:46.039 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19005\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T22:20:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 22:20:50', STRUCTURED-DATA: '-', msg: '[DATABASE] [18286-1] sql_error_code = 00000 time_ms = "2025-03-14 22:20:50.578 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19006" LOG: checkpoint complete: wrote 46 buffers (0.0%); 0 WAL file(s) added, 0 removed, 5 recycled; write=4.527 s, sync=0.002 s, total=4.539 s; sync files=20, longest=0.001 s, average=0.001 s; distance=81920 kB, estimate=135004 kB; lsn=8C2/4000098, redo lsn=8C2/4000060' escaped msg: '[DATABASE] [18286-1] sql_error_code = 00000 time_ms = "2025-03-14 22:20:50.578 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19006" LOG: checkpoint complete: wrote 46 buffers (0.0%); 0 WAL file(s) added, 0 removed, 5 recycled; write=4.527 s, sync=0.002 s, total=4.539 s; sync files=20, longest=0.001 s, average=0.001 s; distance=81920 kB, estimate=135004 kB; lsn=8C2/4000098, redo lsn=8C2/4000060' inputname: drain rawmsg: '<134>1 2025-03-14T22:20:50+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18286-1] sql_error_code = 00000 time_ms = "2025-03-14 22:20:50.578 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19006" LOG: checkpoint complete: wrote 46 buffers (0.0%); 0 WAL file(s) added, 0 removed, 5 recycled; write=4.527 s, sync=0.002 s, total=4.539 s; sync files=20, longest=0.001 s, average=0.001 s; distance=81920 kB, estimate=135004 kB; lsn=8C2/4000098, redo lsn=8C2/4000060' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "793d9337-bc3a-47b9-a4c1-1208c8bb8f1d", "x-request-start": "1741990851279" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18286-1] sql_error_code = 00000 time_ms = \"2025-03-14 22:20:50.578 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19006\" LOG: checkpoint complete: wrote 46 buffers (0.0%); 0 WAL file(s) added, 0 removed, 5 recycled; write=4.527 s, sync=0.002 s, total=4.539 s; sync files=20, longest=0.001 s, average=0.001 s; distance=81920 kB, estimate=135004 kB; lsn=8C2\/4000098, redo lsn=8C2\/4000060", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T22:20:50+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 23:10:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [18295-1] sql_error_code = 00000 time_ms = "2025-03-14 23:10:46.809 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19015" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [18295-1] sql_error_code = 00000 time_ms = "2025-03-14 23:10:46.809 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19015" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-14T23:10:46+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18295-1] sql_error_code = 00000 time_ms = "2025-03-14 23:10:46.809 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19015" 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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "35f6bd62-9dc8-46f2-91fc-b7222caf313d", "x-request-start": "1741993847548" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18295-1] sql_error_code = 00000 time_ms = \"2025-03-14 23:10:46.809 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19015\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T23:10:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 23:20:46', STRUCTURED-DATA: '-', msg: '[DATABASE] [18297-1] sql_error_code = 00000 time_ms = "2025-03-14 23:20:46.569 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19017" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [18297-1] sql_error_code = 00000 time_ms = "2025-03-14 23:20:46.569 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19017" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-14T23:20:46+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18297-1] sql_error_code = 00000 time_ms = "2025-03-14 23:20:46.569 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19017" 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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "49c33b8a-c61e-4610-a1c0-f42737d6b52d", "x-request-start": "1741994447301" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18297-1] sql_error_code = 00000 time_ms = \"2025-03-14 23:20:46.569 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19017\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T23:20:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 23:20:47', STRUCTURED-DATA: '-', msg: '[DATABASE] [18298-1] sql_error_code = 00000 time_ms = "2025-03-14 23:20:47.297 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19018" LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.717 s, sync=0.003 s, total=0.728 s; sync files=6, longest=0.002 s, average=0.001 s; distance=49152 kB, estimate=167989 kB; lsn=8C2/2F000060, redo lsn=8C2/2F000028' escaped msg: '[DATABASE] [18298-1] sql_error_code = 00000 time_ms = "2025-03-14 23:20:47.297 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19018" LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.717 s, sync=0.003 s, total=0.728 s; sync files=6, longest=0.002 s, average=0.001 s; distance=49152 kB, estimate=167989 kB; lsn=8C2/2F000060, redo lsn=8C2/2F000028' inputname: drain rawmsg: '<134>1 2025-03-14T23:20:47+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18298-1] sql_error_code = 00000 time_ms = "2025-03-14 23:20:47.297 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19018" LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.717 s, sync=0.003 s, total=0.728 s; sync files=6, longest=0.002 s, average=0.001 s; distance=49152 kB, estimate=167989 kB; lsn=8C2/2F000060, redo lsn=8C2/2F000028' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "14f064f8-a688-4943-b650-040726aca814", "x-request-start": "1741994448018" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18298-1] sql_error_code = 00000 time_ms = \"2025-03-14 23:20:47.297 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19018\" LOG: checkpoint complete: wrote 8 buffers (0.0%); 0 WAL file(s) added, 0 removed, 3 recycled; write=0.717 s, sync=0.003 s, total=0.728 s; sync files=6, longest=0.002 s, average=0.001 s; distance=49152 kB, estimate=167989 kB; lsn=8C2\/2F000060, redo lsn=8C2\/2F000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T23:20:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 14 23:32:49', STRUCTURED-DATA: '-', msg: '[DATABASE] [18300-1] sql_error_code = 00000 time_ms = "2025-03-14 23:32:49.611 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19020" LOG: checkpoint complete: wrote 1228 buffers (0.1%); 0 WAL file(s) added, 0 removed, 7 recycled; write=122.698 s, sync=0.002 s, total=122.710 s; sync files=52, longest=0.001 s, average=0.001 s; distance=98304 kB, estimate=161021 kB; lsn=8C2/36000060, redo lsn=8C2/35000028' escaped msg: '[DATABASE] [18300-1] sql_error_code = 00000 time_ms = "2025-03-14 23:32:49.611 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19020" LOG: checkpoint complete: wrote 1228 buffers (0.1%); 0 WAL file(s) added, 0 removed, 7 recycled; write=122.698 s, sync=0.002 s, total=122.710 s; sync files=52, longest=0.001 s, average=0.001 s; distance=98304 kB, estimate=161021 kB; lsn=8C2/36000060, redo lsn=8C2/35000028' inputname: drain rawmsg: '<134>1 2025-03-14T23:32:49+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18300-1] sql_error_code = 00000 time_ms = "2025-03-14 23:32:49.611 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19020" LOG: checkpoint complete: wrote 1228 buffers (0.1%); 0 WAL file(s) added, 0 removed, 7 recycled; write=122.698 s, sync=0.002 s, total=122.710 s; sync files=52, longest=0.001 s, average=0.001 s; distance=98304 kB, estimate=161021 kB; lsn=8C2/36000060, redo lsn=8C2/35000028' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "72ea73fb-f892-41e0-8887-ba267609d059", "x-request-start": "1741995170291" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18300-1] sql_error_code = 00000 time_ms = \"2025-03-14 23:32:49.611 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19020\" LOG: checkpoint complete: wrote 1228 buffers (0.1%); 0 WAL file(s) added, 0 removed, 7 recycled; write=122.698 s, sync=0.002 s, total=122.710 s; sync files=52, longest=0.001 s, average=0.001 s; distance=98304 kB, estimate=161021 kB; lsn=8C2\/36000060, redo lsn=8C2\/35000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-14T23:32:49+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 15 00:10:58', STRUCTURED-DATA: '-', msg: '[DATABASE] [18308-1] sql_error_code = 00000 time_ms = "2025-03-15 00:10:58.198 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19028" LOG: checkpoint complete: wrote 110 buffers (0.0%); 0 WAL file(s) added, 0 removed, 6 recycled; write=10.937 s, sync=0.003 s, total=10.951 s; sync files=14, longest=0.002 s, average=0.001 s; distance=98192 kB, estimate=141545 kB; lsn=8C2/4F005CF0, redo lsn=8C2/4F000028' escaped msg: '[DATABASE] [18308-1] sql_error_code = 00000 time_ms = "2025-03-15 00:10:58.198 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19028" LOG: checkpoint complete: wrote 110 buffers (0.0%); 0 WAL file(s) added, 0 removed, 6 recycled; write=10.937 s, sync=0.003 s, total=10.951 s; sync files=14, longest=0.002 s, average=0.001 s; distance=98192 kB, estimate=141545 kB; lsn=8C2/4F005CF0, redo lsn=8C2/4F000028' inputname: drain rawmsg: '<134>1 2025-03-15T00:10:58+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18308-1] sql_error_code = 00000 time_ms = "2025-03-15 00:10:58.198 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19028" LOG: checkpoint complete: wrote 110 buffers (0.0%); 0 WAL file(s) added, 0 removed, 6 recycled; write=10.937 s, sync=0.003 s, total=10.951 s; sync files=14, longest=0.002 s, average=0.001 s; distance=98192 kB, estimate=141545 kB; lsn=8C2/4F005CF0, redo lsn=8C2/4F000028' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "ca2d5857-14af-4446-83ca-1a1f4b19b42e", "x-request-start": "1741997458749" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18308-1] sql_error_code = 00000 time_ms = \"2025-03-15 00:10:58.198 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19028\" LOG: checkpoint complete: wrote 110 buffers (0.0%); 0 WAL file(s) added, 0 removed, 6 recycled; write=10.937 s, sync=0.003 s, total=10.951 s; sync files=14, longest=0.002 s, average=0.001 s; distance=98192 kB, estimate=141545 kB; lsn=8C2\/4F005CF0, redo lsn=8C2\/4F000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:10:58+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 15 00:47:47', STRUCTURED-DATA: '-', msg: '[DATABASE] [18314-1] sql_error_code = 00000 time_ms = "2025-03-15 00:47:47.042 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19034" LOG: checkpoint complete: wrote 13232 buffers (1.3%); 0 WAL file(s) added, 4 removed, 18 recycled; write=419.055 s, sync=0.003 s, total=419.094 s; sync files=62, longest=0.002 s, average=0.001 s; distance=237807 kB, estimate=237807 kB; lsn=8C2/70090D98, redo lsn=8C2/6683BD98' escaped msg: '[DATABASE] [18314-1] sql_error_code = 00000 time_ms = "2025-03-15 00:47:47.042 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19034" LOG: checkpoint complete: wrote 13232 buffers (1.3%); 0 WAL file(s) added, 4 removed, 18 recycled; write=419.055 s, sync=0.003 s, total=419.094 s; sync files=62, longest=0.002 s, average=0.001 s; distance=237807 kB, estimate=237807 kB; lsn=8C2/70090D98, redo lsn=8C2/6683BD98' inputname: drain rawmsg: '<134>1 2025-03-15T00:47:47+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18314-1] sql_error_code = 00000 time_ms = "2025-03-15 00:47:47.042 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19034" LOG: checkpoint complete: wrote 13232 buffers (1.3%); 0 WAL file(s) added, 4 removed, 18 recycled; write=419.055 s, sync=0.003 s, total=419.094 s; sync files=62, longest=0.002 s, average=0.001 s; distance=237807 kB, estimate=237807 kB; lsn=8C2/70090D98, redo lsn=8C2/6683BD98' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "f80e39ac-b90e-434a-b309-d695d6e5402c", "x-request-start": "1741999667790" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18314-1] sql_error_code = 00000 time_ms = \"2025-03-15 00:47:47.042 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19034\" LOG: checkpoint complete: wrote 13232 buffers (1.3%); 0 WAL file(s) added, 4 removed, 18 recycled; write=419.055 s, sync=0.003 s, total=419.094 s; sync files=62, longest=0.002 s, average=0.001 s; distance=237807 kB, estimate=237807 kB; lsn=8C2\/70090D98, redo lsn=8C2\/6683BD98", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T00:47:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 15 01:30:47', STRUCTURED-DATA: '-', msg: '[DATABASE] [18321-1] sql_error_code = 00000 time_ms = "2025-03-15 01:30:47.727 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19041" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [18321-1] sql_error_code = 00000 time_ms = "2025-03-15 01:30:47.727 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19041" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-15T01:30:47+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18321-1] sql_error_code = 00000 time_ms = "2025-03-15 01:30:47.727 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19041" 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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "ccade248-f5ff-4360-abdb-69638d1081ff", "x-request-start": "1742002248541" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18321-1] sql_error_code = 00000 time_ms = \"2025-03-15 01:30:47.727 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19041\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T01:30:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 15 03:43:17', STRUCTURED-DATA: '-', msg: '[DATABASE] [18338-1] sql_error_code = 00000 time_ms = "2025-03-15 03:43:17.456 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19058" LOG: checkpoint complete: wrote 1500 buffers (0.1%); 0 WAL file(s) added, 0 removed, 3 recycled; write=149.988 s, sync=0.002 s, total=149.998 s; sync files=41, longest=0.001 s, average=0.001 s; distance=82203 kB, estimate=143222 kB; lsn=8C2/A513CD60, redo lsn=8C2/A5000028' escaped msg: '[DATABASE] [18338-1] sql_error_code = 00000 time_ms = "2025-03-15 03:43:17.456 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19058" LOG: checkpoint complete: wrote 1500 buffers (0.1%); 0 WAL file(s) added, 0 removed, 3 recycled; write=149.988 s, sync=0.002 s, total=149.998 s; sync files=41, longest=0.001 s, average=0.001 s; distance=82203 kB, estimate=143222 kB; lsn=8C2/A513CD60, redo lsn=8C2/A5000028' inputname: drain rawmsg: '<134>1 2025-03-15T03:43:17+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18338-1] sql_error_code = 00000 time_ms = "2025-03-15 03:43:17.456 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19058" LOG: checkpoint complete: wrote 1500 buffers (0.1%); 0 WAL file(s) added, 0 removed, 3 recycled; write=149.988 s, sync=0.002 s, total=149.998 s; sync files=41, longest=0.001 s, average=0.001 s; distance=82203 kB, estimate=143222 kB; lsn=8C2/A513CD60, redo lsn=8C2/A5000028' $!:{ "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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "f2a2083b-8d21-4f65-b7b3-5963323c2630", "x-request-start": "1742010198298" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18338-1] sql_error_code = 00000 time_ms = \"2025-03-15 03:43:17.456 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19058\" LOG: checkpoint complete: wrote 1500 buffers (0.1%); 0 WAL file(s) added, 0 removed, 3 recycled; write=149.988 s, sync=0.002 s, total=149.998 s; sync files=41, longest=0.001 s, average=0.001 s; distance=82203 kB, estimate=143222 kB; lsn=8C2\/A513CD60, redo lsn=8C2\/A5000028", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T03:43:17+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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.9147]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.9147', MSGID: '-', TIMESTAMP: 'Mar 15 04:40:47', STRUCTURED-DATA: '-', msg: '[DATABASE] [18343-1] sql_error_code = 00000 time_ms = "2025-03-15 04:40:47.447 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19063" LOG: checkpoint starting: time' escaped msg: '[DATABASE] [18343-1] sql_error_code = 00000 time_ms = "2025-03-15 04:40:47.447 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19063" LOG: checkpoint starting: time' inputname: drain rawmsg: '<134>1 2025-03-15T04:40:47+00:00 ip-10-1-102-204 app postgres.9147 - - [DATABASE] [18343-1] sql_error_code = 00000 time_ms = "2025-03-15 04:40:47.447 UTC" pid="6" proc_start_time="2024-12-31 18:47:49 UTC" session_id="67743c55.6" vtid="" tid="0" log_line="19063" 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": "52.11.247.42", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "52b4cb02-dc26-42c5-9214-ca2762a41443", "x-request-start": "1742013648101" }, "queryparams": { "cloud": "ACE", "team": "ICC", "service": "icc", "space": "icc-production-shield-oregon" } }, "data": { "event": "[DATABASE] [18343-1] sql_error_code = 00000 time_ms = \"2025-03-15 04:40:47.447 UTC\" pid=\"6\" proc_start_time=\"2024-12-31 18:47:49 UTC\" session_id=\"67743c55.6\" vtid=\"\" tid=\"0\" log_line=\"19063\" LOG: checkpoint starting: time", "source": "heroku.app", "sourcetype": "-", "hostname": "ip-10-1-102-204", "agent_timestamp": "2025-03-15T04:40:47+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.9147", "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.9147", "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" } $/: