Debug line with all properties: FROMHOST: '', fromhost-ip: '172.17.128.1', HOSTNAME: 'host', PRI: 134, syslogtag 'app[postgres.1872822]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.1872822', MSGID: '-', TIMESTAMP: 'Mar 14 18:01:05', STRUCTURED-DATA: '[BLUE]', msg: '[12-1] sql_error_code = 00000 time_ms = "2025-03-14 18:01:05.084 UTC" pid="163371" proc_start_time="2025-03-14 17:49:25 UTC" session_id="67d46c25.27e2b" vtid="13/5287" tid="0" log_line="4" database="ddt38hapd0h2tv" connection_source="10.0.168.123(40042)" user="u4ke6fk0v8lafm" application_name="PostgreSQL JDBC Driver" LOG: duration: 23290.870 ms execute : select address0_.id as id1_0_, address0_.created_at as created_2_0_, address0_.created_by as created_3_0_, address0_.updated_at as updated_4_0_, address0_.updated_by as updated_5_0_, address0_.version as version6_0_, address0_.address as address7_0_, address0_.address_state as address_8_0_, address0_.address_type as address_9_0_, address0_.auth_details as auth_de10_0_, address0_.auth_expiry as auth_ex11_0_, address0_.channel as channel12_0_, address0_.channel_address_identifier as channel13_0_, address0_.compliance_strategy as' escaped msg: '[12-1] sql_error_code = 00000 time_ms = "2025-03-14 18:01:05.084 UTC" pid="163371" proc_start_time="2025-03-14 17:49:25 UTC" session_id="67d46c25.27e2b" vtid="13/5287" tid="0" log_line="4" database="ddt38hapd0h2tv" connection_source="10.0.168.123(40042)" user="u4ke6fk0v8lafm" application_name="PostgreSQL JDBC Driver" LOG: duration: 23290.870 ms execute : select address0_.id as id1_0_, address0_.created_at as created_2_0_, address0_.created_by as created_3_0_, address0_.updated_at as updated_4_0_, address0_.updated_by as updated_5_0_, address0_.version as version6_0_, address0_.address as address7_0_, address0_.address_state as address_8_0_, address0_.address_type as address_9_0_, address0_.auth_details as auth_de10_0_, address0_.auth_expiry as auth_ex11_0_, address0_.channel as channel12_0_, address0_.channel_address_identifier as channel13_0_, address0_.compliance_strategy as' inputname: drain rawmsg: '<134>1 2025-03-14T18:01:05+00:00 host app postgres.1872822 - [BLUE] [12-1] sql_error_code = 00000 time_ms = "2025-03-14 18:01:05.084 UTC" pid="163371" proc_start_time="2025-03-14 17:49:25 UTC" session_id="67d46c25.27e2b" vtid="13/5287" tid="0" log_line="4" database="ddt38hapd0h2tv" connection_source="10.0.168.123(40042)" user="u4ke6fk0v8lafm" application_name="PostgreSQL JDBC Driver" LOG: duration: 23290.870 ms execute : select address0_.id as id1_0_, address0_.created_at as created_2_0_, address0_.created_by as created_3_0_, address0_.updated_at as updated_4_0_, address0_.updated_by as updated_5_0_, address0_.version as version6_0_, address0_.address as address7_0_, address0_.address_state as address_8_0_, address0_.address_type as address_9_0_, address0_.auth_details as auth_de10_0_, address0_.auth_expiry as auth_ex11_0_, address0_.channel as channel12_0_, address0_.channel_address_identifier as channel13_0_, address0_.compliance_strategy as' $!:{ "metadata": { "httpheaders": { "host": "sfdc-lm-perf-vir-00-sh-drain.herokuapp.com", "user-agent": "logfwd", "content-length": "2123", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.7d4a129e-382b-42ce-9d6f-205952f666a8", "logplex-frame-id": "9212f5c2-0140-4f09-9d78-c8ed8c6da680", "logplex-msg-count": "3", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "18.213.79.169", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7a682232-24e1-3f49-d31f-b64c2fb22580", "x-request-start": "1741975265956" }, "queryparams": { "app": "sfdc-lm-perf-vir-00-sh-admin", "space": "sfdc-lm-perf-vir", "region": "virginia", "service": "lmp", "team": "lmp", "sourcetype": "lmp" } }, "data": { "event": "[12-1] sql_error_code = 00000 time_ms = \"2025-03-14 18:01:05.084 UTC\" pid=\"163371\" proc_start_time=\"2025-03-14 17:49:25 UTC\" session_id=\"67d46c25.27e2b\" vtid=\"13\/5287\" tid=\"0\" log_line=\"4\" database=\"ddt38hapd0h2tv\" connection_source=\"10.0.168.123(40042)\" user=\"u4ke6fk0v8lafm\" application_name=\"PostgreSQL JDBC Driver\" LOG: duration: 23290.870 ms execute : select address0_.id as id1_0_, address0_.created_at as created_2_0_, address0_.created_by as created_3_0_, address0_.updated_at as updated_4_0_, address0_.updated_by as updated_5_0_, address0_.version as version6_0_, address0_.address as address7_0_, address0_.address_state as address_8_0_, address0_.address_type as address_9_0_, address0_.auth_details as auth_de10_0_, address0_.auth_expiry as auth_ex11_0_, address0_.channel as channel12_0_, address0_.channel_address_identifier as channel13_0_, address0_.compliance_strategy as", "source": "heroku.app", "sourcetype": "lmp", "hostname": "d.7d4a129e-382b-42ce-9d6f-205952f666a8", "agent_timestamp": "2025-03-14T18:01:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.1872822", "app": "sfdc-lm-perf-vir-00-sh-admin", "space": "sfdc-lm-perf-vir", "region": "virginia", "severity": "info", "uuid": "26a6d0b6-b574-4e3b-9414-640cdb4ae358" }, "owner": { "service": "lmp", "team": "lmp", "environment": "performance", "cloud": "digitalengagement" } } } $.:{ "app_id": "d.7d4a129e-382b-42ce-9d6f-205952f666a8", "source": "app", "dyno": "postgres.1872822", "app": "sfdc-lm-perf-vir-00-sh-admin", "space": "sfdc-lm-perf-vir", "region": "virginia", "team": "lmp", "service": "lmp", "sourcetype": "lmp", "environment": "performance", "cloud": "digitalengagement", "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: 'host', PRI: 134, syslogtag 'app[postgres.1872822]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.1872822', MSGID: '-', TIMESTAMP: 'Mar 14 18:01:05', STRUCTURED-DATA: '[BLUE]', msg: '[12-2] complia14_0_, address0_.credential as credent15_0_, address0_.customer_id as custome28_0_, address0_.dns_destination as dns_des16_0_, address0_.dns_name as dns_nam17_0_, address0_.espid_id as espid_i18_0_, address0_.expires_at as expires19_0_, address0_.external_account_identifier as externa20_0_, address0_.iso_country_code as iso_cou21_0_, address0_.name as name22_0_, address0_.opt_in as opt_in23_0_, address0_.opt_out as opt_out24_0_, address0_.channel_registry_id as channel29_0_, address0_.scrt2 as scrt25_0_, address0_.ucp as ucp26_0_, address0_.use_mock_api as use_moc27_0_ from addresses address0_ where address0_.channel in ($1)' escaped msg: '[12-2] complia14_0_, address0_.credential as credent15_0_, address0_.customer_id as custome28_0_, address0_.dns_destination as dns_des16_0_, address0_.dns_name as dns_nam17_0_, address0_.espid_id as espid_i18_0_, address0_.expires_at as expires19_0_, address0_.external_account_identifier as externa20_0_, address0_.iso_country_code as iso_cou21_0_, address0_.name as name22_0_, address0_.opt_in as opt_in23_0_, address0_.opt_out as opt_out24_0_, address0_.channel_registry_id as channel29_0_, address0_.scrt2 as scrt25_0_, address0_.ucp as ucp26_0_, address0_.use_mock_api as use_moc27_0_ from addresses address0_ where address0_.channel in ($1)' inputname: drain rawmsg: '<134>1 2025-03-14T18:01:05+00:00 host app postgres.1872822 - [BLUE] [12-2] complia14_0_, address0_.credential as credent15_0_, address0_.customer_id as custome28_0_, address0_.dns_destination as dns_des16_0_, address0_.dns_name as dns_nam17_0_, address0_.espid_id as espid_i18_0_, address0_.expires_at as expires19_0_, address0_.external_account_identifier as externa20_0_, address0_.iso_country_code as iso_cou21_0_, address0_.name as name22_0_, address0_.opt_in as opt_in23_0_, address0_.opt_out as opt_out24_0_, address0_.channel_registry_id as channel29_0_, address0_.scrt2 as scrt25_0_, address0_.ucp as ucp26_0_, address0_.use_mock_api as use_moc27_0_ from addresses address0_ where address0_.channel in ($1)' $!:{ "metadata": { "httpheaders": { "host": "sfdc-lm-perf-vir-00-sh-drain.herokuapp.com", "user-agent": "logfwd", "content-length": "2123", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.7d4a129e-382b-42ce-9d6f-205952f666a8", "logplex-frame-id": "9212f5c2-0140-4f09-9d78-c8ed8c6da680", "logplex-msg-count": "3", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "18.213.79.169", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7a682232-24e1-3f49-d31f-b64c2fb22580", "x-request-start": "1741975265956" }, "queryparams": { "app": "sfdc-lm-perf-vir-00-sh-admin", "space": "sfdc-lm-perf-vir", "region": "virginia", "service": "lmp", "team": "lmp", "sourcetype": "lmp" } }, "data": { "event": "[12-2] complia14_0_, address0_.credential as credent15_0_, address0_.customer_id as custome28_0_, address0_.dns_destination as dns_des16_0_, address0_.dns_name as dns_nam17_0_, address0_.espid_id as espid_i18_0_, address0_.expires_at as expires19_0_, address0_.external_account_identifier as externa20_0_, address0_.iso_country_code as iso_cou21_0_, address0_.name as name22_0_, address0_.opt_in as opt_in23_0_, address0_.opt_out as opt_out24_0_, address0_.channel_registry_id as channel29_0_, address0_.scrt2 as scrt25_0_, address0_.ucp as ucp26_0_, address0_.use_mock_api as use_moc27_0_ from addresses address0_ where address0_.channel in ($1)", "source": "heroku.app", "sourcetype": "lmp", "hostname": "d.7d4a129e-382b-42ce-9d6f-205952f666a8", "agent_timestamp": "2025-03-14T18:01:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.1872822", "app": "sfdc-lm-perf-vir-00-sh-admin", "space": "sfdc-lm-perf-vir", "region": "virginia", "severity": "info", "uuid": "26a6d0b6-b574-4e3b-9414-640cdb4ae358" }, "owner": { "service": "lmp", "team": "lmp", "environment": "performance", "cloud": "digitalengagement" } } } $.:{ "app_id": "d.7d4a129e-382b-42ce-9d6f-205952f666a8", "source": "app", "dyno": "postgres.1872822", "app": "sfdc-lm-perf-vir-00-sh-admin", "space": "sfdc-lm-perf-vir", "region": "virginia", "team": "lmp", "service": "lmp", "sourcetype": "lmp", "environment": "performance", "cloud": "digitalengagement", "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: 'host', PRI: 134, syslogtag 'app[postgres.1872822]', programname: 'app', APP-NAME: 'app', PROCID: 'postgres.1872822', MSGID: '-', TIMESTAMP: 'Mar 14 18:01:05', STRUCTURED-DATA: '[BLUE]', msg: '[12-3] sql_error_code = 00000 time_ms = "2025-03-14 18:01:05.084 UTC" pid="163371" proc_start_time="2025-03-14 17:49:25 UTC" session_id="67d46c25.27e2b" vtid="13/5287" tid="0" log_line="5" database="ddt38hapd0h2tv" connection_source="10.0.168.123(40042)" user="u4ke6fk0v8lafm" application_name="PostgreSQL JDBC Driver" DETAIL: parameters: $1 = 'WHATSAPP'' escaped msg: '[12-3] sql_error_code = 00000 time_ms = "2025-03-14 18:01:05.084 UTC" pid="163371" proc_start_time="2025-03-14 17:49:25 UTC" session_id="67d46c25.27e2b" vtid="13/5287" tid="0" log_line="5" database="ddt38hapd0h2tv" connection_source="10.0.168.123(40042)" user="u4ke6fk0v8lafm" application_name="PostgreSQL JDBC Driver" DETAIL: parameters: $1 = 'WHATSAPP'' inputname: drain rawmsg: '<134>1 2025-03-14T18:01:05+00:00 host app postgres.1872822 - [BLUE] [12-3] sql_error_code = 00000 time_ms = "2025-03-14 18:01:05.084 UTC" pid="163371" proc_start_time="2025-03-14 17:49:25 UTC" session_id="67d46c25.27e2b" vtid="13/5287" tid="0" log_line="5" database="ddt38hapd0h2tv" connection_source="10.0.168.123(40042)" user="u4ke6fk0v8lafm" application_name="PostgreSQL JDBC Driver" DETAIL: parameters: $1 = 'WHATSAPP'' $!:{ "metadata": { "httpheaders": { "host": "sfdc-lm-perf-vir-00-sh-drain.herokuapp.com", "user-agent": "logfwd", "content-length": "2123", "accept-encoding": "gzip", "content-type": "application\/logplex-1", "logplex-drain-token": "d.7d4a129e-382b-42ce-9d6f-205952f666a8", "logplex-frame-id": "9212f5c2-0140-4f09-9d78-c8ed8c6da680", "logplex-msg-count": "3", "server": "Heroku", "via": "1.1 spaces-router (bc46c658aac4)", "x-forwarded-for": "18.213.79.169", "x-forwarded-port": "443", "x-forwarded-proto": "https", "x-request-id": "7a682232-24e1-3f49-d31f-b64c2fb22580", "x-request-start": "1741975265956" }, "queryparams": { "app": "sfdc-lm-perf-vir-00-sh-admin", "space": "sfdc-lm-perf-vir", "region": "virginia", "service": "lmp", "team": "lmp", "sourcetype": "lmp" } }, "data": { "event": "[12-3] sql_error_code = 00000 time_ms = \"2025-03-14 18:01:05.084 UTC\" pid=\"163371\" proc_start_time=\"2025-03-14 17:49:25 UTC\" session_id=\"67d46c25.27e2b\" vtid=\"13\/5287\" tid=\"0\" log_line=\"5\" database=\"ddt38hapd0h2tv\" connection_source=\"10.0.168.123(40042)\" user=\"u4ke6fk0v8lafm\" application_name=\"PostgreSQL JDBC Driver\" DETAIL: parameters: $1 = 'WHATSAPP'", "source": "heroku.app", "sourcetype": "lmp", "hostname": "d.7d4a129e-382b-42ce-9d6f-205952f666a8", "agent_timestamp": "2025-03-14T18:01:05+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.1872822", "app": "sfdc-lm-perf-vir-00-sh-admin", "space": "sfdc-lm-perf-vir", "region": "virginia", "severity": "info", "uuid": "26a6d0b6-b574-4e3b-9414-640cdb4ae358" }, "owner": { "service": "lmp", "team": "lmp", "environment": "performance", "cloud": "digitalengagement" } } } $.:{ "app_id": "d.7d4a129e-382b-42ce-9d6f-205952f666a8", "source": "app", "dyno": "postgres.1872822", "app": "sfdc-lm-perf-vir-00-sh-admin", "space": "sfdc-lm-perf-vir", "region": "virginia", "team": "lmp", "service": "lmp", "sourcetype": "lmp", "environment": "performance", "cloud": "digitalengagement", "business_unit": "Heroku", "type": "log", "inc": 0, "format": "text", "dnr": "false", "dynadir": "debug" } $/: