2026-11-11T23:38:50+00:00 host app[postgres.2493917] [97-1]  sql_error_code = 00000 time_ms = "2026-11-11 23:38:50.834 UTC" pid="1123298" proc_start_time="2026-11-11 23:36:00 UTC" session_id="6af4fbe0.1123e2" vtid="12/498451" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.158.208(39246)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3289.095 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-11T23:38:50+00:00 host app[postgres.2493917] [97-2]  sql_error_code = 00000 time_ms = "2026-11-11 23:38:50.834 UTC" pid="1123298" proc_start_time="2026-11-11 23:36:00 UTC" session_id="6af4fbe0.1123e2" vtid="12/498451" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.158.208(39246)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'
2026-11-11T23:38:56+00:00 host app[postgres.2493917] [98-1]  sql_error_code = 00000 time_ms = "2026-11-11 23:38:56.155 UTC" pid="1123298" proc_start_time="2026-11-11 23:36:00 UTC" session_id="6af4fbe0.1123e2" vtid="12/498454" tid="0" log_line="8" database="ddvvgu681gm35p" connection_source="10.0.158.208(39246)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3690.740 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-11T23:38:56+00:00 host app[postgres.2493917] [98-2]  sql_error_code = 00000 time_ms = "2026-11-11 23:38:56.155 UTC" pid="1123298" proc_start_time="2026-11-11 23:36:00 UTC" session_id="6af4fbe0.1123e2" vtid="12/498454" tid="0" log_line="9" database="ddvvgu681gm35p" connection_source="10.0.158.208(39246)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'
2026-11-11T23:50:24+00:00 host app[postgres.2493917] [103-1]  sql_error_code = 00000 time_ms = "2026-11-11 23:50:24.430 UTC" pid="1123298" proc_start_time="2026-11-11 23:36:00 UTC" session_id="6af4fbe0.1123e2" vtid="12/498473" tid="0" log_line="18" database="ddvvgu681gm35p" connection_source="10.0.158.208(39246)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3087.173 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-11T23:50:24+00:00 host app[postgres.2493917] [103-2]  sql_error_code = 00000 time_ms = "2026-11-11 23:50:24.430 UTC" pid="1123298" proc_start_time="2026-11-11 23:36:00 UTC" session_id="6af4fbe0.1123e2" vtid="12/498473" tid="0" log_line="19" database="ddvvgu681gm35p" connection_source="10.0.158.208(39246)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'
2026-11-11T23:51:38+00:00 host app[postgres.2493917] [104-1]  sql_error_code = 00000 time_ms = "2026-11-11 23:51:38.270 UTC" pid="1123298" proc_start_time="2026-11-11 23:36:00 UTC" session_id="6af4fbe0.1123e2" vtid="12/498476" tid="0" log_line="20" database="ddvvgu681gm35p" connection_source="10.0.158.208(39246)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3151.745 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-11T23:51:38+00:00 host app[postgres.2493917] [104-2]  sql_error_code = 00000 time_ms = "2026-11-11 23:51:38.270 UTC" pid="1123298" proc_start_time="2026-11-11 23:36:00 UTC" session_id="6af4fbe0.1123e2" vtid="12/498476" tid="0" log_line="21" database="ddvvgu681gm35p" connection_source="10.0.158.208(39246)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'
2026-11-11T23:55:09+00:00 host app[postgres.2493917] [108-1]  sql_error_code = 00000 time_ms = "2026-11-11 23:55:09.434 UTC" pid="1123298" proc_start_time="2026-11-11 23:36:00 UTC" session_id="6af4fbe0.1123e2" vtid="12/498486" tid="0" log_line="28" database="ddvvgu681gm35p" connection_source="10.0.158.208(39246)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3005.183 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-11T23:55:09+00:00 host app[postgres.2493917] [108-2]  sql_error_code = 00000 time_ms = "2026-11-11 23:55:09.434 UTC" pid="1123298" proc_start_time="2026-11-11 23:36:00 UTC" session_id="6af4fbe0.1123e2" vtid="12/498486" tid="0" log_line="29" database="ddvvgu681gm35p" connection_source="10.0.158.208(39246)" 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:00:09+00:00 host app[postgres.2493917] [109-1]  sql_error_code = 00000 time_ms = "2026-11-12 00:00:09.468 UTC" pid="1123298" proc_start_time="2026-11-11 23:36:00 UTC" session_id="6af4fbe0.1123e2" vtid="12/498490" tid="0" log_line="30" database="ddvvgu681gm35p" connection_source="10.0.158.208(39246)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 9409.674 ms  execute <unnamed>: select "streams"."id", "streams"."external_id", "streams"."owner_id", "streams"."head_delta_id", "projections"."stream_id", "permGroups"."id" as "permGroupId" from "streams" inner join "projections" on "projections"."stream_id" = "streams"."id" left join "permission_groups" as "permGroups" on "permGroups"."org62_account_id" = "projections".projection->>'org62AccountId' where "projections"."version" = $1 and CAST("projections"."type" AS text) in ($2, $3, $4, $5, $6, $7, $8) and "projections".projection->>'org62AccountId' in (Select
2026-11-12T00:00:09+00:00 host app[postgres.2493917] [109-2]  org62_account_id from permission_groups) and "projections".stream_id not in (select stream_id from permission_group_streams)
2026-11-12T00:00:09+00:00 host app[postgres.2493917] [109-3]  sql_error_code = 00000 time_ms = "2026-11-12 00:00:09.468 UTC" pid="1123298" proc_start_time="2026-11-11 23:36:00 UTC" session_id="6af4fbe0.1123e2" vtid="12/498490" tid="0" log_line="31" database="ddvvgu681gm35p" connection_source="10.0.158.208(39246)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'oafv1', $2 = 'listing', $3 = 'publisher', $4 = 'solution', $5 = 'publisher_force', $6 = 'pricing_plan', $7 = 'security_review', $8 = 'security_review_payment'