{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[88-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:18:21.402 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318241\" tid=\"0\" log_line=\"8\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3282.407 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:18:21+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[88-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:18:21.402 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318241\" tid=\"0\" log_line=\"9\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:18:21+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[94-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:43:40.644 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318275\" tid=\"0\" log_line=\"20\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3268.016 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:43:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[94-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:43:40.644 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318275\" tid=\"0\" log_line=\"21\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:43:40+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[95-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:52:11.612 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318288\" tid=\"0\" log_line=\"22\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3104.267 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:52:11+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[95-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:52:11.612 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318288\" tid=\"0\" log_line=\"23\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:52:11+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[97-1] sql_error_code = 00000 time_ms = \"2026-11-11 16:54:55.180 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318314\" tid=\"0\" log_line=\"26\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3329.560 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:54:55+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[97-2] sql_error_code = 00000 time_ms = \"2026-11-11 16:54:55.180 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318314\" tid=\"0\" log_line=\"27\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T16:54:55+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[103-1] sql_error_code = 57014 time_ms = \"2026-11-11 17:15:57.034 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318389\" tid=\"0\" log_line=\"38\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" ERROR: canceling statement due to statement timeout", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:15:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "warning", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[103-2] sql_error_code = 57014 time_ms = \"2026-11-11 17:15:57.034 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318389\" tid=\"0\" log_line=\"39\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" STATEMENT: select distinct \"streams\".\"id\", \"streams\".\"external_id\", \"streams\".\"type\", \"permissionGroups\".\"global_perms\", \"projections\".\"projection\", \"streams\".\"id\", \"children:projections\".\"projection\" as \"securityReview\", \"children:children:projections\".\"projection\" as \"securityReviewFeedback\" from \"streams\" inner join \"permission_group_streams\" as \"permissionGroups_join\" on \"permissionGroups_join\".\"stream_id\" = \"streams\".\"id\" inner join \"permission_groups\" as \"permissionGroups\" on \"permissionGroups_join\".\"permission_group_id\" = \"permissionGroups\".\"id\" inner join \"projections\" on", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:15:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "warning", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[103-3] \"projections\".\"stream_id\" = \"streams\".\"id\" left join \"streams\" as \"children\" on \"children\".\"owner_id\" = \"streams\".\"id\" left join \"projections\" as \"children:projections\" on \"children:projections\".\"stream_id\" = \"children\".\"id\" left join \"streams\" as \"children:children\" on \"children:children\".\"owner_id\" = \"children\".\"id\" left join \"projections\" as \"children:children:projections\" on \"children:children:projections\".\"stream_id\" = \"children:children\".\"id\" where \"permissionGroups\".\"org62_account_id\" = $1 and \"permissionGroups\".\"perm_group_id\" in ($2) and \"projections\".\"version\" = $3 and CAST(\"projections\".\"projection\"#>>'{technology}' AS text) in ($4, $5, $6, $7, $8, $9, $10, $11, $12) and \"streams\".\"type\" = $13 and (CAST(\"projections\".\"projection\"#>>'{solution,version,packageVersionId}' AS text) in ($14, $15) or CAST(\"projections\".\"projection\"#>>'{solution,version,packageVersionId}' AS text)", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:15:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "warning", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[103-4] is null) and CAST(\"projections\".\"projection\"#>>'{technology}' AS text) in ($16) and CAST(\"projections\".\"projection\"#>>'{solution,name}' AS text) ilike $17 or CAST(\"projections\".\"projection\"#>>'{solution,packageId}' AS text) ilike $18 or CAST(\"projections\".\"projection\"#>>'{solution,version,packageVersionId}' AS text) ilike $19 or CAST(\"projections\".\"projection\"#>>'{solution,version,versionName}' AS text) ilike $20 or (projections.projection->'solution'->'version'->>'majorVersion') || '.' || (projections.projection->'solution'->'version'->>'minorVersion') || '.' || (projections.projection->'solution'->'version'->>'patchVersion') LIKE $21", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:15:57+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "app": "appx-oaf-staging", "space": "appexchange-primary", "region": "-", "severity": "warning", "uuid": "d2b5b31d-2db1-4389-940d-0e73e0f64b0b" }, "owner": { "service": "appexchange", "team": "sfdc-platform-ecosystem", "environment": "-", "cloud": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[104-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:26:21.758 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318406\" tid=\"0\" log_line=\"40\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3086.908 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:26:21+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[104-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:26:21.758 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318406\" tid=\"0\" log_line=\"41\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:26:21+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[105-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:29:38.571 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318410\" tid=\"0\" log_line=\"42\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3049.821 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:29:38+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[105-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:29:38.571 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318410\" tid=\"0\" log_line=\"43\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:29:38+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[106-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:30:29.699 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318413\" tid=\"0\" log_line=\"44\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 4828.369 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:30:29+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[106-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:30:29.699 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318413\" tid=\"0\" log_line=\"45\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:30:29+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[108-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:39:11.948 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318422\" tid=\"0\" log_line=\"48\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 2193.724 ms execute : select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4 limit $5 offset $6", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:39:11+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[108-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:39:11.948 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318422\" tid=\"0\" log_line=\"49\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00', $5 = '2000', $6 = '36000'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:39:11+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[109-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:39:15.031 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318423\" tid=\"0\" log_line=\"50\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3075.292 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:39:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[109-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:39:15.031 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318423\" tid=\"0\" log_line=\"51\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:39:15+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[110-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:39:22.285 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318426\" tid=\"0\" log_line=\"52\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3019.608 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:39:22+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[110-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:39:22.285 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318426\" tid=\"0\" log_line=\"53\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:39:22+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[113-1] sql_error_code = 00000 time_ms = \"2026-11-11 17:49:55.361 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318440\" tid=\"0\" log_line=\"58\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG: duration: 3053.129 ms execute : select count(*) as \"count\" from (select \"streams\".\"external_id\", \"streams\".\"id\", \"streams\".\"owner_id\", \"streams\".\"updated_at\", \"streams\".\"type\", \"projections\".\"projection\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" where \"streams\".\"type\" = $1 and \"projections\".\"version\" = $2 and CAST(\"projections\".\"projection\"#>>'{org62AccountId}' AS text) not in ($3) and \"streams\".\"updated_at\" >= $4) as \"temp\"", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:49:55+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }} {"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[113-2] sql_error_code = 00000 time_ms = \"2026-11-11 17:49:55.361 UTC\" pid=\"1113560\" proc_start_time=\"2026-11-11 15:38:42 UTC\" session_id=\"6af48c02.10fdd8\" vtid=\"26\/318440\" tid=\"0\" log_line=\"59\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.151.136(53412)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL: parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-11T17:49:55+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2401821", "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": "-" } }}