2026-11-11T20:59:30+00:00 host app[postgres.2462201] [98-1]  sql_error_code = 00000 time_ms = "2026-11-11 20:59:30.852 UTC" pid="1119937" proc_start_time="2026-11-11 20:50:00 UTC" session_id="6af4d4f8.1116c1" vtid="3/1864035" tid="0" log_line="8" database="ddvvgu681gm35p" connection_source="10.0.169.138(38720)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3218.999 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"
2026-11-11T20:59:30+00:00 host app[postgres.2462201] [98-2]  sql_error_code = 00000 time_ms = "2026-11-11 20:59:30.852 UTC" pid="1119937" proc_start_time="2026-11-11 20:50:00 UTC" session_id="6af4d4f8.1116c1" vtid="3/1864035" tid="0" log_line="9" database="ddvvgu681gm35p" connection_source="10.0.169.138(38720)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'
2026-11-11T21:00:09+00:00 host app[postgres.2462201] [99-1]  sql_error_code = 00000 time_ms = "2026-11-11 21:00:09.346 UTC" pid="1119937" proc_start_time="2026-11-11 20:50:00 UTC" session_id="6af4d4f8.1116c1" vtid="3/1864047" tid="0" log_line="10" database="ddvvgu681gm35p" connection_source="10.0.169.138(38720)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 2661.623 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-11-11T21:00:09+00:00 host app[postgres.2462201] [99-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-11-11T21:00:09+00:00 host app[postgres.2462201] [99-3]  sql_error_code = 00000 time_ms = "2026-11-11 21:00:09.346 UTC" pid="1119937" proc_start_time="2026-11-11 20:50:00 UTC" session_id="6af4d4f8.1116c1" vtid="3/1864047" tid="0" log_line="11" database="ddvvgu681gm35p" connection_source="10.0.169.138(38720)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'oafv1', $2 = '1659ca7c-beeb-4dd1-8afb-7981be18a9f3', $3 = 'solution'