2026-07-16T00:36:26+00:00 host app[postgres.1724783] [36-1]  sql_error_code = 00000 time_ms = "2026-07-16 00:36:26.642 UTC" pid="1796281" proc_start_time="2026-07-16 00:25:01 UTC" session_id="6a5824dd.1b68b9" vtid="6/860305" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.169.34(48716)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 6031.971 ms  execute <unnamed>: select distinct on ("stream_id") "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" left join jsonb_array_elements(projections.projection->'plugins') plugins on true where "streams"."type" = $1 and "projections"."version" = $2 and CAST("projections"."projection"#>>'{org62AccountId}' AS text) not in ($3) and
2026-07-16T00:36:26+00:00 host app[postgres.1724783] [36-2]  CAST("projections"."projection"#>>'{extensions,0,data,extensions,0,data,solutionId}' AS text) in ($4) or CAST("plugins"#>>'{data,solutionId}' AS text) IN ('54788a63-bd67-42ae-af07-a78367fb85f5') limit $5
2026-07-16T00:36:26+00:00 host app[postgres.1724783] [36-3]  sql_error_code = 00000 time_ms = "2026-07-16 00:36:26.642 UTC" pid="1796281" proc_start_time="2026-07-16 00:25:01 UTC" session_id="6a5824dd.1b68b9" vtid="6/860305" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.169.34(48716)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '54788a63-bd67-42ae-af07-a78367fb85f5', $5 = '2000'
2026-07-16T03:00:08+00:00 host app[postgres.1724783] [37-1]  sql_error_code = 00000 time_ms = "2026-07-16 03:00:08.401 UTC" pid="1796281" proc_start_time="2026-07-16 00:25:01 UTC" session_id="6a5824dd.1b68b9" vtid="6/860358" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.169.34(48716)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3089.612 ms  execute <unnamed>: select "streams"."id", "streams"."external_id", "streams"."owner_id", "streams"."head_delta_id", "projections"."projection", "secReviewOpsProjection"."projection" as "securityReviewFeedback" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" left join "streams" as "securityReview" on "securityReview"."owner_id" = "streams"."id" left join "projections" as "securityReview:projections" on "securityReview:projections"."stream_id" = "securityReview"."id" left join "streams" as "secReviewOps" on
2026-07-16T03:00:08+00:00 host app[postgres.1724783] [37-2]  "secReviewOps"."owner_id" = "securityReview"."id" and "secReviewOps"."type" = 'security_review_ops' left join "projections" as "secReviewOpsProjection" on "secReviewOpsProjection"."stream_id" = "secReviewOps"."id" where "projections"."version" = $1 and CAST("streams"."id" AS text) = $2 and "streams"."type" = $3
2026-07-16T03:00:08+00:00 host app[postgres.1724783] [37-3]  sql_error_code = 00000 time_ms = "2026-07-16 03:00:08.401 UTC" pid="1796281" proc_start_time="2026-07-16 00:25:01 UTC" session_id="6a5824dd.1b68b9" vtid="6/860358" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.169.34(48716)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'oafv1', $2 = 'ba986dcb-9c2f-4169-a963-ea92e19efed1', $3 = 'solution'