2026-11-11T17:24:57+00:00 host app[postgres.2422109] [96-1]  sql_error_code = 00000 time_ms = "2026-11-11 17:24:57.514 UTC" pid="1115911" proc_start_time="2026-11-11 17:22:15 UTC" session_id="6af4a447.110707" vtid="18/471574" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.172.89(55340)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 19919.274 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-11-11T17:24:57+00:00 host app[postgres.2422109] [96-2]  (CAST("projections"."projection"#>>'{extensions,0,data,extensions,0,data,solutionId}' AS text) in ($4, $5, $6) or CAST("plugins"#>>'{data,solutionId}' AS text) IN ($7,$8,$9)) limit $10
2026-11-11T17:24:57+00:00 host app[postgres.2422109] [96-3]  sql_error_code = 00000 time_ms = "2026-11-11 17:24:57.514 UTC" pid="1115911" proc_start_time="2026-11-11 17:22:15 UTC" session_id="6af4a447.110707" vtid="18/471574" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.172.89(55340)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '1de6d448-34fc-4023-9f96-5a26e861ab51', $5 = 'c86eb472-2813-4abf-9903-dcf4ee97b4df', $6 = 'f44dc63e-d865-491d-b570-5c3744f1bc26', $7 = '1de6d448-34fc-4023-9f96-5a26e861ab51', $8 = 'c86eb472-2813-4abf-9903-dcf4ee97b4df', $9 = 'f44dc63e-d865-491d-b570-5c3744f1bc26', $10 = '2000'
2026-11-11T17:34:05+00:00 host app[postgres.2422109] [97-1]  sql_error_code = 00000 time_ms = "2026-11-11 17:34:05.767 UTC" pid="1115911" proc_start_time="2026-11-11 17:22:15 UTC" session_id="6af4a447.110707" vtid="18/471586" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.172.89(55340)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3164.426 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-11T17:34:05+00:00 host app[postgres.2422109] [97-2]  sql_error_code = 00000 time_ms = "2026-11-11 17:34:05.767 UTC" pid="1115911" proc_start_time="2026-11-11 17:22:15 UTC" session_id="6af4a447.110707" vtid="18/471586" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.172.89(55340)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '1999-01-01 01:00:01+00'