2026-11-11T16:18:21+00:00 host app[postgres.2401821] [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" 2026-11-11T16:18:21+00:00 host app[postgres.2401821] [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' 2026-11-11T16:43:40+00:00 host app[postgres.2401821] [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" 2026-11-11T16:43:40+00:00 host app[postgres.2401821] [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' 2026-11-11T16:52:11+00:00 host app[postgres.2401821] [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" 2026-11-11T16:52:11+00:00 host app[postgres.2401821] [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' 2026-11-11T16:54:55+00:00 host app[postgres.2401821] [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" 2026-11-11T16:54:55+00:00 host app[postgres.2401821] [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' 2026-11-11T17:15:57+00:00 host app[postgres.2401821] [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 2026-11-11T17:15:57+00:00 host app[postgres.2401821] [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 2026-11-11T17:15:57+00:00 host app[postgres.2401821] [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) 2026-11-11T17:15:57+00:00 host app[postgres.2401821] [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 2026-11-11T17:26:21+00:00 host app[postgres.2401821] [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" 2026-11-11T17:26:21+00:00 host app[postgres.2401821] [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' 2026-11-11T17:29:38+00:00 host app[postgres.2401821] [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" 2026-11-11T17:29:38+00:00 host app[postgres.2401821] [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' 2026-11-11T17:30:29+00:00 host app[postgres.2401821] [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" 2026-11-11T17:30:29+00:00 host app[postgres.2401821] [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' 2026-11-11T17:39:11+00:00 host app[postgres.2401821] [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 2026-11-11T17:39:11+00:00 host app[postgres.2401821] [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' 2026-11-11T17:39:15+00:00 host app[postgres.2401821] [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" 2026-11-11T17:39:15+00:00 host app[postgres.2401821] [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' 2026-11-11T17:39:22+00:00 host app[postgres.2401821] [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" 2026-11-11T17:39:22+00:00 host app[postgres.2401821] [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' 2026-11-11T17:49:55+00:00 host app[postgres.2401821] [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" 2026-11-11T17:49:55+00:00 host app[postgres.2401821] [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'