{"schema_type":"json-schema","schema_id":"event-flatten:2","data":{ "event": "[97-1]  sql_error_code = 00000 time_ms = \"2026-11-12 00:02:48.351 UTC\" pid=\"1123828\" proc_start_time=\"2026-11-12 00:00:04 UTC\" session_id=\"6af50184.1125f4\" vtid=\"91\/68693\" tid=\"0\" log_line=\"6\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.166.195(40760)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG:  duration: 3208.448 ms  execute <unnamed>: 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-12T00:02:48+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2498309", "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-12 00:02:48.351 UTC\" pid=\"1123828\" proc_start_time=\"2026-11-12 00:00:04 UTC\" session_id=\"6af50184.1125f4\" vtid=\"91\/68693\" tid=\"0\" log_line=\"7\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.166.195(40760)\" 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-12T00:02:48+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2498309", "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": "[98-1]  sql_error_code = 00000 time_ms = \"2026-11-12 00:26:43.556 UTC\" pid=\"1123828\" proc_start_time=\"2026-11-12 00:00:04 UTC\" session_id=\"6af50184.1125f4\" vtid=\"91\/68700\" tid=\"0\" log_line=\"8\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.166.195(40760)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG:  duration: 2977.788 ms  execute <unnamed>: 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-12T00:26:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2498309", "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": "[98-2]  sql_error_code = 00000 time_ms = \"2026-11-12 00:26:43.556 UTC\" pid=\"1123828\" proc_start_time=\"2026-11-12 00:00:04 UTC\" session_id=\"6af50184.1125f4\" vtid=\"91\/68700\" tid=\"0\" log_line=\"9\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.166.195(40760)\" 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-12T00:26:43+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2498309", "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": "[100-1]  sql_error_code = 00000 time_ms = \"2026-11-12 00:30:04.453 UTC\" pid=\"1123828\" proc_start_time=\"2026-11-12 00:00:04 UTC\" session_id=\"6af50184.1125f4\" vtid=\"91\/68706\" tid=\"0\" log_line=\"12\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.166.195(40760)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" LOG:  duration: 4275.175 ms  execute <unnamed>: select \"streams\".\"id\", \"streams\".\"external_id\", \"streams\".\"owner_id\", \"streams\".\"head_delta_id\", \"projections\".\"stream_id\", \"permGroups\".\"id\" as \"permGroupId\" from \"streams\" inner join \"projections\" on \"projections\".\"stream_id\" = \"streams\".\"id\" left join \"permission_groups\" as \"permGroups\" on \"permGroups\".\"org62_account_id\" = \"projections\".projection->>'org62AccountId' where \"projections\".\"version\" = $1 and CAST(\"projections\".\"type\" AS text) in ($2, $3, $4, $5, $6, $7, $8) and \"projections\".projection->>'org62AccountId' in (Select", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-12T00:30:04+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2498309", "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": "[100-2]  org62_account_id from permission_groups) and \"projections\".stream_id not in (select stream_id from permission_group_streams)", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-12T00:30:04+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2498309", "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": "[100-3]  sql_error_code = 00000 time_ms = \"2026-11-12 00:30:04.453 UTC\" pid=\"1123828\" proc_start_time=\"2026-11-12 00:00:04 UTC\" session_id=\"6af50184.1125f4\" vtid=\"91\/68706\" tid=\"0\" log_line=\"13\" database=\"ddvvgu681gm35p\" connection_source=\"10.0.166.195(40760)\" user=\"uc0g389cnbt72e\" application_name=\"[unknown]\" DETAIL:  parameters: $1 = 'oafv1', $2 = 'listing', $3 = 'publisher', $4 = 'solution', $5 = 'publisher_force', $6 = 'pricing_plan', $7 = 'security_review', $8 = 'security_review_payment'", "source": "heroku.app", "sourcetype": "-", "hostname": "d.2257363d-e289-4fca-980f-d26509782992", "agent_timestamp": "2026-11-12T00:30:04+00:00", "tags_schema_id": "any6:1", "tags": { "dyno": "postgres.2498309", "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": "-" } }}