2026-11-11T18:26:55+00:00 host app[postgres.2433493] [96-1]  sql_error_code = 00000 time_ms = "2026-11-11 18:26:55.879 UTC" pid="1117103" proc_start_time="2026-11-11 18:20:21 UTC" session_id="6af4b1e5.110baf" vtid="13/500406" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.172.89(55504)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3160.129 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-11T18:26:55+00:00 host app[postgres.2433493] [96-2]  sql_error_code = 00000 time_ms = "2026-11-11 18:26:55.879 UTC" pid="1117103" proc_start_time="2026-11-11 18:20:21 UTC" session_id="6af4b1e5.110baf" vtid="13/500406" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.172.89(55504)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'
2026-11-11T18:27:04+00:00 host app[postgres.2433493] [97-1]  sql_error_code = 00000 time_ms = "2026-11-11 18:27:04.587 UTC" pid="1117103" proc_start_time="2026-11-11 18:20:21 UTC" session_id="6af4b1e5.110baf" vtid="13/500410" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.172.89(55504)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3022.827 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-11T18:27:04+00:00 host app[postgres.2433493] [97-2]  sql_error_code = 00000 time_ms = "2026-11-11 18:27:04.587 UTC" pid="1117103" proc_start_time="2026-11-11 18:20:21 UTC" session_id="6af4b1e5.110baf" vtid="13/500410" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.172.89(55504)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'
2026-11-11T18:30:09+00:00 host app[postgres.2433493] [99-1]  sql_error_code = 00000 time_ms = "2026-11-11 18:30:09.071 UTC" pid="1117103" proc_start_time="2026-11-11 18:20:21 UTC" session_id="6af4b1e5.110baf" vtid="13/500415" tid="0" log_line="10" database="ddvvgu681gm35p" connection_source="10.0.172.89(55504)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 2595.621 ms  execute <unnamed>: select "streams"."id", "streams"."external_id", "streams"."type", "streams"."projection_retries" from "streams" left outer join "projections" on "projections"."stream_id" = "streams"."id" where "streams"."updated_at" < $1 and "projections"."id" is null and "streams"."projection_retries" <= $2
2026-11-11T18:30:09+00:00 host app[postgres.2433493] [99-2]  sql_error_code = 00000 time_ms = "2026-11-11 18:30:09.071 UTC" pid="1117103" proc_start_time="2026-11-11 18:20:21 UTC" session_id="6af4b1e5.110baf" vtid="13/500415" tid="0" log_line="11" database="ddvvgu681gm35p" connection_source="10.0.172.89(55504)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = '2026-11-11 18:25:00.049+00', $2 = '3'