2026-11-12T00:26:02+00:00 host app[postgres.2498276] [97-1]  sql_error_code = 00000 time_ms = "2026-11-12 00:26:02.103 UTC" pid="1123795" proc_start_time="2026-11-12 00:00:03 UTC" session_id="6af50183.1125d3" vtid="19/422285" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.166.195(40322)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3062.331 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-12T00:26:02+00:00 host app[postgres.2498276] [97-2]  sql_error_code = 00000 time_ms = "2026-11-12 00:26:02.103 UTC" pid="1123795" proc_start_time="2026-11-12 00:00:03 UTC" session_id="6af50183.1125d3" vtid="19/422285" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.166.195(40322)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'
2026-11-12T00:27:26+00:00 host app[postgres.2498276] [99-1]  sql_error_code = 00000 time_ms = "2026-11-12 00:27:26.287 UTC" pid="1123795" proc_start_time="2026-11-12 00:00:03 UTC" session_id="6af50183.1125d3" vtid="19/422291" tid="0" log_line="10" database="ddvvgu681gm35p" connection_source="10.0.166.195(40322)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 2959.444 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-12T00:27:26+00:00 host app[postgres.2498276] [99-2]  sql_error_code = 00000 time_ms = "2026-11-12 00:27:26.287 UTC" pid="1123795" proc_start_time="2026-11-12 00:00:03 UTC" session_id="6af50183.1125d3" vtid="19/422291" tid="0" log_line="11" database="ddvvgu681gm35p" connection_source="10.0.166.195(40322)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'