2026-11-11T15:52:02+00:00 host app[postgres.2401179] [86-1]  sql_error_code = 00000 time_ms = "2026-11-11 15:52:02.690 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420103" tid="0" log_line="4" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3233.821 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-11T15:52:02+00:00 host app[postgres.2401179] [86-2]  sql_error_code = 00000 time_ms = "2026-11-11 15:52:02.690 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420103" tid="0" log_line="5" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'
2026-11-11T15:52:08+00:00 host app[postgres.2401179] [87-1]  sql_error_code = 00000 time_ms = "2026-11-11 15:52:08.266 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420106" tid="0" log_line="6" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3074.986 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-11T15:52:08+00:00 host app[postgres.2401179] [87-2]  sql_error_code = 00000 time_ms = "2026-11-11 15:52:08.266 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420106" tid="0" log_line="7" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'
2026-11-11T15:53:17+00:00 host app[postgres.2401179] [90-1]  sql_error_code = 00000 time_ms = "2026-11-11 15:53:17.433 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420115" tid="0" log_line="12" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3062.513 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-11T15:53:17+00:00 host app[postgres.2401179] [90-2]  sql_error_code = 00000 time_ms = "2026-11-11 15:53:17.433 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420115" tid="0" log_line="13" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'
2026-11-11T15:54:34+00:00 host app[postgres.2401179] [91-1]  sql_error_code = 00000 time_ms = "2026-11-11 15:54:34.484 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420118" tid="0" log_line="14" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3062.574 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-11T15:54:34+00:00 host app[postgres.2401179] [91-2]  sql_error_code = 00000 time_ms = "2026-11-11 15:54:34.484 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420118" tid="0" log_line="15" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = 'listing', $2 = 'oafv1', $3 = '0013000000HkkOAAAZ', $4 = '2026-10-30 07:27:53.96+00'
2026-11-11T15:54:43+00:00 host app[postgres.2401179] [92-1]  sql_error_code = 00000 time_ms = "2026-11-11 15:54:43.706 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420121" tid="0" log_line="16" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 3091.655 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-11T15:54:43+00:00 host app[postgres.2401179] [92-2]  sql_error_code = 00000 time_ms = "2026-11-11 15:54:43.706 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420121" tid="0" log_line="17" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" 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:01:15+00:00 host app[postgres.2401179] [99-1]  sql_error_code = 00000 time_ms = "2026-11-11 16:01:15.516 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/0" tid="0" log_line="25" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 2154.976 ms  statement: select "type", count("id") from "deltas" where "created_at" between NOW() - INTERVAL '24 HOURS' and NOW() group by "type"
2026-11-11T16:01:27+00:00 host app[postgres.2401179] [100-1]  sql_error_code = 00000 time_ms = "2026-11-11 16:01:27.382 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420157" tid="0" log_line="26" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 4358.703 ms  execute <unnamed>: select count("id") as "count_deltas", "stream_id", "type" from "deltas" group by "stream_id", "type" order by "count_deltas" DESC limit $1
2026-11-11T16:01:27+00:00 host app[postgres.2401179] [100-2]  sql_error_code = 00000 time_ms = "2026-11-11 16:01:27.382 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420157" tid="0" log_line="27" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = '10'
2026-11-11T16:01:27+00:00 host app[postgres.2401179] [101-1]  sql_error_code = 00000 time_ms = "2026-11-11 16:01:27.396 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420157" tid="0" log_line="28" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  temporary file: path "pg_tblspc/16386/PG_16_202307071/pgsql_tmp/pgsql_tmp1113493.0", size 101744640
2026-11-11T16:01:30+00:00 host app[postgres.2401179] [102-1]  sql_error_code = 00000 time_ms = "2026-11-11 16:01:30.173 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420158" tid="0" log_line="29" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 2765.571 ms  execute <unnamed>: select "streams"."id", "streams"."external_id", "streams"."type" from "streams" left outer join "deltas" on "streams"."id" = "deltas"."stream_id" where "deltas"."id" is null limit $1
2026-11-11T16:01:30+00:00 host app[postgres.2401179] [102-2]  sql_error_code = 00000 time_ms = "2026-11-11 16:01:30.173 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420158" tid="0" log_line="30" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = '100'
2026-11-11T16:01:46+00:00 host app[postgres.2401179] [103-1]  sql_error_code = 00000 time_ms = "2026-11-11 16:01:46.624 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420159" tid="0" log_line="31" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 16433.998 ms  execute <unnamed>: select "streams"."id", "streams"."external_id", "streams"."type" from "streams" left outer join "projections" on "streams"."id" = "projections"."stream_id" where "projections"."id" is null limit $1
2026-11-11T16:01:46+00:00 host app[postgres.2401179] [103-2]  sql_error_code = 00000 time_ms = "2026-11-11 16:01:46.624 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420159" tid="0" log_line="32" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = '100'
2026-11-11T16:01:56+00:00 host app[postgres.2401179] [104-1]  sql_error_code = 00000 time_ms = "2026-11-11 16:01:56.954 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420160" tid="0" log_line="33" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" LOG:  duration: 10314.247 ms  execute <unnamed>: select "streams"."id", "streams"."external_id", "streams"."type" from "streams" inner join "projections" on "streams"."id" = "projections"."stream_id" where (projection->>'sent'='false' AND projection->>'number_of_retries_to_org62' IS NOT NULL AND (projection->>'number_of_retries_to_org62')::int > 1) OR (projection->>'needs_update_from_org'='true' AND projections.updated_at NOT BETWEEN NOW() - INTERVAL '1 HOUR' AND NOW())  limit $1
2026-11-11T16:01:56+00:00 host app[postgres.2401179] [104-2]  sql_error_code = 00000 time_ms = "2026-11-11 16:01:56.954 UTC" pid="1113493" proc_start_time="2026-11-11 15:36:03 UTC" session_id="6af48b63.10fd95" vtid="19/420160" tid="0" log_line="34" database="ddvvgu681gm35p" connection_source="10.0.172.89(44844)" user="uc0g389cnbt72e" application_name="[unknown]" DETAIL:  parameters: $1 = '100'