2026-07-15T22:00:22+00:00 host app[postgres.1695378] [22-1]  sql_error_code = 00000 time_ms = "2026-07-15 22:00:22.182 UTC" pid="1793125" proc_start_time="2026-07-15 22:00:02 UTC" session_id="6a5802e2.1b5c65" vtid="3/1358265" tid="0" log_line="1" LOG:  temporary file: path "pg_tblspc/16386/PG_16_202307071/pgsql_tmp/pgsql_tmp1793125.0", size 28680192
2026-07-15T22:00:22+00:00 host app[postgres.1695378] [22-2]  sql_error_code = 00000 time_ms = "2026-07-15 22:00:22.182 UTC" pid="1793125" proc_start_time="2026-07-15 22:00:02 UTC" session_id="6a5802e2.1b5c65" vtid="3/1358265" tid="0" log_line="2" 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 "projections"."stream_id" = "streams"."id" left join "streams" as "children" on "children"."owner_id" = "streams"."id" left
2026-07-15T22:00:22+00:00 host app[postgres.1695378] [22-3]  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, $16, $17, $18, $19, $20, $21, $22, $23, $24, $25, $26, $27, $28, $29, $30, $31, $32, $33, $34, $35) or CAST("projections"."projection"#>>'{solution,version,packageVersionId}' AS text) is null) and
2026-07-15T22:00:22+00:00 host app[postgres.1695378] [22-4]  CAST("projections"."projection"#>>'{technology}' AS text) in ($36) and CAST("projections"."projection"#>>'{solution,name}' AS text) ilike $37 or CAST("projections"."projection"#>>'{solution,packageId}' AS text) ilike $38 or CAST("projections"."projection"#>>'{solution,version,packageVersionId}' AS text) ilike $39 or CAST("projections"."projection"#>>'{solution,version,versionName}' AS text) ilike $40 or (projections.projection->'solution'->'version'->>'majorVersion') || '.' || (projections.projection->'solution'->'version'->>'minorVersion') || '.' || (projections.projection->'solution'->'version'->>'patchVersion') LIKE $41