Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[heroku-postgres]', programname: 'app', APP-NAME: 'app', PROCID: 'heroku-postgres', MSGID: '-', TIMESTAMP: 'Mar 15 18:16:43', STRUCTURED-DATA: '-', msg: 'source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0.055 sample#load-avg-5m=0.07 sample#load-avg-15m=0.1 sample#read-iops=0 sample#write-iops=0.06 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328512kB sample#memory-percentage-used=0.95906 sample#memory-cached=6524152kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:16UTC' escaped msg: 'source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0.055 sample#load-avg-5m=0.07 sample#load-avg-15m=0.1 sample#read-iops=0 sample#write-iops=0.06 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328512kB sample#memory-percentage-used=0.95906 sample#memory-cached=6524152kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:16UTC' inputname: drain rawmsg: '<134>1 2025-03-15T18:16:43+00:00 host app heroku-postgres - source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0.055 sample#load-avg-5m=0.07 sample#load-avg-15m=0.1 sample#read-iops=0 sample#write-iops=0.06 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328512kB sample#memory-percentage-used=0.95906 sample#memory-cached=6524152kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:16UTC' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1012", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "586e2f31-ed18-431b-b283-fc020bebd440", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "34.238.110.58", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "a9ef79d6-dc3f-d657-2192-ba98bb1c0b04", "x-request-start": "1742062617691" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "metric_tags": { "addon": "postgresql-regular-58279", "attachment": "DATABASE", "source": "app", "dyno": "heroku-postgres", "device": "host", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b", "team": "sfdc-platform-ecosystem", "service": "appexchange", "datacenter": "ext", "superpod": "heroku", "pod": "appx-staging-drain" }, "metric_service": "heroku-postgres", "metric_timestamp": 1742062603, "metric_value": "2025", "metric_name": "rollback-from", "data": { "event": "source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0.055 sample#load-avg-5m=0.07 sample#load-avg-15m=0.1 sample#read-iops=0 sample#write-iops=0.06 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328512kB sample#memory-percentage-used=0.95906 sample#memory-cached=6524152kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:16UTC", "source": "heroku.app", "sourcetype": "-", "hostname": "host", "agent_timestamp": "2025-03-15T18:16:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "heroku-postgres", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "host", "source": "app", "dyno": "heroku-postgres", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "runtime": { "rest": "sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0.055 sample#load-avg-5m=0.07 sample#load-avg-15m=0.1 sample#read-iops=0 sample#write-iops=0.06 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328512kB sample#memory-percentage-used=0.95906 sample#memory-cached=6524152kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:16UTC", "addon": "postgresql-regular-58279", "source": "DATABASE" }, "type": "log", "inc": 0, "fields": { "f1": "source=DATABASE", "f2": "addon=postgresql-regular-58279", "f3": "sample#primary-available=1", "f4": "sample#standby-available=1", "f5": "sample#current_transaction=2983647", "f6": "sample#db_size=1362776547bytes", "f7": "sample#db-max-size=274877906944bytes", "f8": "sample#db-size-percentage-used=0.00496", "f9": "sample#tables=8", "f10": "sample#active-connections=33", "f11": "sample#waiting-connections=0", "f12": "sample#max-connections=500", "f13": "sample#connections-percentage-used=0.06600", "f14": "sample#index-cache-hit-rate=0.99995", "f15": "sample#table-cache-hit-rate=0.99998", "f16": "sample#load-avg-1m=0.055", "f17": "sample#load-avg-5m=0.07", "f18": "sample#load-avg-15m=0.1", "f19": "sample#read-iops=0", "f20": "sample#write-iops=0.06", "f21": "sample#max-iops=3000", "f22": "sample#iops-percentage-used=0.00002", "f23": "sample#tmp-disk-used=543633408", "f24": "sample#tmp-disk-available=72435159040", "f25": "sample#memory-total=8024076kB", "f26": "sample#memory-free=328512kB", "f27": "sample#memory-percentage-used=0.95906", "f28": "sample#memory-cached=6524152kB", "f29": "sample#memory-postgres=109148kB", "f30": "sample#wal-percentage-used=0.06427136779541504", "f31": "sample#rollback-from=2025-03-08T18:16UTC" }, "format": "text", "sample": "rollback-from=2025-03-08T18:16UTC", "sample_key": "rollback-from", "sample_value": "2025-03-08T18:16UTC", "value": "2025", "units": "", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[heroku-postgres]', programname: 'app', APP-NAME: 'app', PROCID: 'heroku-postgres', MSGID: '-', TIMESTAMP: 'Mar 15 18:16:18', STRUCTURED-DATA: '-', msg: 'source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.06 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54376kB sample#memory-percentage-used=0.98621 sample#memory-cached=3011220kB sample#memory-postgres=9996kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:16UTC' escaped msg: 'source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.06 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54376kB sample#memory-percentage-used=0.98621 sample#memory-cached=3011220kB sample#memory-postgres=9996kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:16UTC' inputname: drain rawmsg: '<134>1 2025-03-15T18:16:18+00:00 host app heroku-postgres - source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.06 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54376kB sample#memory-percentage-used=0.98621 sample#memory-cached=3011220kB sample#memory-postgres=9996kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:16UTC' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "971", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.8fbf43ce-c860-448e-badd-3052c0f84a1b", "logplex-frame-id": "0fdf9622-158a-4e9f-bcc3-60b0a9cbab4e", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "54.163.99.229", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "24620630-b673-e89a-abdf-4192667464e5", "x-request-start": "1742062620582" }, "queryparams": { "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "metric_tags": { "addon": "postgresql-perpendicular-15086", "attachment": "DATABASE", "source": "app", "dyno": "heroku-postgres", "device": "host", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b", "team": "sfdc-platform-ecosystem", "service": "appexchange", "datacenter": "ext", "superpod": "heroku", "pod": "appx-staging-drain" }, "metric_service": "heroku-postgres", "metric_timestamp": 1742062578, "metric_value": "2025", "metric_name": "rollback-from", "data": { "event": "source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.06 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54376kB sample#memory-percentage-used=0.98621 sample#memory-cached=3011220kB sample#memory-postgres=9996kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:16UTC", "source": "heroku.app", "sourcetype": "-", "hostname": "host", "agent_timestamp": "2025-03-15T18:16:18+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "heroku-postgres", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "host", "source": "app", "dyno": "heroku-postgres", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "runtime": { "rest": "sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.06 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54376kB sample#memory-percentage-used=0.98621 sample#memory-cached=3011220kB sample#memory-postgres=9996kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:16UTC", "addon": "postgresql-perpendicular-15086", "source": "DATABASE" }, "type": "log", "inc": 0, "fields": { "f1": "source=DATABASE", "f2": "addon=postgresql-perpendicular-15086", "f3": "sample#service-available=1", "f4": "sample#current_transaction=2097", "f5": "sample#db_size=9839395bytes", "f6": "sample#db-max-size=68719476736bytes", "f7": "sample#db-size-percentage-used=0.00014", "f8": "sample#tables=2", "f9": "sample#active-connections=12", "f10": "sample#waiting-connections=0", "f11": "sample#max-connections=200", "f12": "sample#connections-percentage-used=0.06000", "f13": "sample#index-cache-hit-rate=0.96984", "f14": "sample#table-cache-hit-rate=0.98191", "f15": "sample#load-avg-1m=0", "f16": "sample#load-avg-5m=0", "f17": "sample#load-avg-15m=0", "f18": "sample#read-iops=0", "f19": "sample#write-iops=0.06", "f20": "sample#max-iops=3000", "f21": "sample#iops-percentage-used=0.00002", "f22": "sample#tmp-disk-used=543600640", "f23": "sample#tmp-disk-available=72435191808", "f24": "sample#memory-total=3944460kB", "f25": "sample#memory-free=54376kB", "f26": "sample#memory-percentage-used=0.98621", "f27": "sample#memory-cached=3011220kB", "f28": "sample#memory-postgres=9996kB", "f29": "sample#wal-percentage-used=0.06402321977269616", "f30": "sample#rollback-from=2025-03-11T18:16UTC" }, "format": "text", "sample": "rollback-from=2025-03-11T18:16UTC", "sample_key": "rollback-from", "sample_value": "2025-03-11T18:16UTC", "value": "2025", "units": "", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[heroku-postgres]', programname: 'app', APP-NAME: 'app', PROCID: 'heroku-postgres', MSGID: '-', TIMESTAMP: 'Mar 15 18:17:48', STRUCTURED-DATA: '-', msg: 'source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.082192 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54132kB sample#memory-percentage-used=0.98628 sample#memory-cached=3011400kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:17UTC' escaped msg: 'source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.082192 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54132kB sample#memory-percentage-used=0.98628 sample#memory-cached=3011400kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:17UTC' inputname: drain rawmsg: '<134>1 2025-03-15T18:17:48+00:00 host app heroku-postgres - source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.082192 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54132kB sample#memory-percentage-used=0.98628 sample#memory-cached=3011400kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:17UTC' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "975", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.8fbf43ce-c860-448e-badd-3052c0f84a1b", "logplex-frame-id": "349142a8-7bd5-4c30-aaf1-1471e95e5900", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "34.202.243.7", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "21ba4001-36f1-437c-f2b6-4932a906935e", "x-request-start": "1742062679106" }, "queryparams": { "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "metric_tags": { "addon": "postgresql-perpendicular-15086", "attachment": "DATABASE", "source": "app", "dyno": "heroku-postgres", "device": "host", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b", "team": "sfdc-platform-ecosystem", "service": "appexchange", "datacenter": "ext", "superpod": "heroku", "pod": "appx-staging-drain" }, "metric_service": "heroku-postgres", "metric_timestamp": 1742062668, "metric_value": "2025", "metric_name": "rollback-from", "data": { "event": "source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.082192 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54132kB sample#memory-percentage-used=0.98628 sample#memory-cached=3011400kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:17UTC", "source": "heroku.app", "sourcetype": "-", "hostname": "host", "agent_timestamp": "2025-03-15T18:17:48+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "heroku-postgres", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "host", "source": "app", "dyno": "heroku-postgres", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "runtime": { "rest": "sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.082192 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54132kB sample#memory-percentage-used=0.98628 sample#memory-cached=3011400kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:17UTC", "addon": "postgresql-perpendicular-15086", "source": "DATABASE" }, "type": "log", "inc": 0, "fields": { "f1": "source=DATABASE", "f2": "addon=postgresql-perpendicular-15086", "f3": "sample#service-available=1", "f4": "sample#current_transaction=2097", "f5": "sample#db_size=9839395bytes", "f6": "sample#db-max-size=68719476736bytes", "f7": "sample#db-size-percentage-used=0.00014", "f8": "sample#tables=2", "f9": "sample#active-connections=12", "f10": "sample#waiting-connections=0", "f11": "sample#max-connections=200", "f12": "sample#connections-percentage-used=0.06000", "f13": "sample#index-cache-hit-rate=0.96984", "f14": "sample#table-cache-hit-rate=0.98191", "f15": "sample#load-avg-1m=0", "f16": "sample#load-avg-5m=0", "f17": "sample#load-avg-15m=0", "f18": "sample#read-iops=0", "f19": "sample#write-iops=0.082192", "f20": "sample#max-iops=3000", "f21": "sample#iops-percentage-used=0.00003", "f22": "sample#tmp-disk-used=543600640", "f23": "sample#tmp-disk-available=72435191808", "f24": "sample#memory-total=3944460kB", "f25": "sample#memory-free=54132kB", "f26": "sample#memory-percentage-used=0.98628", "f27": "sample#memory-cached=3011400kB", "f28": "sample#memory-postgres=9112kB", "f29": "sample#wal-percentage-used=0.06402321977269616", "f30": "sample#rollback-from=2025-03-11T18:17UTC" }, "format": "text", "sample": "rollback-from=2025-03-11T18:17UTC", "sample_key": "rollback-from", "sample_value": "2025-03-11T18:17UTC", "value": "2025", "units": "", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[heroku-postgres]', programname: 'app', APP-NAME: 'app', PROCID: 'heroku-postgres', MSGID: '-', TIMESTAMP: 'Mar 15 18:19:42', STRUCTURED-DATA: '-', msg: 'source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0.005 sample#load-avg-5m=0.04 sample#load-avg-15m=0.085 sample#read-iops=0 sample#write-iops=0.040816 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=329300kB sample#memory-percentage-used=0.95896 sample#memory-cached=6524476kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:19UTC' escaped msg: 'source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0.005 sample#load-avg-5m=0.04 sample#load-avg-15m=0.085 sample#read-iops=0 sample#write-iops=0.040816 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=329300kB sample#memory-percentage-used=0.95896 sample#memory-cached=6524476kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:19UTC' inputname: drain rawmsg: '<134>1 2025-03-15T18:19:42+00:00 host app heroku-postgres - source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0.005 sample#load-avg-5m=0.04 sample#load-avg-15m=0.085 sample#read-iops=0 sample#write-iops=0.040816 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=329300kB sample#memory-percentage-used=0.95896 sample#memory-cached=6524476kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:19UTC' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1018", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "8a1a45d9-6c50-42c6-afdf-6cef32d27447", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "34.236.130.236", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "10c29180-707a-e3e1-46a6-991fbf8937ca", "x-request-start": "1742062794912" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "metric_tags": { "addon": "postgresql-regular-58279", "attachment": "DATABASE", "source": "app", "dyno": "heroku-postgres", "device": "host", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b", "team": "sfdc-platform-ecosystem", "service": "appexchange", "datacenter": "ext", "superpod": "heroku", "pod": "appx-staging-drain" }, "metric_service": "heroku-postgres", "metric_timestamp": 1742062782, "metric_value": "2025", "metric_name": "rollback-from", "data": { "event": "source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0.005 sample#load-avg-5m=0.04 sample#load-avg-15m=0.085 sample#read-iops=0 sample#write-iops=0.040816 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=329300kB sample#memory-percentage-used=0.95896 sample#memory-cached=6524476kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:19UTC", "source": "heroku.app", "sourcetype": "-", "hostname": "host", "agent_timestamp": "2025-03-15T18:19:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "heroku-postgres", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "host", "source": "app", "dyno": "heroku-postgres", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "runtime": { "rest": "sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0.005 sample#load-avg-5m=0.04 sample#load-avg-15m=0.085 sample#read-iops=0 sample#write-iops=0.040816 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=329300kB sample#memory-percentage-used=0.95896 sample#memory-cached=6524476kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:19UTC", "addon": "postgresql-regular-58279", "source": "DATABASE" }, "type": "log", "inc": 0, "fields": { "f1": "source=DATABASE", "f2": "addon=postgresql-regular-58279", "f3": "sample#primary-available=1", "f4": "sample#standby-available=1", "f5": "sample#current_transaction=2983647", "f6": "sample#db_size=1362776547bytes", "f7": "sample#db-max-size=274877906944bytes", "f8": "sample#db-size-percentage-used=0.00496", "f9": "sample#tables=8", "f10": "sample#active-connections=33", "f11": "sample#waiting-connections=0", "f12": "sample#max-connections=500", "f13": "sample#connections-percentage-used=0.06600", "f14": "sample#index-cache-hit-rate=0.99995", "f15": "sample#table-cache-hit-rate=0.99998", "f16": "sample#load-avg-1m=0.005", "f17": "sample#load-avg-5m=0.04", "f18": "sample#load-avg-15m=0.085", "f19": "sample#read-iops=0", "f20": "sample#write-iops=0.040816", "f21": "sample#max-iops=3000", "f22": "sample#iops-percentage-used=0.00001", "f23": "sample#tmp-disk-used=543633408", "f24": "sample#tmp-disk-available=72435159040", "f25": "sample#memory-total=8024076kB", "f26": "sample#memory-free=329300kB", "f27": "sample#memory-percentage-used=0.95896", "f28": "sample#memory-cached=6524476kB", "f29": "sample#memory-postgres=109148kB", "f30": "sample#wal-percentage-used=0.06427136779541504", "f31": "sample#rollback-from=2025-03-08T18:19UTC" }, "format": "text", "sample": "rollback-from=2025-03-08T18:19UTC", "sample_key": "rollback-from", "sample_value": "2025-03-08T18:19UTC", "value": "2025", "units": "", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[heroku-postgres]', programname: 'app', APP-NAME: 'app', PROCID: 'heroku-postgres', MSGID: '-', TIMESTAMP: 'Mar 15 18:19:17', STRUCTURED-DATA: '-', msg: 'source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.09434 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54820kB sample#memory-percentage-used=0.98610 sample#memory-cached=3011576kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:19UTC' escaped msg: 'source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.09434 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54820kB sample#memory-percentage-used=0.98610 sample#memory-cached=3011576kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:19UTC' inputname: drain rawmsg: '<134>1 2025-03-15T18:19:17+00:00 host app heroku-postgres - source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.09434 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54820kB sample#memory-percentage-used=0.98610 sample#memory-cached=3011576kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:19UTC' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "974", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.8fbf43ce-c860-448e-badd-3052c0f84a1b", "logplex-frame-id": "5fa31e05-36b5-4503-b8a6-c99c111d7087", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "52.71.146.117", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "92e20130-d4d9-1bf3-1fbb-3682812d2396", "x-request-start": "1742062798280" }, "queryparams": { "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "metric_tags": { "addon": "postgresql-perpendicular-15086", "attachment": "DATABASE", "source": "app", "dyno": "heroku-postgres", "device": "host", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b", "team": "sfdc-platform-ecosystem", "service": "appexchange", "datacenter": "ext", "superpod": "heroku", "pod": "appx-staging-drain" }, "metric_service": "heroku-postgres", "metric_timestamp": 1742062757, "metric_value": "2025", "metric_name": "rollback-from", "data": { "event": "source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.09434 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54820kB sample#memory-percentage-used=0.98610 sample#memory-cached=3011576kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:19UTC", "source": "heroku.app", "sourcetype": "-", "hostname": "host", "agent_timestamp": "2025-03-15T18:19:17+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "heroku-postgres", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "host", "source": "app", "dyno": "heroku-postgres", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "runtime": { "rest": "sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.09434 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54820kB sample#memory-percentage-used=0.98610 sample#memory-cached=3011576kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:19UTC", "addon": "postgresql-perpendicular-15086", "source": "DATABASE" }, "type": "log", "inc": 0, "fields": { "f1": "source=DATABASE", "f2": "addon=postgresql-perpendicular-15086", "f3": "sample#service-available=1", "f4": "sample#current_transaction=2097", "f5": "sample#db_size=9839395bytes", "f6": "sample#db-max-size=68719476736bytes", "f7": "sample#db-size-percentage-used=0.00014", "f8": "sample#tables=2", "f9": "sample#active-connections=12", "f10": "sample#waiting-connections=0", "f11": "sample#max-connections=200", "f12": "sample#connections-percentage-used=0.06000", "f13": "sample#index-cache-hit-rate=0.96984", "f14": "sample#table-cache-hit-rate=0.98191", "f15": "sample#load-avg-1m=0", "f16": "sample#load-avg-5m=0", "f17": "sample#load-avg-15m=0", "f18": "sample#read-iops=0", "f19": "sample#write-iops=0.09434", "f20": "sample#max-iops=3000", "f21": "sample#iops-percentage-used=0.00003", "f22": "sample#tmp-disk-used=543600640", "f23": "sample#tmp-disk-available=72435191808", "f24": "sample#memory-total=3944460kB", "f25": "sample#memory-free=54820kB", "f26": "sample#memory-percentage-used=0.98610", "f27": "sample#memory-cached=3011576kB", "f28": "sample#memory-postgres=9112kB", "f29": "sample#wal-percentage-used=0.06402321977269616", "f30": "sample#rollback-from=2025-03-11T18:19UTC" }, "format": "text", "sample": "rollback-from=2025-03-11T18:19UTC", "sample_key": "rollback-from", "sample_value": "2025-03-11T18:19UTC", "value": "2025", "units": "", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[heroku-postgres]', programname: 'app', APP-NAME: 'app', PROCID: 'heroku-postgres', MSGID: '-', TIMESTAMP: 'Mar 15 18:20:35', STRUCTURED-DATA: '-', msg: 'source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.03 sample#load-avg-15m=0.075 sample#read-iops=0 sample#write-iops=0.036697 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=326512kB sample#memory-percentage-used=0.95931 sample#memory-cached=6524536kB sample#memory-postgres=115468kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:20UTC' escaped msg: 'source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.03 sample#load-avg-15m=0.075 sample#read-iops=0 sample#write-iops=0.036697 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=326512kB sample#memory-percentage-used=0.95931 sample#memory-cached=6524536kB sample#memory-postgres=115468kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:20UTC' inputname: drain rawmsg: '<134>1 2025-03-15T18:20:35+00:00 host app heroku-postgres - source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.03 sample#load-avg-15m=0.075 sample#read-iops=0 sample#write-iops=0.036697 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=326512kB sample#memory-percentage-used=0.95931 sample#memory-cached=6524536kB sample#memory-postgres=115468kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:20UTC' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1014", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "b6a998d5-b44f-4b21-9381-5d3c834b5344", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "44.196.251.161", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "2f2dc161-b0fe-f3f1-e469-4a84adfcffc5", "x-request-start": "1742062858016" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "metric_tags": { "addon": "postgresql-regular-58279", "attachment": "DATABASE", "source": "app", "dyno": "heroku-postgres", "device": "host", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b", "team": "sfdc-platform-ecosystem", "service": "appexchange", "datacenter": "ext", "superpod": "heroku", "pod": "appx-staging-drain" }, "metric_service": "heroku-postgres", "metric_timestamp": 1742062835, "metric_value": "2025", "metric_name": "rollback-from", "data": { "event": "source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.03 sample#load-avg-15m=0.075 sample#read-iops=0 sample#write-iops=0.036697 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=326512kB sample#memory-percentage-used=0.95931 sample#memory-cached=6524536kB sample#memory-postgres=115468kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:20UTC", "source": "heroku.app", "sourcetype": "-", "hostname": "host", "agent_timestamp": "2025-03-15T18:20:35+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "heroku-postgres", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "host", "source": "app", "dyno": "heroku-postgres", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "runtime": { "rest": "sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.03 sample#load-avg-15m=0.075 sample#read-iops=0 sample#write-iops=0.036697 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=326512kB sample#memory-percentage-used=0.95931 sample#memory-cached=6524536kB sample#memory-postgres=115468kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:20UTC", "addon": "postgresql-regular-58279", "source": "DATABASE" }, "type": "log", "inc": 0, "fields": { "f1": "source=DATABASE", "f2": "addon=postgresql-regular-58279", "f3": "sample#primary-available=1", "f4": "sample#standby-available=1", "f5": "sample#current_transaction=2983647", "f6": "sample#db_size=1362776547bytes", "f7": "sample#db-max-size=274877906944bytes", "f8": "sample#db-size-percentage-used=0.00496", "f9": "sample#tables=8", "f10": "sample#active-connections=33", "f11": "sample#waiting-connections=0", "f12": "sample#max-connections=500", "f13": "sample#connections-percentage-used=0.06600", "f14": "sample#index-cache-hit-rate=0.99995", "f15": "sample#table-cache-hit-rate=0.99998", "f16": "sample#load-avg-1m=0", "f17": "sample#load-avg-5m=0.03", "f18": "sample#load-avg-15m=0.075", "f19": "sample#read-iops=0", "f20": "sample#write-iops=0.036697", "f21": "sample#max-iops=3000", "f22": "sample#iops-percentage-used=0.00001", "f23": "sample#tmp-disk-used=543633408", "f24": "sample#tmp-disk-available=72435159040", "f25": "sample#memory-total=8024076kB", "f26": "sample#memory-free=326512kB", "f27": "sample#memory-percentage-used=0.95931", "f28": "sample#memory-cached=6524536kB", "f29": "sample#memory-postgres=115468kB", "f30": "sample#wal-percentage-used=0.06427136779541504", "f31": "sample#rollback-from=2025-03-08T18:20UTC" }, "format": "text", "sample": "rollback-from=2025-03-08T18:20UTC", "sample_key": "rollback-from", "sample_value": "2025-03-08T18:20UTC", "value": "2025", "units": "", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[heroku-postgres]', programname: 'app', APP-NAME: 'app', PROCID: 'heroku-postgres', MSGID: '-', TIMESTAMP: 'Mar 15 18:22:42', STRUCTURED-DATA: '-', msg: 'source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=34 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06800 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.015 sample#load-avg-15m=0.06 sample#read-iops=0 sample#write-iops=0.048387 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328096kB sample#memory-percentage-used=0.95911 sample#memory-cached=6524876kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:22UTC' escaped msg: 'source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=34 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06800 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.015 sample#load-avg-15m=0.06 sample#read-iops=0 sample#write-iops=0.048387 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328096kB sample#memory-percentage-used=0.95911 sample#memory-cached=6524876kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:22UTC' inputname: drain rawmsg: '<134>1 2025-03-15T18:22:42+00:00 host app heroku-postgres - source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=34 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06800 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.015 sample#load-avg-15m=0.06 sample#read-iops=0 sample#write-iops=0.048387 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328096kB sample#memory-percentage-used=0.95911 sample#memory-cached=6524876kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:22UTC' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1014", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "df757433-5c13-4d2c-8e4f-198d8ac74d9a", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "100.24.144.144", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "a81041b4-0243-571d-1dd7-88f228ceff37", "x-request-start": "1742062977609" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "metric_tags": { "addon": "postgresql-regular-58279", "attachment": "DATABASE", "source": "app", "dyno": "heroku-postgres", "device": "host", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b", "team": "sfdc-platform-ecosystem", "service": "appexchange", "datacenter": "ext", "superpod": "heroku", "pod": "appx-staging-drain" }, "metric_service": "heroku-postgres", "metric_timestamp": 1742062962, "metric_value": "2025", "metric_name": "rollback-from", "data": { "event": "source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=34 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06800 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.015 sample#load-avg-15m=0.06 sample#read-iops=0 sample#write-iops=0.048387 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328096kB sample#memory-percentage-used=0.95911 sample#memory-cached=6524876kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:22UTC", "source": "heroku.app", "sourcetype": "-", "hostname": "host", "agent_timestamp": "2025-03-15T18:22:42+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "heroku-postgres", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "host", "source": "app", "dyno": "heroku-postgres", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "runtime": { "rest": "sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=34 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06800 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.015 sample#load-avg-15m=0.06 sample#read-iops=0 sample#write-iops=0.048387 sample#max-iops=3000 sample#iops-percentage-used=0.00002 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328096kB sample#memory-percentage-used=0.95911 sample#memory-cached=6524876kB sample#memory-postgres=109148kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:22UTC", "addon": "postgresql-regular-58279", "source": "DATABASE" }, "type": "log", "inc": 0, "fields": { "f1": "source=DATABASE", "f2": "addon=postgresql-regular-58279", "f3": "sample#primary-available=1", "f4": "sample#standby-available=1", "f5": "sample#current_transaction=2983647", "f6": "sample#db_size=1362776547bytes", "f7": "sample#db-max-size=274877906944bytes", "f8": "sample#db-size-percentage-used=0.00496", "f9": "sample#tables=8", "f10": "sample#active-connections=34", "f11": "sample#waiting-connections=0", "f12": "sample#max-connections=500", "f13": "sample#connections-percentage-used=0.06800", "f14": "sample#index-cache-hit-rate=0.99995", "f15": "sample#table-cache-hit-rate=0.99998", "f16": "sample#load-avg-1m=0", "f17": "sample#load-avg-5m=0.015", "f18": "sample#load-avg-15m=0.06", "f19": "sample#read-iops=0", "f20": "sample#write-iops=0.048387", "f21": "sample#max-iops=3000", "f22": "sample#iops-percentage-used=0.00002", "f23": "sample#tmp-disk-used=543633408", "f24": "sample#tmp-disk-available=72435159040", "f25": "sample#memory-total=8024076kB", "f26": "sample#memory-free=328096kB", "f27": "sample#memory-percentage-used=0.95911", "f28": "sample#memory-cached=6524876kB", "f29": "sample#memory-postgres=109148kB", "f30": "sample#wal-percentage-used=0.06427136779541504", "f31": "sample#rollback-from=2025-03-08T18:22UTC" }, "format": "text", "sample": "rollback-from=2025-03-08T18:22UTC", "sample_key": "rollback-from", "sample_value": "2025-03-08T18:22UTC", "value": "2025", "units": "", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[heroku-postgres]', programname: 'app', APP-NAME: 'app', PROCID: 'heroku-postgres', MSGID: '-', TIMESTAMP: 'Mar 15 18:22:17', STRUCTURED-DATA: '-', msg: 'source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=8 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.04000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.1 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54408kB sample#memory-percentage-used=0.98621 sample#memory-cached=3011924kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:22UTC' escaped msg: 'source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=8 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.04000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.1 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54408kB sample#memory-percentage-used=0.98621 sample#memory-cached=3011924kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:22UTC' inputname: drain rawmsg: '<134>1 2025-03-15T18:22:17+00:00 host app heroku-postgres - source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=8 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.04000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.1 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54408kB sample#memory-percentage-used=0.98621 sample#memory-cached=3011924kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:22UTC' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "969", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.8fbf43ce-c860-448e-badd-3052c0f84a1b", "logplex-frame-id": "920af20e-296b-4964-80b7-77c93c1c2483", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "18.205.65.82", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "0973d173-f876-18e7-6fd8-99c31a27a65b", "x-request-start": "1742062980151" }, "queryparams": { "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "metric_tags": { "addon": "postgresql-perpendicular-15086", "attachment": "DATABASE", "source": "app", "dyno": "heroku-postgres", "device": "host", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b", "team": "sfdc-platform-ecosystem", "service": "appexchange", "datacenter": "ext", "superpod": "heroku", "pod": "appx-staging-drain" }, "metric_service": "heroku-postgres", "metric_timestamp": 1742062937, "metric_value": "2025", "metric_name": "rollback-from", "data": { "event": "source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=8 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.04000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.1 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54408kB sample#memory-percentage-used=0.98621 sample#memory-cached=3011924kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:22UTC", "source": "heroku.app", "sourcetype": "-", "hostname": "host", "agent_timestamp": "2025-03-15T18:22:17+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "heroku-postgres", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "host", "source": "app", "dyno": "heroku-postgres", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "runtime": { "rest": "sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=8 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.04000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.1 sample#max-iops=3000 sample#iops-percentage-used=0.00003 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54408kB sample#memory-percentage-used=0.98621 sample#memory-cached=3011924kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:22UTC", "addon": "postgresql-perpendicular-15086", "source": "DATABASE" }, "type": "log", "inc": 0, "fields": { "f1": "source=DATABASE", "f2": "addon=postgresql-perpendicular-15086", "f3": "sample#service-available=1", "f4": "sample#current_transaction=2097", "f5": "sample#db_size=9839395bytes", "f6": "sample#db-max-size=68719476736bytes", "f7": "sample#db-size-percentage-used=0.00014", "f8": "sample#tables=2", "f9": "sample#active-connections=8", "f10": "sample#waiting-connections=0", "f11": "sample#max-connections=200", "f12": "sample#connections-percentage-used=0.04000", "f13": "sample#index-cache-hit-rate=0.96984", "f14": "sample#table-cache-hit-rate=0.98191", "f15": "sample#load-avg-1m=0", "f16": "sample#load-avg-5m=0", "f17": "sample#load-avg-15m=0", "f18": "sample#read-iops=0", "f19": "sample#write-iops=0.1", "f20": "sample#max-iops=3000", "f21": "sample#iops-percentage-used=0.00003", "f22": "sample#tmp-disk-used=543600640", "f23": "sample#tmp-disk-available=72435191808", "f24": "sample#memory-total=3944460kB", "f25": "sample#memory-free=54408kB", "f26": "sample#memory-percentage-used=0.98621", "f27": "sample#memory-cached=3011924kB", "f28": "sample#memory-postgres=9112kB", "f29": "sample#wal-percentage-used=0.06402321977269616", "f30": "sample#rollback-from=2025-03-11T18:22UTC" }, "format": "text", "sample": "rollback-from=2025-03-11T18:22UTC", "sample_key": "rollback-from", "sample_value": "2025-03-11T18:22UTC", "value": "2025", "units": "", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[heroku-postgres]', programname: 'app', APP-NAME: 'app', PROCID: 'heroku-postgres', MSGID: '-', TIMESTAMP: 'Mar 15 18:23:46', STRUCTURED-DATA: '-', msg: 'source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.10938 sample#max-iops=3000 sample#iops-percentage-used=0.00004 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54272kB sample#memory-percentage-used=0.98624 sample#memory-cached=3011980kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:25UTC' escaped msg: 'source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.10938 sample#max-iops=3000 sample#iops-percentage-used=0.00004 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54272kB sample#memory-percentage-used=0.98624 sample#memory-cached=3011980kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:25UTC' inputname: drain rawmsg: '<134>1 2025-03-15T18:23:46+00:00 host app heroku-postgres - source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.10938 sample#max-iops=3000 sample#iops-percentage-used=0.00004 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54272kB sample#memory-percentage-used=0.98624 sample#memory-cached=3011980kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:25UTC' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "974", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.8fbf43ce-c860-448e-badd-3052c0f84a1b", "logplex-frame-id": "be2fc2d1-276e-4d76-8b31-13b72e4a5e5d", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "18.233.75.40", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "df11a909-1124-c2e4-1687-7b2e34b9e7b6", "x-request-start": "1742063102826" }, "queryparams": { "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "metric_tags": { "addon": "postgresql-perpendicular-15086", "attachment": "DATABASE", "source": "app", "dyno": "heroku-postgres", "device": "host", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b", "team": "sfdc-platform-ecosystem", "service": "appexchange", "datacenter": "ext", "superpod": "heroku", "pod": "appx-staging-drain" }, "metric_service": "heroku-postgres", "metric_timestamp": 1742063026, "metric_value": "2025", "metric_name": "rollback-from", "data": { "event": "source=DATABASE addon=postgresql-perpendicular-15086 sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.10938 sample#max-iops=3000 sample#iops-percentage-used=0.00004 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54272kB sample#memory-percentage-used=0.98624 sample#memory-cached=3011980kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:25UTC", "source": "heroku.app", "sourcetype": "-", "hostname": "host", "agent_timestamp": "2025-03-15T18:23:46+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "heroku-postgres", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "host", "source": "app", "dyno": "heroku-postgres", "app": "pink-ducks-service-staging", "space": "appexchange-intelligence", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "runtime": { "rest": "sample#service-available=1 sample#current_transaction=2097 sample#db_size=9839395bytes sample#db-max-size=68719476736bytes sample#db-size-percentage-used=0.00014 sample#tables=2 sample#active-connections=12 sample#waiting-connections=0 sample#max-connections=200 sample#connections-percentage-used=0.06000 sample#index-cache-hit-rate=0.96984 sample#table-cache-hit-rate=0.98191 sample#load-avg-1m=0 sample#load-avg-5m=0 sample#load-avg-15m=0 sample#read-iops=0 sample#write-iops=0.10938 sample#max-iops=3000 sample#iops-percentage-used=0.00004 sample#tmp-disk-used=543600640 sample#tmp-disk-available=72435191808 sample#memory-total=3944460kB sample#memory-free=54272kB sample#memory-percentage-used=0.98624 sample#memory-cached=3011980kB sample#memory-postgres=9112kB sample#wal-percentage-used=0.06402321977269616 sample#rollback-from=2025-03-11T18:25UTC", "addon": "postgresql-perpendicular-15086", "source": "DATABASE" }, "type": "log", "inc": 0, "fields": { "f1": "source=DATABASE", "f2": "addon=postgresql-perpendicular-15086", "f3": "sample#service-available=1", "f4": "sample#current_transaction=2097", "f5": "sample#db_size=9839395bytes", "f6": "sample#db-max-size=68719476736bytes", "f7": "sample#db-size-percentage-used=0.00014", "f8": "sample#tables=2", "f9": "sample#active-connections=12", "f10": "sample#waiting-connections=0", "f11": "sample#max-connections=200", "f12": "sample#connections-percentage-used=0.06000", "f13": "sample#index-cache-hit-rate=0.96984", "f14": "sample#table-cache-hit-rate=0.98191", "f15": "sample#load-avg-1m=0", "f16": "sample#load-avg-5m=0", "f17": "sample#load-avg-15m=0", "f18": "sample#read-iops=0", "f19": "sample#write-iops=0.10938", "f20": "sample#max-iops=3000", "f21": "sample#iops-percentage-used=0.00004", "f22": "sample#tmp-disk-used=543600640", "f23": "sample#tmp-disk-available=72435191808", "f24": "sample#memory-total=3944460kB", "f25": "sample#memory-free=54272kB", "f26": "sample#memory-percentage-used=0.98624", "f27": "sample#memory-cached=3011980kB", "f28": "sample#memory-postgres=9112kB", "f29": "sample#wal-percentage-used=0.06402321977269616", "f30": "sample#rollback-from=2025-03-11T18:25UTC" }, "format": "text", "sample": "rollback-from=2025-03-11T18:25UTC", "sample_key": "rollback-from", "sample_value": "2025-03-11T18:25UTC", "value": "2025", "units": "", "dynadir": "debug" } $/: Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[heroku-postgres]', programname: 'app', APP-NAME: 'app', PROCID: 'heroku-postgres', MSGID: '-', TIMESTAMP: 'Mar 15 18:27:10', STRUCTURED-DATA: '-', msg: 'source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.005 sample#load-avg-15m=0.04 sample#read-iops=0 sample#write-iops=0.015873 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328632kB sample#memory-percentage-used=0.95904 sample#memory-cached=6525396kB sample#memory-postgres=110528kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:27UTC' escaped msg: 'source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.005 sample#load-avg-15m=0.04 sample#read-iops=0 sample#write-iops=0.015873 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328632kB sample#memory-percentage-used=0.95904 sample#memory-cached=6525396kB sample#memory-postgres=110528kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:27UTC' inputname: drain rawmsg: '<134>1 2025-03-15T18:27:10+00:00 host app heroku-postgres - source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.005 sample#load-avg-15m=0.04 sample#read-iops=0 sample#write-iops=0.015873 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328632kB sample#memory-percentage-used=0.95904 sample#memory-cached=6525396kB sample#memory-postgres=110528kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:27UTC' $!:{ "metadata": { "httpheaders": { "host": "appx-staging-drain-4bd9f585e48c.herokuapp.com", "user-agent": "logfwd", "content-length": "1014", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.2257363d-e289-4fca-980f-d26509782992", "logplex-frame-id": "530af31b-7555-4da4-9c5e-4a2084e0c6c4", "logplex-msg-count": "1", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "50.17.69.74", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "d50655ab-f41e-0109-db53-f11a41436588", "x-request-start": "1742063279315" }, "queryparams": { "app": "appx-oaf-staging", "space": "appexchange-primary", "service": "appexchange", "team": "sfdc-platform-ecosystem" } }, "metric_tags": { "addon": "postgresql-regular-58279", "attachment": "DATABASE", "source": "app", "dyno": "heroku-postgres", "device": "host", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b", "team": "sfdc-platform-ecosystem", "service": "appexchange", "datacenter": "ext", "superpod": "heroku", "pod": "appx-staging-drain" }, "metric_service": "heroku-postgres", "metric_timestamp": 1742063230, "metric_value": "2025", "metric_name": "rollback-from", "data": { "event": "source=DATABASE addon=postgresql-regular-58279 sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.005 sample#load-avg-15m=0.04 sample#read-iops=0 sample#write-iops=0.015873 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328632kB sample#memory-percentage-used=0.95904 sample#memory-cached=6525396kB sample#memory-postgres=110528kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:27UTC", "source": "heroku.app", "sourcetype": "-", "hostname": "host", "agent_timestamp": "2025-03-15T18:27:10+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "heroku-postgres", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "info", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } } } $.:{ "app_id": "host", "source": "app", "dyno": "heroku-postgres", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "team": "sfdc-platform-ecosystem", "service": "appexchange", "sourcetype": "-", "environment": "-", "cloud": "-", "business_unit": "Heroku", "runtime": { "rest": "sample#primary-available=1 sample#standby-available=1 sample#current_transaction=2983647 sample#db_size=1362776547bytes sample#db-max-size=274877906944bytes sample#db-size-percentage-used=0.00496 sample#tables=8 sample#active-connections=33 sample#waiting-connections=0 sample#max-connections=500 sample#connections-percentage-used=0.06600 sample#index-cache-hit-rate=0.99995 sample#table-cache-hit-rate=0.99998 sample#load-avg-1m=0 sample#load-avg-5m=0.005 sample#load-avg-15m=0.04 sample#read-iops=0 sample#write-iops=0.015873 sample#max-iops=3000 sample#iops-percentage-used=0.00001 sample#tmp-disk-used=543633408 sample#tmp-disk-available=72435159040 sample#memory-total=8024076kB sample#memory-free=328632kB sample#memory-percentage-used=0.95904 sample#memory-cached=6525396kB sample#memory-postgres=110528kB sample#wal-percentage-used=0.06427136779541504 sample#rollback-from=2025-03-08T18:27UTC", "addon": "postgresql-regular-58279", "source": "DATABASE" }, "type": "log", "inc": 0, "fields": { "f1": "source=DATABASE", "f2": "addon=postgresql-regular-58279", "f3": "sample#primary-available=1", "f4": "sample#standby-available=1", "f5": "sample#current_transaction=2983647", "f6": "sample#db_size=1362776547bytes", "f7": "sample#db-max-size=274877906944bytes", "f8": "sample#db-size-percentage-used=0.00496", "f9": "sample#tables=8", "f10": "sample#active-connections=33", "f11": "sample#waiting-connections=0", "f12": "sample#max-connections=500", "f13": "sample#connections-percentage-used=0.06600", "f14": "sample#index-cache-hit-rate=0.99995", "f15": "sample#table-cache-hit-rate=0.99998", "f16": "sample#load-avg-1m=0", "f17": "sample#load-avg-5m=0.005", "f18": "sample#load-avg-15m=0.04", "f19": "sample#read-iops=0", "f20": "sample#write-iops=0.015873", "f21": "sample#max-iops=3000", "f22": "sample#iops-percentage-used=0.00001", "f23": "sample#tmp-disk-used=543633408", "f24": "sample#tmp-disk-available=72435159040", "f25": "sample#memory-total=8024076kB", "f26": "sample#memory-free=328632kB", "f27": "sample#memory-percentage-used=0.95904", "f28": "sample#memory-cached=6525396kB", "f29": "sample#memory-postgres=110528kB", "f30": "sample#wal-percentage-used=0.06427136779541504", "f31": "sample#rollback-from=2025-03-08T18:27UTC" }, "format": "text", "sample": "rollback-from=2025-03-08T18:27UTC", "sample_key": "rollback-from", "sample_value": "2025-03-08T18:27UTC", "value": "2025", "units": "", "dynadir": "debug" } $/: