-- LOGS TRIMMED --
Aug 16 06:29:42 fluffytail postgres[82546]: [14-1] 2024-08-16 06:29:42.473 EDT [82546] LOG:  duration: 20019.528 ms  execute ecto_42290: SELECT o0."id", o0."data", o0."inserted_at", o0."updated_at" FROM "objects" AS o0 WHERE (to_jsonb(array(select jsonb_array_elements((o0."data")#>'{url}') ->> 'href' where jsonb_typeof((o0."data")#>'{url}') = 'array'))::jsonb ?| ($1))
Aug 16 06:29:42 fluffytail postgres[82546]: [14-2] 2024-08-16 06:29:42.473 EDT [82546] DETAIL:  parameters: $1 = '{https://s3.v5.yokai.cafe/blobcatfiles/95d5d1ff73a857f61b21a87d83911493443182c676bc8aead17616aaae9c3159.unknown}'
Aug 16 06:30:19 fluffytail postgres[85654]: [12-1] 2024-08-16 06:30:19.586 EDT [85654] ERROR:  canceling statement due to user request
Aug 16 06:30:19 fluffytail postgres[85654]: [12-2] 2024-08-16 06:30:19.586 EDT [85654] STATEMENT:
Aug 16 06:30:19 fluffytail postgres[85654]: [12-3]         SELECT
Aug 16 06:30:19 fluffytail postgres[85654]: [12-4]           current_database() AS db, schemaname, tablename, reltuples::bigint AS tups, relpages::bigint AS pages, otta,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-5]           ROUND(CASE WHEN otta=0 OR sml.relpages=0 OR sml.relpages=otta THEN 0.0 ELSE sml.relpages/otta::numeric END,1) AS tbloat,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-6]           CASE WHEN relpages < otta THEN 0 ELSE relpages::bigint - otta END AS wastedpages,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-7]           CASE WHEN relpages < otta THEN 0 ELSE bs*(sml.relpages-otta)::bigint END AS wastedbytes,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-8]           CASE WHEN relpages < otta THEN '0 bytes'::text ELSE (bs*(relpages-otta))::bigint::text || ' bytes' END AS wastedsize,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-9]           iname, ituples::bigint AS itups, ipages::bigint AS ipages, iotta,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-10]           ROUND(CASE WHEN iotta=0 OR ipages=0 OR ipages=iotta THEN 0.0 ELSE ipages/iotta::numeric END,1) AS ibloat,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-11]           CASE WHEN ipages < iotta THEN 0 ELSE ipages::bigint - iotta END AS wastedipages,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-12]           CASE WHEN ipages < iotta THEN 0 ELSE bs*(ipages-iotta) END AS wastedibytes,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-13]           CASE WHEN ipages < iotta THEN '0 bytes' ELSE (bs*(ipages-iotta))::bigint::text || ' bytes' END AS wastedisize,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-14]           CASE WHEN relpages < otta THEN
Aug 16 06:30:19 fluffytail postgres[85654]: [12-15]             CASE WHEN ipages < iotta THEN 0 ELSE bs*(ipages-iotta::bigint) END
Aug 16 06:30:19 fluffytail postgres[85654]: [12-16]             ELSE CASE WHEN ipages < iotta THEN bs*(relpages-otta::bigint)
Aug 16 06:30:19 fluffytail postgres[85654]: [12-17]               ELSE bs*(relpages-otta::bigint + ipages-iotta::bigint) END
Aug 16 06:30:19 fluffytail postgres[85654]: [12-18]           END AS totalwastedbytes
Aug 16 06:30:19 fluffytail postgres[85654]: [12-19]         FROM (
Aug 16 06:30:19 fluffytail postgres[85654]: [12-20]           SELECT
Aug 16 06:30:19 fluffytail postgres[85654]: [12-21]             nn.nspname AS schemaname,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-22]             cc.relname AS tablename,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-23]             COALESCE(cc.reltuples,0) AS reltuples,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-24]             COALESCE(cc.relpages,0) AS relpages,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-25]             COALESCE(bs,0) AS bs,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-26]             COALESCE(CEIL((cc.reltuples*((datahdr+ma-
Aug 16 06:30:19 fluffytail postgres[85654]: [12-27]               (CASE WHEN datahdr%ma=0 THEN ma ELSE datahdr%ma END))+nullhdr2+4))/(bs-20::float)),0) AS otta,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-28]             COALESCE(c2.relname,'?') AS iname, COALESCE(c2.reltuples,0) AS ituples, COALESCE(c2.relpages,0) AS ipages,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-29]             COALESCE(CEIL((c2.reltuples*(datahdr-12))/(bs-20::float)),0) AS iotta -- very rough approximation, assumes all cols
Aug 16 06:30:19 fluffytail postgres[85654]: [12-30]           FROM
Aug 16 06:30:19 fluffytail postgres[85654]: [12-31]              pg_class cc
Aug 16 06:30:19 fluffytail postgres[85654]: [12-32]           JOIN pg_namespace nn ON cc.relnamespace = nn.oid AND nn.nspname <> 'information_schema'
Aug 16 06:30:19 fluffytail postgres[85654]: [12-33]           LEFT JOIN
Aug 16 06:30:19 fluffytail postgres[85654]: [12-34]           (
Aug 16 06:30:19 fluffytail postgres[85654]: [12-35]             SELECT
Aug 16 06:30:19 fluffytail postgres[85654]: [12-36]               ma,bs,foo.nspname,foo.relname,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-37]               (datawidth+(hdr+ma-(case when hdr%ma=0 THEN ma ELSE hdr%ma END)))::numeric AS datahdr,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-38]               (maxfracsum*(nullhdr+ma-(case when nullhdr%ma=0 THEN ma ELSE nullhdr%ma END))) AS nullhdr2
Aug 16 06:30:19 fluffytail postgres[85654]: [12-39]             FROM (
Aug 16 06:30:19 fluffytail postgres[85654]: [12-40]               SELECT
Aug 16 06:30:19 fluffytail postgres[85654]: [12-41]                 ns.nspname, tbl.relname, hdr, ma, bs,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-42]                 SUM((1-coalesce(null_frac,0))*coalesce(avg_width, 2048)) AS datawidth,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-43]                 MAX(coalesce(null_frac,0)) AS maxfracsum,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-44]                 hdr+(
Aug 16 06:30:19 fluffytail postgres[85654]: [12-45]                   SELECT 1+count(*)/8
Aug 16 06:30:19 fluffytail postgres[85654]: [12-46]                   FROM pg_stats s2
Aug 16 06:30:19 fluffytail postgres[85654]: [12-47]                   WHERE null_frac<>0 AND s2.schemaname = ns.nspname AND s2.tablename = tbl.relname
Aug 16 06:30:19 fluffytail postgres[85654]: [12-48]                 ) AS nullhdr
Aug 16 06:30:19 fluffytail postgres[85654]: [12-49]               FROM pg_attribute att
Aug 16 06:30:19 fluffytail postgres[85654]: [12-50]               JOIN pg_class tbl ON att.attrelid = tbl.oid
Aug 16 06:30:19 fluffytail postgres[85654]: [12-51]               JOIN pg_namespace ns ON ns.oid = tbl.relnamespace
Aug 16 06:30:19 fluffytail postgres[85654]: [12-52]               LEFT JOIN pg_stats s ON s.schemaname=ns.nspname
Aug 16 06:30:19 fluffytail postgres[85654]: [12-53]               AND s.tablename = tbl.relname
Aug 16 06:30:19 fluffytail postgres[85654]: [12-54]               AND s.inherited=false
Aug 16 06:30:19 fluffytail postgres[85654]: [12-55]               AND s.attname=att.attname,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-56]               (
Aug 16 06:30:19 fluffytail postgres[85654]: [12-57]                 SELECT
Aug 16 06:30:19 fluffytail postgres[85654]: [12-58]                   (SELECT current_setting('block_size')::numeric) AS bs,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-59]                     CASE WHEN SUBSTRING(SPLIT_PART(v, ' ', 2) FROM '#"[0-9]+.[0-9]+#"%' for '#')
Aug 16 06:30:19 fluffytail postgres[85654]: [12-60]                       IN ('8.0','8.1','8.2') THEN 27 ELSE 23 END AS hdr,
Aug 16 06:30:19 fluffytail postgres[85654]: [12-61]                   CASE WHEN v ~ 'mingw32' OR v ~ '64-bit' THEN 8 ELSE 4 END AS ma
Aug 16 06:30:19 fluffytail postgres[85654]: [12-62]                 FROM (SELECT version() AS v) AS foo
Aug 16 06:30:19 fluffytail postgres[85654]: [12-63]               ) AS constants
Aug 16 06:30:19 fluffytail postgres[85654]: [12-64]               WHERE att.attnum > 0 AND tbl.relkind='r'
Aug 16 06:30:19 fluffytail postgres[85654]: [12-65]               GROUP BY 1,2,3,4,5
Aug 16 06:30:19 fluffytail postgres[85654]: [12-66]             ) AS foo
Aug 16 06:30:19 fluffytail postgres[85654]: [12-67]           ) AS rs
Aug 16 06:30:19 fluffytail postgres[85654]: [12-68]           ON cc.relname = rs.relname AND nn.nspname = rs.nspname
Aug 16 06:30:19 fluffytail postgres[85654]: [12-69]           LEFT JOIN pg_index i ON indrelid = cc.oid
Aug 16 06:30:19 fluffytail postgres[85654]: [12-70]           LEFT JOIN pg_class c2 ON c2.oid = i.indexrelid
Aug 16 06:30:19 fluffytail postgres[85654]: [12-71]         ) AS sml
Aug 16 06:30:19 fluffytail postgres[85654]: [12-72]         WHERE sml.relpages - otta > 10 OR ipages - iotta > 10;
Aug 16 06:30:19 fluffytail postgres[85654]: [12-73]
Aug 16 06:30:21 fluffytail postgres[86067]: [12-1] 2024-08-16 06:30:21.682 EDT [86067] ERROR:  canceling statement due to user request
Aug 16 06:30:21 fluffytail postgres[86067]: [12-2] 2024-08-16 06:30:21.682 EDT [86067] STATEMENT:
Aug 16 06:30:21 fluffytail postgres[86067]: [12-3]         SELECT current_database()        AS datname,
Aug 16 06:30:21 fluffytail postgres[86067]: [12-4]                nspname                   AS schemaname,
Aug 16 06:30:21 fluffytail postgres[86067]: [12-5]                relname,
Aug 16 06:30:21 fluffytail postgres[86067]: [12-6]                st.attname,
Aug 16 06:30:21 fluffytail postgres[86067]: [12-7]                typname,
Aug 16 06:30:21 fluffytail postgres[86067]: [12-8]                (st.null_frac * 100)::int AS null_percent,
Aug 16 06:30:21 fluffytail postgres[86067]: [12-9]                case
Aug 16 06:30:21 fluffytail postgres[86067]: [12-10]                    when st.n_distinct >= 0
Aug 16 06:30:21 fluffytail postgres[86067]: [12-11]                        then st.n_distinct
Aug 16 06:30:21 fluffytail postgres[86067]: [12-12]                    else
Aug 16 06:30:21 fluffytail postgres[86067]: [12-13]                        abs(st.n_distinct) * reltuples
Aug 16 06:30:21 fluffytail postgres[86067]: [12-14]                    end                   AS "distinct"
Aug 16 06:30:21 fluffytail postgres[86067]: [12-15]         FROM pg_class c
Aug 16 06:30:21 fluffytail postgres[86067]: [12-16]                  JOIN
Aug 16 06:30:21 fluffytail postgres[86067]: [12-17]              pg_namespace ns
Aug 16 06:30:21 fluffytail postgres[86067]: [12-18]              ON
Aug 16 06:30:21 fluffytail postgres[86067]: [12-19]                  (ns.oid = relnamespace)
Aug 16 06:30:21 fluffytail postgres[86067]: [12-20]                  JOIN
Aug 16 06:30:21 fluffytail postgres[86067]: [12-21]              pg_attribute at
Aug 16 06:30:21 fluffytail postgres[86067]: [12-22]              ON
Aug 16 06:30:21 fluffytail postgres[86067]: [12-23]                  (c.oid = attrelid)
Aug 16 06:30:21 fluffytail postgres[86067]: [12-24]                  JOIN
Aug 16 06:30:21 fluffytail postgres[86067]: [12-25]              pg_type t
Aug 16 06:30:21 fluffytail postgres[86067]: [12-26]              ON
Aug 16 06:30:21 fluffytail postgres[86067]: [12-27]                  (t.oid = atttypid)
Aug 16 06:30:21 fluffytail postgres[86067]: [12-28]                  JOIN
Aug 16 06:30:21 fluffytail postgres[86067]: [12-29]              pg_stats st
Aug 16 06:30:21 fluffytail postgres[86067]: [12-30]              ON
Aug 16 06:30:21 fluffytail postgres[86067]: [12-31]                  (st.tablename = relname AND st.attname = at.attname)
Aug 16 06:30:21 fluffytail postgres[86067]: [12-32]         WHERE relkind = 'r'
Aug 16 06:30:21 fluffytail postgres[86067]: [12-33]           AND nspname NOT LIKE E'pg\\_%'
Aug 16 06:30:21 fluffytail postgres[86067]: [12-34]           AND nspname != 'information_schema'
Aug 16 06:30:21 fluffytail postgres[86067]: [12-35]           AND NOT attisdropped
Aug 16 06:30:21 fluffytail postgres[86067]: [12-36]           AND attstattarget != 0
Aug 16 06:30:21 fluffytail postgres[86067]: [12-37]           AND reltuples >= 100
Aug 16 06:30:21 fluffytail postgres[86067]: [12-38]         ORDER BY nspname,
Aug 16 06:30:21 fluffytail postgres[86067]: [12-39]                  relname,
Aug 16 06:30:21 fluffytail postgres[86067]: [12-40]                  st.attname;
Aug 16 06:30:21 fluffytail postgres[86067]: [12-41]
Aug 16 06:30:24 fluffytail postgres[85195]: [12-1] 2024-08-16 06:30:24.607 EDT [85195] LOG:  duration: 15532.062 ms  execute ecto_42290: SELECT o0."id", o0."data", o0."inserted_at", o0."updated_at" FROM "objects" AS o0 WHERE (to_jsonb(array(select jsonb_array_elements((o0."data")#>'{url}') ->> 'href' where jsonb_typeof((o0."data")#>'{url}') = 'array'))::jsonb ?| ($1))
Aug 16 06:30:24 fluffytail postgres[85195]: [12-2] 2024-08-16 06:30:24.607 EDT [85195] DETAIL:  parameters: $1 = '{https://lile.cl/system/media_attachments/files/112/931/596/065/187/129/original/3ff69736b7cd4fe8.jpeg}'
Aug 16 06:30:24 fluffytail postgres[83594]: [14-1] 2024-08-16 06:30:24.701 EDT [83594] LOG:  duration: 6999.090 ms  bind ecto_9554: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1)
Aug 16 06:30:24 fluffytail postgres[83594]: [14-2] 2024-08-16 06:30:24.701 EDT [83594] DETAIL:  parameters: $1 = 't'
Aug 16 06:40:08 fluffytail postgres[85024]: [13-1] 2024-08-16 06:40:08.862 EDT [85024] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 06:40:08 fluffytail postgres[85024]: [13-2] 2024-08-16 06:40:08.862 EDT [85024] DETAIL:  Key ((data ->> 'id'::text))=(https://blob.cat/objects/7b0668e0-f733-42c5-9f1b-c74e80102140) already exists.
Aug 16 06:40:08 fluffytail postgres[85024]: [13-3] 2024-08-16 06:40:08.862 EDT [85024] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 06:43:32 fluffytail postgres[84639]: [12-1] 2024-08-16 06:43:32.724 EDT [84639] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 06:43:32 fluffytail postgres[84639]: [12-2] 2024-08-16 06:43:32.724 EDT [84639] DETAIL:  Key ((data ->> 'id'::text))=(https://fsebugoutzone.org/objects/9525396c-8a49-4494-9944-711bfcfb1a27) already exists.
Aug 16 06:43:32 fluffytail postgres[84639]: [12-3] 2024-08-16 06:43:32.724 EDT [84639] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 06:53:51 fluffytail postgres[82546]: [15-1] 2024-08-16 06:53:51.170 EDT [82546] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 06:53:51 fluffytail postgres[82546]: [15-2] 2024-08-16 06:53:51.170 EDT [82546] DETAIL:  Key ((data ->> 'id'::text))=(https://annihilation.social/objects/d08fae6f-8dd4-4910-9592-f19ba661f467) already exists.
Aug 16 06:53:51 fluffytail postgres[82546]: [15-3] 2024-08-16 06:53:51.170 EDT [82546] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 06:54:40 fluffytail postgres[86382]: [12-1] 2024-08-16 06:54:40.144 EDT [86382] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 06:54:40 fluffytail postgres[86382]: [12-2] 2024-08-16 06:54:40.144 EDT [86382] DETAIL:  Key ((data ->> 'id'::text))=(https://poa.st/objects/2edb1263-76b0-4864-a572-e40d648ffd1f) already exists.
Aug 16 06:54:40 fluffytail postgres[86382]: [12-3] 2024-08-16 06:54:40.144 EDT [86382] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 06:56:00 fluffytail postgres[86415]: [12-1] 2024-08-16 06:56:00.458 EDT [86415] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 06:56:00 fluffytail postgres[86415]: [12-2] 2024-08-16 06:56:00.458 EDT [86415] DETAIL:  Key ((data ->> 'id'::text))=(https://nicecrew.digital/objects/690cef1f-011c-417d-8653-0c38b9f65756) already exists.
Aug 16 06:56:00 fluffytail postgres[86415]: [12-3] 2024-08-16 06:56:00.458 EDT [86415] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 06:56:00 fluffytail postgres[86078]: [12-1] 2024-08-16 06:56:00.769 EDT [86078] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 06:56:00 fluffytail postgres[86078]: [12-2] 2024-08-16 06:56:00.769 EDT [86078] DETAIL:  Key ((data ->> 'id'::text))=(https://ryona.agency/objects/9f5a9a57-8b8d-4714-8a01-02827df41bf9) already exists.
Aug 16 06:56:00 fluffytail postgres[86078]: [12-3] 2024-08-16 06:56:00.769 EDT [86078] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 06:59:54 fluffytail postgres[86382]: [13-1] 2024-08-16 06:59:54.114 EDT [86382] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 06:59:54 fluffytail postgres[86382]: [13-2] 2024-08-16 06:59:54.114 EDT [86382] DETAIL:  Key ((data ->> 'id'::text))=(https://annihilation.social/objects/8f799796-316f-4503-a4a3-649911af83fa) already exists.
Aug 16 06:59:54 fluffytail postgres[86382]: [13-3] 2024-08-16 06:59:54.114 EDT [86382] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 06:59:54 fluffytail postgres[86382]: [14-1] 2024-08-16 06:59:54.256 EDT [86382] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 06:59:54 fluffytail postgres[86382]: [14-2] 2024-08-16 06:59:54.256 EDT [86382] DETAIL:  Key ((data ->> 'id'::text))=(https://annihilation.social/objects/f7318157-23df-42b8-8d84-0641b58ba1a8) already exists.
Aug 16 06:59:54 fluffytail postgres[86382]: [14-3] 2024-08-16 06:59:54.256 EDT [86382] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 06:59:54 fluffytail postgres[83594]: [15-1] 2024-08-16 06:59:54.443 EDT [83594] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 06:59:54 fluffytail postgres[83594]: [15-2] 2024-08-16 06:59:54.443 EDT [83594] DETAIL:  Key ((data ->> 'id'::text))=(https://cum.salon/objects/40cb56e0-20be-4ad0-8cbb-81c3359cfe27) already exists.
Aug 16 06:59:54 fluffytail postgres[83594]: [15-3] 2024-08-16 06:59:54.443 EDT [83594] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 06:59:55 fluffytail postgres[86382]: [15-1] 2024-08-16 06:59:55.011 EDT [86382] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 06:59:55 fluffytail postgres[86382]: [15-2] 2024-08-16 06:59:55.011 EDT [86382] DETAIL:  Key ((data ->> 'id'::text))=(https://annihilation.social/objects/98afae06-3085-42fa-a2ea-456e451cd94c) already exists.
Aug 16 06:59:55 fluffytail postgres[86382]: [15-3] 2024-08-16 06:59:55.011 EDT [86382] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 07:00:12 fluffytail postgres[84639]: [13-1] 2024-08-16 07:00:12.977 EDT [84639] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 07:00:12 fluffytail postgres[84639]: [13-2] 2024-08-16 07:00:12.977 EDT [84639] DETAIL:  Key ((data ->> 'id'::text))=(https://blob.cat/objects/c71eca2d-a281-49b4-887b-0211f7f9f201) already exists.
Aug 16 07:00:12 fluffytail postgres[84639]: [13-3] 2024-08-16 07:00:12.977 EDT [84639] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 07:00:45 fluffytail postgres[86415]: [13-1] 2024-08-16 07:00:45.159 EDT [86415] LOG:  duration: 34925.676 ms  execute ecto_42290: SELECT o0."id", o0."data", o0."inserted_at", o0."updated_at" FROM "objects" AS o0 WHERE (to_jsonb(array(select jsonb_array_elements((o0."data")#>'{url}') ->> 'href' where jsonb_typeof((o0."data")#>'{url}') = 'array'))::jsonb ?| ($1))
Aug 16 07:00:45 fluffytail postgres[86415]: [13-2] 2024-08-16 07:00:45.159 EDT [86415] DETAIL:  parameters: $1 = '{https://annihilation.social/media/32abbacd-aae9-4a55-80ad-a115509a80dc/GVCZ2pDaEAczTq9.png?name=GVCZ2pDaEAczTq9.png}'
Aug 16 07:02:34 fluffytail postgres[84639]: [14-1] 2024-08-16 07:02:34.387 EDT [84639] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 07:02:34 fluffytail postgres[84639]: [14-2] 2024-08-16 07:02:34.387 EDT [84639] DETAIL:  Key ((data ->> 'id'::text))=(https://cum.salon/objects/a4eb8c28-1e03-4d0d-907f-9bd953b6d80c) already exists.
Aug 16 07:02:34 fluffytail postgres[84639]: [14-3] 2024-08-16 07:02:34.387 EDT [84639] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 07:02:34 fluffytail postgres[83594]: [16-1] 2024-08-16 07:02:34.464 EDT [83594] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 07:02:34 fluffytail postgres[83594]: [16-2] 2024-08-16 07:02:34.464 EDT [83594] DETAIL:  Key ((data ->> 'id'::text))=(https://ryona.agency/objects/76def2ac-864e-4faa-982c-3ac3149c1b90) already exists.
Aug 16 07:02:34 fluffytail postgres[83594]: [16-3] 2024-08-16 07:02:34.464 EDT [83594] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 07:03:08 fluffytail postgres[86382]: [16-1] 2024-08-16 07:03:08.376 EDT [86382] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 07:03:08 fluffytail postgres[86382]: [16-2] 2024-08-16 07:03:08.376 EDT [86382] DETAIL:  Key ((data ->> 'id'::text))=(https://ryona.agency/objects/eec2e57d-2fdf-4298-a140-565fb4246f2c) already exists.
Aug 16 07:03:08 fluffytail postgres[86382]: [16-3] 2024-08-16 07:03:08.376 EDT [86382] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 07:05:47 fluffytail postgres[86373]: [12-1] 2024-08-16 07:05:47.478 EDT [86373] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 07:05:47 fluffytail postgres[86373]: [12-2] 2024-08-16 07:05:47.478 EDT [86373] DETAIL:  Key ((data ->> 'id'::text))=(https://ryona.agency/objects/975cb210-e1f4-47fd-b32f-004f6d60ed5d) already exists.
Aug 16 07:05:47 fluffytail postgres[86373]: [12-3] 2024-08-16 07:05:47.478 EDT [86373] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 07:09:42 fluffytail postgres[82546]: [16-1] 2024-08-16 07:09:42.891 EDT [82546] LOG:  duration: 10586.310 ms  execute ecto_9554: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1)
Aug 16 07:09:42 fluffytail postgres[82546]: [16-2] 2024-08-16 07:09:42.891 EDT [82546] DETAIL:  parameters: $1 = 't'
Aug 16 07:09:54 fluffytail postgres[86373]: [13-1] 2024-08-16 07:09:54.397 EDT [86373] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 07:09:54 fluffytail postgres[86373]: [13-2] 2024-08-16 07:09:54.397 EDT [86373] DETAIL:  Key ((data ->> 'id'::text))=(https://cum.salon/objects/9d0dffbd-8323-40c7-9d8b-7124c857d1a4) already exists.
Aug 16 07:09:54 fluffytail postgres[86373]: [13-3] 2024-08-16 07:09:54.397 EDT [86373] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 07:12:37 fluffytail postgres[90269]: [12-1] 2024-08-16 07:12:37.176 EDT [90269] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 07:12:37 fluffytail postgres[90269]: [12-2] 2024-08-16 07:12:37.176 EDT [90269] DETAIL:  Key ((data ->> 'id'::text))=(https://cum.salon/objects/324a39fd-cddd-4575-b7d3-beadd1682c3d) already exists.
Aug 16 07:12:37 fluffytail postgres[90269]: [12-3] 2024-08-16 07:12:37.176 EDT [90269] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 07:14:43 fluffytail postgres[86078]: [13-1] 2024-08-16 07:14:43.209 EDT [86078] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 07:14:43 fluffytail postgres[86078]: [13-2] 2024-08-16 07:14:43.209 EDT [86078] DETAIL:  Key ((data ->> 'id'::text))=(https://pleromashit.nexus/objects/c800099c-0302-44e0-98f4-704f010333c5) already exists.
Aug 16 07:14:43 fluffytail postgres[86078]: [13-3] 2024-08-16 07:14:43.209 EDT [86078] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 07:15:16 fluffytail postgres[85388]: [12-1] 2024-08-16 07:15:16.835 EDT [85388] ERROR:  canceling statement due to user request
Aug 16 07:15:16 fluffytail postgres[85388]: [12-2] 2024-08-16 07:15:16.835 EDT [85388] CONTEXT:  SQL statement "INSERT INTO "counter_cache" ("instance", public) VALUES ($1, 1)
Aug 16 07:15:16 fluffytail postgres[85388]: [12-3]                               ON CONFLICT ("instance") DO
Aug 16 07:15:16 fluffytail postgres[85388]: [12-4]                               UPDATE SET public = "counter_cache".public + 1"
Aug 16 07:15:16 fluffytail postgres[85388]: [12-5]         PL/pgSQL function update_status_visibility_counter_cache() line 18 at EXECUTE
Aug 16 07:15:16 fluffytail postgres[85388]: [12-6] 2024-08-16 07:15:16.835 EDT [85388] STATEMENT:  INSERT INTO "activities" ("actor","data","local","recipients","id","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5,$6,$7)
Aug 16 07:15:16 fluffytail postgres[85388]: [13-1] 2024-08-16 07:15:16.839 EDT [85388] LOG:  could not send data to client: Broken pipe
Aug 16 07:15:16 fluffytail postgres[85388]: [14-1] 2024-08-16 07:15:16.839 EDT [85388] FATAL:  connection to client lost
Aug 16 07:15:37 fluffytail postgres[90684]: [12-1] 2024-08-16 07:15:37.590 EDT [90684] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 07:15:37 fluffytail postgres[90684]: [12-2] 2024-08-16 07:15:37.590 EDT [90684] DETAIL:  Key ((data ->> 'id'::text))=(https://quietplace.xyz/notes/9wujf7zxyuf40y88) already exists.
Aug 16 07:15:37 fluffytail postgres[90684]: [12-3] 2024-08-16 07:15:37.590 EDT [90684] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 07:30:38 fluffytail postgres[90687]: [12-1] 2024-08-16 07:30:38.576 EDT [90687] LOG:  duration: 27631.854 ms  execute ecto_42290: SELECT o0."id", o0."data", o0."inserted_at", o0."updated_at" FROM "objects" AS o0 WHERE (to_jsonb(array(select jsonb_array_elements((o0."data")#>'{url}') ->> 'href' where jsonb_typeof((o0."data")#>'{url}') = 'array'))::jsonb ?| ($1))
Aug 16 07:30:38 fluffytail postgres[90687]: [12-2] 2024-08-16 07:30:38.576 EDT [90687] DETAIL:  parameters: $1 = '{https://lile.cl/system/media_attachments/files/112/931/832/012/237/027/original/30dffb1a00b9652d.jpeg}'
Aug 16 07:32:24 fluffytail postgres[90687]: [13-1] 2024-08-16 07:32:24.799 EDT [90687] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 07:32:24 fluffytail postgres[90687]: [13-2] 2024-08-16 07:32:24.799 EDT [90687] DETAIL:  Key ((data ->> 'id'::text))=(https://lor.sh/users/skobkin/statuses/112966515027506125) already exists.
Aug 16 07:32:24 fluffytail postgres[90687]: [13-3] 2024-08-16 07:32:24.799 EDT [90687] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 07:32:54 fluffytail postgres[90316]: [12-1] 2024-08-16 07:32:54.874 EDT [90316] ERROR:  duplicate key value violates unique constraint "instances_host_index"
Aug 16 07:32:54 fluffytail postgres[90316]: [12-2] 2024-08-16 07:32:54.874 EDT [90316] DETAIL:  Key (host)=(capivarinha.club) already exists.
Aug 16 07:32:54 fluffytail postgres[90316]: [12-3] 2024-08-16 07:32:54.874 EDT [90316] STATEMENT:  INSERT INTO "instances" ("favicon","favicon_updated_at","host","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5) RETURNING "id"
Aug 16 07:32:54 fluffytail postgres[90358]: [12-1] 2024-08-16 07:32:54.908 EDT [90358] ERROR:  duplicate key value violates unique constraint "instances_host_index"
Aug 16 07:32:54 fluffytail postgres[90358]: [12-2] 2024-08-16 07:32:54.908 EDT [90358] DETAIL:  Key (host)=(capivarinha.club) already exists.
Aug 16 07:32:54 fluffytail postgres[90358]: [12-3] 2024-08-16 07:32:54.908 EDT [90358] STATEMENT:  INSERT INTO "instances" ("favicon","favicon_updated_at","host","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5) RETURNING "id"
Aug 16 07:32:54 fluffytail postgres[90687]: [14-1] 2024-08-16 07:32:54.956 EDT [90687] ERROR:  duplicate key value violates unique constraint "instances_host_index"
Aug 16 07:32:54 fluffytail postgres[90687]: [14-2] 2024-08-16 07:32:54.956 EDT [90687] DETAIL:  Key (host)=(capivarinha.club) already exists.
Aug 16 07:32:54 fluffytail postgres[90687]: [14-3] 2024-08-16 07:32:54.956 EDT [90687] STATEMENT:  INSERT INTO "instances" ("favicon","favicon_updated_at","host","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5) RETURNING "id"
Aug 16 07:40:09 fluffytail postgres[90358]: [13-1] 2024-08-16 07:40:09.997 EDT [90358] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 07:40:09 fluffytail postgres[90358]: [13-2] 2024-08-16 07:40:09.997 EDT [90358] DETAIL:  Key ((data ->> 'id'::text))=(https://blob.cat/objects/9d8f86d8-ffea-4348-8e5a-b70a5a1aec1d) already exists.
Aug 16 07:40:09 fluffytail postgres[90358]: [13-3] 2024-08-16 07:40:09.997 EDT [90358] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 07:46:48 fluffytail postgres[86078]: [14-1] 2024-08-16 07:46:48.169 EDT [86078] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 07:46:48 fluffytail postgres[86078]: [14-2] 2024-08-16 07:46:48.169 EDT [86078] DETAIL:  Key ((data ->> 'id'::text))=(https://poa.st/objects/d6f522ae-42ba-4086-9c37-ea4381bb65fb) already exists.
Aug 16 07:46:48 fluffytail postgres[86078]: [14-3] 2024-08-16 07:46:48.169 EDT [86078] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 07:56:23 fluffytail postgres[86078]: [15-1] 2024-08-16 07:56:23.565 EDT [86078] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 07:56:23 fluffytail postgres[86078]: [15-2] 2024-08-16 07:56:23.565 EDT [86078] DETAIL:  Key ((data ->> 'id'::text))=(https://fsebugoutzone.org/objects/b85d0e95-610f-4c13-8221-af4b7f8bfebf) already exists.
Aug 16 07:56:23 fluffytail postgres[86078]: [15-3] 2024-08-16 07:56:23.565 EDT [86078] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"

-- PLEROMA STARTS TO COMPLAIN ABOUT TIMEOUTS HERE --

Aug 16 08:13:01 fluffytail postgres[94844]: [12-1] 2024-08-16 08:13:01.267 EDT [94844] ERROR:  canceling statement due to user request
Aug 16 08:13:01 fluffytail postgres[94844]: [12-2] 2024-08-16 08:13:01.267 EDT [94844] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:13:01 fluffytail postgres[92982]: [12-1] 2024-08-16 08:13:01.267 EDT [92982] ERROR:  canceling statement due to user request
Aug 16 08:13:01 fluffytail postgres[92982]: [12-2] 2024-08-16 08:13:01.267 EDT [92982] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:13:01 fluffytail postgres[90360]: [12-1] 2024-08-16 08:13:01.266 EDT [90360] ERROR:  canceling statement due to user request
Aug 16 08:13:01 fluffytail postgres[90360]: [12-2] 2024-08-16 08:13:01.266 EDT [90360] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:13:01 fluffytail postgres[83594]: [17-1] 2024-08-16 08:13:01.276 EDT [83594] ERROR:  canceling statement due to user request
Aug 16 08:13:01 fluffytail postgres[83594]: [17-2] 2024-08-16 08:13:01.276 EDT [83594] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:13:01 fluffytail postgres[95023]: [12-1] 2024-08-16 08:13:01.297 EDT [95023] ERROR:  canceling statement due to user request
Aug 16 08:13:01 fluffytail postgres[95023]: [12-2] 2024-08-16 08:13:01.297 EDT [95023] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:13:01 fluffytail postgres[90360]: [13-1] 2024-08-16 08:13:01.311 EDT [90360] LOG:  could not send data to client: Broken pipe
Aug 16 08:13:01 fluffytail postgres[90360]: [14-1] 2024-08-16 08:13:01.311 EDT [90360] FATAL:  connection to client lost
Aug 16 08:13:01 fluffytail postgres[92982]: [13-1] 2024-08-16 08:13:01.315 EDT [92982] LOG:  could not send data to client: Broken pipe
Aug 16 08:13:01 fluffytail postgres[92982]: [14-1] 2024-08-16 08:13:01.315 EDT [92982] FATAL:  connection to client lost
Aug 16 08:13:01 fluffytail postgres[90318]: [12-1] 2024-08-16 08:13:01.311 EDT [90318] ERROR:  canceling statement due to user request
Aug 16 08:13:01 fluffytail postgres[90318]: [12-2] 2024-08-16 08:13:01.311 EDT [90318] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:13:01 fluffytail postgres[83594]: [18-1] 2024-08-16 08:13:01.317 EDT [83594] LOG:  could not send data to client: Broken pipe
Aug 16 08:13:01 fluffytail postgres[83594]: [19-1] 2024-08-16 08:13:01.317 EDT [83594] FATAL:  connection to client lost
Aug 16 08:13:01 fluffytail postgres[94844]: [13-1] 2024-08-16 08:13:01.318 EDT [94844] LOG:  could not send data to client: Broken pipe
Aug 16 08:13:01 fluffytail postgres[94844]: [14-1] 2024-08-16 08:13:01.318 EDT [94844] FATAL:  connection to client lost
Aug 16 08:13:01 fluffytail postgres[93672]: [12-1] 2024-08-16 08:13:01.458 EDT [93672] ERROR:  canceling statement due to user request
Aug 16 08:13:01 fluffytail postgres[93672]: [12-2] 2024-08-16 08:13:01.458 EDT [93672] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:13:08 fluffytail postgres[90316]: [13-1] 2024-08-16 08:13:08.158 EDT [90316] ERROR:  canceling statement due to user request
Aug 16 08:13:08 fluffytail postgres[90316]: [13-2] 2024-08-16 08:13:08.158 EDT [90316] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:13:08 fluffytail postgres[90316]: [14-1] 2024-08-16 08:13:08.159 EDT [90316] LOG:  could not send data to client: Broken pipe
Aug 16 08:13:08 fluffytail postgres[90316]: [15-1] 2024-08-16 08:13:08.159 EDT [90316] FATAL:  connection to client lost
Aug 16 08:13:33 fluffytail postgres[95287]: [12-1] 2024-08-16 08:13:33.711 EDT [95287] ERROR:  canceling statement due to user request
Aug 16 08:13:33 fluffytail postgres[95287]: [12-2] 2024-08-16 08:13:33.711 EDT [95287] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:13:57 fluffytail postgres[95294]: [12-1] 2024-08-16 08:13:57.461 EDT [95294] ERROR:  canceling statement due to user request
Aug 16 08:13:57 fluffytail postgres[95294]: [12-2] 2024-08-16 08:13:57.461 EDT [95294] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:13:57 fluffytail postgres[95294]: [13-1] 2024-08-16 08:13:57.468 EDT [95294] LOG:  could not send data to client: Broken pipe
Aug 16 08:13:57 fluffytail postgres[95294]: [14-1] 2024-08-16 08:13:57.468 EDT [95294] FATAL:  connection to client lost
Aug 16 08:15:08 fluffytail postgres[95291]: [12-1] 2024-08-16 08:15:08.562 EDT [95291] ERROR:  canceling statement due to user request
Aug 16 08:15:08 fluffytail postgres[95291]: [12-2] 2024-08-16 08:15:08.562 EDT [95291] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:15:08 fluffytail postgres[95291]: [13-1] 2024-08-16 08:15:08.563 EDT [95291] LOG:  could not send data to client: Broken pipe
Aug 16 08:15:08 fluffytail postgres[95291]: [14-1] 2024-08-16 08:15:08.563 EDT [95291] FATAL:  connection to client lost
Aug 16 08:15:49 fluffytail postgres[95296]: [12-1] 2024-08-16 08:15:49.909 EDT [95296] ERROR:  canceling statement due to user request
Aug 16 08:15:49 fluffytail postgres[95296]: [12-2] 2024-08-16 08:15:49.909 EDT [95296] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:15:52 fluffytail postgres[95359]: [12-1] 2024-08-16 08:15:52.426 EDT [95359] ERROR:  canceling statement due to user request
Aug 16 08:15:52 fluffytail postgres[95359]: [12-2] 2024-08-16 08:15:52.426 EDT [95359] CONTEXT:  PL/pgSQL function associated_object_id(jsonb) line 4 at statement block
Aug 16 08:15:52 fluffytail postgres[95359]: [12-3] 2024-08-16 08:15:52.426 EDT [95359] STATEMENT:  INSERT INTO "activities" ("actor","data","local","recipients","id","inserted_at","updated_at") VALUES ($1,$2,$3,$4,$5,$6,$7)
Aug 16 08:15:52 fluffytail postgres[95359]: [13-1] 2024-08-16 08:15:52.442 EDT [95359] LOG:  could not send data to client: Broken pipe
Aug 16 08:15:52 fluffytail postgres[95359]: [14-1] 2024-08-16 08:15:52.442 EDT [95359] FATAL:  connection to client lost
Aug 16 08:15:59 fluffytail postgres[95431]: [12-1] 2024-08-16 08:15:59.662 EDT [95431] ERROR:  canceling statement due to user request
Aug 16 08:15:59 fluffytail postgres[95431]: [12-2] 2024-08-16 08:15:59.662 EDT [95431] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:15:59 fluffytail postgres[95383]: [12-1] 2024-08-16 08:15:59.907 EDT [95383] LOG:  duration: 5768.116 ms  execute ecto_11906: SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:15:59 fluffytail postgres[95383]: [12-2] 2024-08-16 08:15:59.907 EDT [95383] DETAIL:  parameters: $1 = '{https://www.w3.org/ns/activitystreams#Public}', $2 = 'https://uwu.social/users/koakuma', $3 = '{Listen}', $4 = '1'
Aug 16 08:16:24 fluffytail postgres[95295]: [12-1] 2024-08-16 08:16:24.181 EDT [95295] ERROR:  canceling statement due to user request
Aug 16 08:16:24 fluffytail postgres[95295]: [12-2] 2024-08-16 08:16:24.181 EDT [95295] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:16:24 fluffytail postgres[95295]: [13-1] 2024-08-16 08:16:24.269 EDT [95295] LOG:  could not send data to client: Broken pipe
Aug 16 08:16:24 fluffytail postgres[95295]: [14-1] 2024-08-16 08:16:24.269 EDT [95295] FATAL:  connection to client lost
Aug 16 08:16:24 fluffytail postgres[95523]: [12-1] 2024-08-16 08:16:24.412 EDT [95523] ERROR:  canceling statement due to user request
Aug 16 08:16:24 fluffytail postgres[95523]: [12-2] 2024-08-16 08:16:24.412 EDT [95523] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:16:24 fluffytail postgres[95523]: [13-1] 2024-08-16 08:16:24.482 EDT [95523] LOG:  could not send data to client: Broken pipe
Aug 16 08:16:24 fluffytail postgres[95523]: [14-1] 2024-08-16 08:16:24.482 EDT [95523] FATAL:  connection to client lost
Aug 16 08:16:29 fluffytail postgres[95623]: [12-1] 2024-08-16 08:16:29.979 EDT [95623] LOG:  duration: 5484.260 ms  execute ecto_9554: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1)
Aug 16 08:16:29 fluffytail postgres[95623]: [12-2] 2024-08-16 08:16:29.979 EDT [95623] DETAIL:  parameters: $1 = 't'
Aug 16 08:16:51 fluffytail postgres[95288]: [12-1] 2024-08-16 08:16:51.561 EDT [95288] ERROR:  canceling statement due to user request
Aug 16 08:16:51 fluffytail postgres[95288]: [12-2] 2024-08-16 08:16:51.561 EDT [95288] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:16:51 fluffytail postgres[95288]: [13-1] 2024-08-16 08:16:51.596 EDT [95288] LOG:  could not send data to client: Broken pipe
Aug 16 08:16:51 fluffytail postgres[95288]: [14-1] 2024-08-16 08:16:51.596 EDT [95288] FATAL:  connection to client lost
Aug 16 08:17:01 fluffytail postgres[95606]: [12-1] 2024-08-16 08:17:01.704 EDT [95606] ERROR:  canceling statement due to user request
Aug 16 08:17:01 fluffytail postgres[95606]: [12-2] 2024-08-16 08:17:01.704 EDT [95606] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:17:18 fluffytail postgres[95612]: [12-1] 2024-08-16 08:17:18.048 EDT [95612] LOG:  duration: 6365.839 ms  execute ecto_11906: SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:17:18 fluffytail postgres[95612]: [12-2] 2024-08-16 08:17:18.048 EDT [95612] DETAIL:  parameters: $1 = '{https://www.w3.org/ns/activitystreams#Public}', $2 = 'https://brotka.st/users/schappi', $3 = '{Listen}', $4 = '1'
Aug 16 08:17:32 fluffytail postgres[95383]: [13-1] 2024-08-16 08:17:32.725 EDT [95383] LOG:  duration: 9780.348 ms  execute ecto_11906: SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:17:32 fluffytail postgres[95383]: [13-2] 2024-08-16 08:17:32.725 EDT [95383] DETAIL:  parameters: $1 = '{https://www.w3.org/ns/activitystreams#Public}', $2 = 'https://outerheaven.club/users/xarvos', $3 = '{Listen}', $4 = '1'
Aug 16 08:17:41 fluffytail postgres[95671]: [12-1] 2024-08-16 08:17:41.713 EDT [95671] ERROR:  canceling statement due to user request
Aug 16 08:17:41 fluffytail postgres[95671]: [12-2] 2024-08-16 08:17:41.713 EDT [95671] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:17:41 fluffytail postgres[95671]: [13-1] 2024-08-16 08:17:41.722 EDT [95671] LOG:  could not send data to client: Broken pipe
Aug 16 08:17:41 fluffytail postgres[95671]: [14-1] 2024-08-16 08:17:41.722 EDT [95671] FATAL:  connection to client lost
Aug 16 08:17:42 fluffytail postgres[95670]: [12-1] 2024-08-16 08:17:42.736 EDT [95670] ERROR:  canceling statement due to user request
Aug 16 08:17:42 fluffytail postgres[95670]: [12-2] 2024-08-16 08:17:42.736 EDT [95670] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:17:42 fluffytail postgres[95670]: [13-1] 2024-08-16 08:17:42.744 EDT [95670] LOG:  could not send data to client: Broken pipe
Aug 16 08:17:42 fluffytail postgres[95670]: [14-1] 2024-08-16 08:17:42.744 EDT [95670] FATAL:  connection to client lost
Aug 16 08:18:03 fluffytail postgres[95306]: [12-1] 2024-08-16 08:18:03.145 EDT [95306] ERROR:  canceling statement due to user request
Aug 16 08:18:03 fluffytail postgres[95306]: [12-2] 2024-08-16 08:18:03.145 EDT [95306] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:18:34 fluffytail postgres[95747]: [12-1] 2024-08-16 08:18:34.630 EDT [95747] ERROR:  canceling statement due to user request
Aug 16 08:18:34 fluffytail postgres[95747]: [12-2] 2024-08-16 08:18:34.630 EDT [95747] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:18:34 fluffytail postgres[95747]: [13-1] 2024-08-16 08:18:34.675 EDT [95747] LOG:  could not send data to client: Broken pipe
Aug 16 08:18:34 fluffytail postgres[95747]: [14-1] 2024-08-16 08:18:34.675 EDT [95747] FATAL:  connection to client lost
Aug 16 08:18:34 fluffytail postgres[95847]: [12-1] 2024-08-16 08:18:34.743 EDT [95847] ERROR:  canceling statement due to user request
Aug 16 08:18:34 fluffytail postgres[95847]: [12-2] 2024-08-16 08:18:34.743 EDT [95847] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:18:34 fluffytail postgres[95383]: [14-1] 2024-08-16 08:18:34.744 EDT [95383] ERROR:  canceling statement due to user request
Aug 16 08:18:34 fluffytail postgres[95383]: [14-2] 2024-08-16 08:18:34.744 EDT [95383] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:18:34 fluffytail postgres[95725]: [12-1] 2024-08-16 08:18:34.713 EDT [95725] ERROR:  canceling statement due to user request
Aug 16 08:18:34 fluffytail postgres[95725]: [12-2] 2024-08-16 08:18:34.713 EDT [95725] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:18:34 fluffytail postgres[95623]: [13-1] 2024-08-16 08:18:34.745 EDT [95623] ERROR:  canceling statement due to user request
Aug 16 08:18:34 fluffytail postgres[95623]: [13-2] 2024-08-16 08:18:34.745 EDT [95623] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:18:34 fluffytail postgres[95579]: [12-1] 2024-08-16 08:18:34.746 EDT [95579] ERROR:  canceling statement due to user request
Aug 16 08:18:34 fluffytail postgres[95579]: [12-2] 2024-08-16 08:18:34.746 EDT [95579] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:18:34 fluffytail postgres[95842]: [12-1] 2024-08-16 08:18:34.748 EDT [95842] ERROR:  canceling statement due to user request
Aug 16 08:18:34 fluffytail postgres[95842]: [12-2] 2024-08-16 08:18:34.748 EDT [95842] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:18:34 fluffytail postgres[95842]: [13-1] 2024-08-16 08:18:34.748 EDT [95842] LOG:  could not send data to client: Broken pipe
Aug 16 08:18:34 fluffytail postgres[95842]: [14-1] 2024-08-16 08:18:34.748 EDT [95842] FATAL:  connection to client lost
Aug 16 08:18:34 fluffytail postgres[95623]: [14-1] 2024-08-16 08:18:34.749 EDT [95623] LOG:  could not send data to client: Broken pipe
Aug 16 08:18:34 fluffytail postgres[95623]: [15-1] 2024-08-16 08:18:34.749 EDT [95623] FATAL:  connection to client lost
Aug 16 08:18:34 fluffytail postgres[95358]: [12-1] 2024-08-16 08:18:34.748 EDT [95358] ERROR:  canceling statement due to user request
Aug 16 08:18:34 fluffytail postgres[95612]: [13-1] 2024-08-16 08:18:34.746 EDT [95612] ERROR:  canceling statement due to user request
Aug 16 08:18:34 fluffytail postgres[95612]: [13-2] 2024-08-16 08:18:34.746 EDT [95612] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:18:34 fluffytail postgres[95358]: [12-2] 2024-08-16 08:18:34.748 EDT [95358] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:18:34 fluffytail postgres[95358]: [13-1] 2024-08-16 08:18:34.806 EDT [95358] LOG:  could not send data to client: Broken pipe
Aug 16 08:18:34 fluffytail postgres[95358]: [14-1] 2024-08-16 08:18:34.806 EDT [95358] FATAL:  connection to client lost
Aug 16 08:18:38 fluffytail postgres[95928]: [12-1] 2024-08-16 08:18:38.167 EDT [95928] ERROR:  canceling statement due to user request
Aug 16 08:18:38 fluffytail postgres[95928]: [12-2] 2024-08-16 08:18:38.167 EDT [95928] STATEMENT:  SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1)

-- INSTANCE DEAD --

Aug 16 08:22:29 fluffytail postgres[96215]: [12-1] 2024-08-16 08:22:29.847 EDT [96215] ERROR:  syntax error at or near "by" at character 44
Aug 16 08:22:29 fluffytail postgres[96215]: [12-2] 2024-08-16 08:22:29.847 EDT [96215] STATEMENT:  select data->>'actor' from objects ordered by inserted_at desc limit 2;
Aug 16 08:22:50 fluffytail postgres[96215]: [13-1] 2024-08-16 08:22:50.906 EDT [96215] LOG:  duration: 15450.464 ms  statement: select data->>'actor' from objects order by inserted_at desc limit 2;
Aug 16 08:23:09 fluffytail postgres[96215]: [14-1] 2024-08-16 08:23:09.228 EDT [96215] LOG:  duration: 11193.408 ms  statement: select data->>'actor',inserted_at from objects order by inserted_at desc limit 2;
Aug 16 08:25:52 fluffytail postgres[96215]: [15-1] 2024-08-16 08:25:52.622 EDT [96215] LOG:  duration: 69524.400 ms  statement: select data->>'actor',inserted_at from activities order by inserted_at desc limit 2;

-- INSTANCE RESTARTED --

Aug 16 08:30:39 fluffytail postgres[97827]: [12-1] 2024-08-16 08:30:39.003 EDT [97827] ERROR:  canceling statement due to user request
Aug 16 08:30:39 fluffytail postgres[97827]: [12-2] 2024-08-16 08:30:39.003 EDT [97827] STATEMENT:  SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1)
Aug 16 08:30:39 fluffytail postgres[97827]: [13-1] 2024-08-16 08:30:39.032 EDT [97827] LOG:  could not send data to client: Broken pipe
Aug 16 08:30:39 fluffytail postgres[97827]: [14-1] 2024-08-16 08:30:39.032 EDT [97827] FATAL:  connection to client lost
Aug 16 08:30:47 fluffytail postgres[97866]: [12-1] 2024-08-16 08:30:47.376 EDT [97866] LOG:  duration: 7309.882 ms  execute ecto_9522: SELECT distinct split_part(u0."nickname", '@', 2) FROM "users" AS u0 WHERE (u0."local" != $1)
Aug 16 08:30:47 fluffytail postgres[97866]: [12-2] 2024-08-16 08:30:47.376 EDT [97866] DETAIL:  parameters: $1 = 't'
Aug 16 08:30:50 fluffytail postgres[97869]: [12-1] 2024-08-16 08:30:50.784 EDT [97869] LOG:  duration: 5464.960 ms  execute ecto_12066: SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:30:50 fluffytail postgres[97869]: [12-2] 2024-08-16 08:30:50.784 EDT [97869] DETAIL:  parameters: $1 = '{https://www.w3.org/ns/activitystreams#Public}', $2 = 'https://cawfee.club/users/JohnFediverse', $3 = '{Listen}', $4 = '1'
Aug 16 08:31:00 fluffytail postgres[97870]: [12-1] 2024-08-16 08:31:00.008 EDT [97870] LOG:  duration: 14688.054 ms  execute ecto_12066: SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:31:00 fluffytail postgres[97870]: [12-2] 2024-08-16 08:31:00.008 EDT [97870] DETAIL:  parameters: $1 = '{https://www.w3.org/ns/activitystreams#Public}', $2 = 'https://5dollah.click/users/BigTony', $3 = '{Listen}', $4 = '1'
Aug 16 08:31:28 fluffytail postgres[97873]: [12-1] 2024-08-16 08:31:28.126 EDT [97873] LOG:  duration: 23519.161 ms  execute ecto_12066: SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:31:28 fluffytail postgres[97873]: [12-2] 2024-08-16 08:31:28.126 EDT [97873] DETAIL:  parameters: $1 = '{https://www.w3.org/ns/activitystreams#Public}', $2 = 'https://mast.shitpostbot.com/users/bot', $3 = '{Listen}', $4 = '1'
Aug 16 08:31:39 fluffytail postgres[97874]: [12-1] 2024-08-16 08:31:39.486 EDT [97874] ERROR:  canceling statement due to user request
Aug 16 08:31:39 fluffytail postgres[97874]: [12-2] 2024-08-16 08:31:39.486 EDT [97874] STATEMENT:  SELECT b0."id", b0."user_id", b0."activity_id", b0."folder_id", b0."inserted_at", b0."updated_at", a1."id", a1."data", a1."local", a1."actor", a1."recipients", a1."inserted_at", a1."updated_at" FROM "bookmarks" AS b0 INNER JOIN "activities" AS a1 ON a1."id" = b0."activity_id" WHERE (b0."user_id" = $1) ORDER BY b0."id" desc nulls last LIMIT $2
Aug 16 08:31:55 fluffytail postgres[97870]: [13-1] 2024-08-16 08:31:55.302 EDT [97870] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 08:31:55 fluffytail postgres[97870]: [13-2] 2024-08-16 08:31:55.302 EDT [97870] DETAIL:  Key ((data ->> 'id'::text))=(https://ak.kyaruc.moe/objects/965ca3d0-3b2a-416c-b8af-5f9bd0fc0cae) already exists.
Aug 16 08:31:55 fluffytail postgres[97870]: [13-3] 2024-08-16 08:31:55.302 EDT [97870] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 08:32:01 fluffytail postgres[97875]: [12-1] 2024-08-16 08:32:01.870 EDT [97875] LOG:  duration: 48596.822 ms  execute ecto_14178: SELECT o0."id", o0."data", o0."inserted_at", o0."updated_at" FROM "objects" AS o0 WHERE (to_jsonb(array(select jsonb_array_elements((o0."data")#>'{url}') ->> 'href' where jsonb_typeof((o0."data")#>'{url}') = 'array'))::jsonb ?| ($1))
Aug 16 08:32:01 fluffytail postgres[97875]: [12-2] 2024-08-16 08:32:01.870 EDT [97875] DETAIL:  parameters: $1 = '{https://lile.cl/system/media_attachments/files/112/932/067/940/391/080/original/3ed58ba7b7ec50b5.jpeg}'
Aug 16 08:32:05 fluffytail postgres[97867]: [12-1] 2024-08-16 08:32:05.775 EDT [97867] ERROR:  canceling statement due to user request
Aug 16 08:32:05 fluffytail postgres[97867]: [12-2] 2024-08-16 08:32:05.775 EDT [97867] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:32:05 fluffytail postgres[97871]: [12-1] 2024-08-16 08:32:05.775 EDT [97871] ERROR:  canceling statement due to user request
Aug 16 08:32:05 fluffytail postgres[97871]: [12-2] 2024-08-16 08:32:05.775 EDT [97871] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:32:05 fluffytail postgres[97867]: [13-1] 2024-08-16 08:32:05.843 EDT [97867] LOG:  could not send data to client: Broken pipe
Aug 16 08:32:05 fluffytail postgres[97867]: [14-1] 2024-08-16 08:32:05.843 EDT [97867] FATAL:  connection to client lost
Aug 16 08:32:05 fluffytail postgres[97871]: [13-1] 2024-08-16 08:32:05.858 EDT [97871] LOG:  could not send data to client: Broken pipe
Aug 16 08:32:05 fluffytail postgres[97871]: [14-1] 2024-08-16 08:32:05.858 EDT [97871] FATAL:  connection to client lost
Aug 16 08:32:07 fluffytail postgres[97872]: [12-1] 2024-08-16 08:32:07.608 EDT [97872] LOG:  duration: 27967.520 ms  execute ecto_14002: SELECT b0."id", b0."user_id", b0."activity_id", b0."folder_id", b0."inserted_at", b0."updated_at", a1."id", a1."data", a1."local", a1."actor", a1."recipients", a1."inserted_at", a1."updated_at" FROM "bookmarks" AS b0 INNER JOIN "activities" AS a1 ON a1."id" = b0."activity_id" WHERE (b0."user_id" = $1) ORDER BY b0."id" desc nulls last LIMIT $2
Aug 16 08:32:07 fluffytail postgres[97872]: [12-2] 2024-08-16 08:32:07.608 EDT [97872] DETAIL:  parameters: $1 = '00000188-8c1f-9081-db4e-ebf4fdf00000', $2 = '20'
Aug 16 08:32:19 fluffytail postgres[98036]: [12-1] 2024-08-16 08:32:19.629 EDT [98036] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 08:32:19 fluffytail postgres[98036]: [12-2] 2024-08-16 08:32:19.629 EDT [98036] DETAIL:  Key ((data ->> 'id'::text))=(https://nicecrew.digital/objects/409f6805-61df-43d7-8d00-ae370483a974) already exists.
Aug 16 08:32:19 fluffytail postgres[98036]: [12-3] 2024-08-16 08:32:19.629 EDT [98036] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 08:32:27 fluffytail postgres[97953]: [12-1] 2024-08-16 08:32:27.270 EDT [97953] LOG:  duration: 17450.652 ms  execute ecto_12066: SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:32:27 fluffytail postgres[97953]: [12-2] 2024-08-16 08:32:27.270 EDT [97953] DETAIL:  parameters: $1 = '{https://www.w3.org/ns/activitystreams#Public}', $2 = 'https://poa.st/users/Remi', $3 = '{Listen}', $4 = '1'
Aug 16 08:32:39 fluffytail postgres[97869]: [13-1] 2024-08-16 08:32:39.900 EDT [97869] ERROR:  canceling statement due to user request
Aug 16 08:32:39 fluffytail postgres[97869]: [13-2] 2024-08-16 08:32:39.900 EDT [97869] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:32:40 fluffytail postgres[97873]: [13-1] 2024-08-16 08:32:40.049 EDT [97873] ERROR:  canceling statement due to user request
Aug 16 08:32:40 fluffytail postgres[97873]: [13-2] 2024-08-16 08:32:40.049 EDT [97873] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:32:40 fluffytail postgres[98037]: [12-1] 2024-08-16 08:32:40.088 EDT [98037] ERROR:  canceling statement due to user request
Aug 16 08:32:40 fluffytail postgres[98037]: [12-2] 2024-08-16 08:32:40.088 EDT [98037] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:32:40 fluffytail postgres[97875]: [13-1] 2024-08-16 08:32:40.176 EDT [97875] ERROR:  canceling statement due to user request
Aug 16 08:32:40 fluffytail postgres[97875]: [13-2] 2024-08-16 08:32:40.176 EDT [97875] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:32:40 fluffytail postgres[97875]: [14-1] 2024-08-16 08:32:40.182 EDT [97875] LOG:  could not send data to client: Broken pipe
Aug 16 08:32:40 fluffytail postgres[97875]: [15-1] 2024-08-16 08:32:40.182 EDT [97875] FATAL:  connection to client lost
Aug 16 08:32:49 fluffytail postgres[97979]: [12-1] 2024-08-16 08:32:49.484 EDT [97979] ERROR:  canceling statement due to user request
Aug 16 08:32:49 fluffytail postgres[97979]: [12-2] 2024-08-16 08:32:49.484 EDT [97979] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:32:49 fluffytail postgres[97868]: [12-1] 2024-08-16 08:32:49.582 EDT [97868] ERROR:  canceling statement due to user request
Aug 16 08:32:49 fluffytail postgres[97868]: [12-2] 2024-08-16 08:32:49.582 EDT [97868] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:32:49 fluffytail postgres[97979]: [13-1] 2024-08-16 08:32:49.662 EDT [97979] LOG:  could not send data to client: Broken pipe
Aug 16 08:32:49 fluffytail postgres[97979]: [14-1] 2024-08-16 08:32:49.662 EDT [97979] FATAL:  connection to client lost
Aug 16 08:32:49 fluffytail postgres[97872]: [13-1] 2024-08-16 08:32:49.887 EDT [97872] ERROR:  canceling statement due to user request
Aug 16 08:32:49 fluffytail postgres[97872]: [13-2] 2024-08-16 08:32:49.887 EDT [97872] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:32:49 fluffytail postgres[97868]: [13-1] 2024-08-16 08:32:49.908 EDT [97868] LOG:  could not send data to client: Broken pipe
Aug 16 08:32:49 fluffytail postgres[97868]: [14-1] 2024-08-16 08:32:49.908 EDT [97868] FATAL:  connection to client lost
Aug 16 08:32:49 fluffytail postgres[97872]: [14-1] 2024-08-16 08:32:49.916 EDT [97872] LOG:  could not send data to client: Broken pipe
Aug 16 08:32:49 fluffytail postgres[97872]: [15-1] 2024-08-16 08:32:49.917 EDT [97872] FATAL:  connection to client lost
Aug 16 08:32:58 fluffytail postgres[97953]: [13-1] 2024-08-16 08:32:58.997 EDT [97953] LOG:  duration: 21406.951 ms  execute ecto_12066: SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:32:58 fluffytail postgres[97953]: [13-2] 2024-08-16 08:32:58.997 EDT [97953] DETAIL:  parameters: $1 = '{https://www.w3.org/ns/activitystreams#Public}', $2 = 'https://declin.eu/users/i', $3 = '{Listen}', $4 = '1'
Aug 16 08:33:07 fluffytail postgres[98036]: [13-1] 2024-08-16 08:33:07.594 EDT [98036] ERROR:  canceling statement due to user request
Aug 16 08:33:07 fluffytail postgres[98036]: [13-2] 2024-08-16 08:33:07.594 EDT [98036] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:33:07 fluffytail postgres[98036]: [14-1] 2024-08-16 08:33:07.596 EDT [98036] LOG:  could not send data to client: Broken pipe
Aug 16 08:33:07 fluffytail postgres[98036]: [15-1] 2024-08-16 08:33:07.596 EDT [98036] FATAL:  connection to client lost
Aug 16 08:33:07 fluffytail postgres[97870]: [14-1] 2024-08-16 08:33:07.630 EDT [97870] ERROR:  canceling statement due to user request
Aug 16 08:33:07 fluffytail postgres[97870]: [14-2] 2024-08-16 08:33:07.630 EDT [97870] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:33:07 fluffytail postgres[97870]: [15-1] 2024-08-16 08:33:07.632 EDT [97870] LOG:  could not send data to client: Broken pipe
Aug 16 08:33:07 fluffytail postgres[97870]: [16-1] 2024-08-16 08:33:07.632 EDT [97870] FATAL:  connection to client lost
Aug 16 08:33:12 fluffytail postgres[98112]: [12-1] 2024-08-16 08:33:12.049 EDT [98112] LOG:  duration: 20289.795 ms  execute ecto_12066: SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:33:12 fluffytail postgres[98112]: [12-2] 2024-08-16 08:33:12.049 EDT [98112] DETAIL:  parameters: $1 = '{https://www.w3.org/ns/activitystreams#Public}', $2 = 'https://rebased.taihou.website/users/mechanicaltomato', $3 = '{Listen}', $4 = '1'
Aug 16 08:35:14 fluffytail postgres[97953]: [14-1] 2024-08-16 08:35:14.129 EDT [97953] ERROR:  canceling statement due to user request
Aug 16 08:35:14 fluffytail postgres[97953]: [14-2] 2024-08-16 08:35:14.129 EDT [97953] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:35:14 fluffytail postgres[97953]: [15-1] 2024-08-16 08:35:14.133 EDT [97953] LOG:  could not send data to client: Broken pipe
Aug 16 08:35:14 fluffytail postgres[97953]: [16-1] 2024-08-16 08:35:14.133 EDT [97953] FATAL:  connection to client lost
Aug 16 08:35:56 fluffytail postgres[98126]: [12-1] 2024-08-16 08:35:56.211 EDT [98126] ERROR:  canceling statement due to user request
Aug 16 08:35:56 fluffytail postgres[98126]: [12-2] 2024-08-16 08:35:56.211 EDT [98126] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:36:20 fluffytail postgres[98130]: [12-1] 2024-08-16 08:36:20.038 EDT [98130] LOG:  duration: 12079.904 ms  execute ecto_25010: SELECT u0."id", u0."bio", u0."raw_bio", u0."email", u0."name", u0."nickname", u0."password_hash", u0."keys", u0."public_key", u0."ap_id", u0."avatar", u0."local", u0."follower_address", u0."following_address", u0."featured_address", u0."tags", u0."last_refreshed_at", u0."last_digest_emailed_at", u0."banner", u0."background", u0."note_count", u0."follower_count", u0."following_count", u0."is_locked", u0."is_confirmed", u0."password_reset_pending", u0."is_approved", u0."registration_reason", u0."confirmation_token", u0."default_scope", u0."domain_blocks", u0."is_active", u0."no_rich_text", u0."is_moderator", u0."is_admin", u0."show_role", u0."uri", u0."hide_followers_count", u0."hide_follows_count", u0."hide_followers", u0."hide_follows", u0."hide_favorites", u0."email_notifications", u0."mascot",
Aug 16 08:36:20 fluffytail postgres[98130]: [12-2]  u0."emoji", u0."pleroma_settings_store", u0."fields", u0."raw_fields", u0."is_discoverable", u0."invisible", u0."allow_following_move", u0."skip_thread_containment", u0."actor_type", u0."also_known_as", u0."inbox", u0."shared_inbox", u0."accepts_chat_messages", u0."last_active_at", u0."disclose_client", u0."pinned_objects", u0."is_suggested", u0."last_status_at", u0."birthday", u0."show_birthday", u0."language", u0."notification_settings", u0."blocks", u0."mutes", u0."muted_reblogs", u0."muted_notifications", u0."subscribers", u0."multi_factor_authentication_settings", u0."inserted_at", u0."updated_at" FROM "users" AS u0 WHERE (NOT (u0."nickname" IS NULL)) AND (NOT (u0."nickname" LIKE 'internal.%')) AND (u0."invisible" = $1) AND (u0."is_discoverable" = $2) ORDER BY u0."last_status_at" DESC NULLS LAST, u0."id" desc nulls last LIMIT $3 OFFSET $4
Aug 16 08:36:20 fluffytail postgres[98130]: [12-3] 2024-08-16 08:36:20.038 EDT [98130] DETAIL:  parameters: $1 = 'f', $2 = 't', $3 = '1', $4 = '0'
Aug 16 08:36:36 fluffytail postgres[98316]: [12-1] 2024-08-16 08:36:36.421 EDT [98316] LOG:  duration: 6356.077 ms  execute ecto_12066: SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:36:36 fluffytail postgres[98316]: [12-2] 2024-08-16 08:36:36.421 EDT [98316] DETAIL:  parameters: $1 = '{https://www.w3.org/ns/activitystreams#Public}', $2 = 'https://bae.st/users/j', $3 = '{Listen}', $4 = '1'
Aug 16 08:37:59 fluffytail postgres[98110]: [12-1] 2024-08-16 08:37:59.601 EDT [98110] ERROR:  duplicate key value violates unique constraint "users_nickname_index"
Aug 16 08:37:59 fluffytail postgres[98110]: [12-2] 2024-08-16 08:37:59.601 EDT [98110] DETAIL:  Key (nickname)=(instance.actor@sup.lelehier.de) already exists.
Aug 16 08:37:59 fluffytail postgres[98110]: [12-3] 2024-08-16 08:37:59.601 EDT [98110] STATEMENT:  UPDATE "users" SET "follower_address" = $1, "last_refreshed_at" = $2, "name" = $3, "nickname" = $4, "updated_at" = $5 WHERE "id" = $6
Aug 16 08:38:12 fluffytail postgres[98109]: [12-1] 2024-08-16 08:38:12.284 EDT [98109] ERROR:  duplicate key value violates unique constraint "objects_unique_apid_index"
Aug 16 08:38:12 fluffytail postgres[98109]: [12-2] 2024-08-16 08:38:12.284 EDT [98109] DETAIL:  Key ((data ->> 'id'::text))=(https://shitposter.world/objects/bcf92a9b-27a2-4231-a861-9ac6797c2be8) already exists.
Aug 16 08:38:12 fluffytail postgres[98109]: [12-3] 2024-08-16 08:38:12.284 EDT [98109] STATEMENT:  INSERT INTO "objects" ("data","inserted_at","updated_at") VALUES ($1,$2,$3) RETURNING "id"
Aug 16 08:38:25 fluffytail postgres[98153]: [12-1] 2024-08-16 08:38:25.635 EDT [98153] ERROR:  canceling statement due to user request
Aug 16 08:38:25 fluffytail postgres[98153]: [12-2] 2024-08-16 08:38:25.635 EDT [98153] STATEMENT:  SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:38:25 fluffytail postgres[98153]: [13-1] 2024-08-16 08:38:25.636 EDT [98153] LOG:  could not send data to client: Broken pipe
Aug 16 08:38:25 fluffytail postgres[98153]: [14-1] 2024-08-16 08:38:25.636 EDT [98153] FATAL:  connection to client lost
Aug 16 08:38:42 fluffytail postgres[98131]: [12-1] 2024-08-16 08:38:42.269 EDT [98131] LOG:  duration: 15682.710 ms  execute ecto_12066: SELECT a0."id", a0."data", a0."local", a0."actor", a0."recipients", a0."inserted_at", a0."updated_at", o1."id", o1."data", o1."inserted_at", o1."updated_at" FROM "activities" AS a0 INNER JOIN "objects" AS o1 ON (o1."data"->>'id') = associated_object_id(a0."data") INNER JOIN "users" AS u2 ON (a0."actor" = u2."ap_id") AND (u2."is_active" = TRUE) INNER JOIN "users" AS u3 ON (a0."actor" = u3."ap_id") AND (u3."invisible" = FALSE) WHERE ($1 && a0."recipients") AND (a0."actor" = $2) AND (a0."data"->>'type' = ANY($3)) AND (not(o1."data"->>'type' = 'Answer')) AND (not(o1."data"->>'type' = 'ChatMessage')) ORDER BY a0."id" desc nulls last LIMIT $4
Aug 16 08:38:42 fluffytail postgres[98131]: [12-2] 2024-08-16 08:38:42.269 EDT [98131] DETAIL:  parameters: $1 = '{https://www.w3.org/ns/activitystreams#Public}', $2 = 'https://mai.waifuism.life/users/9otxaeemjqy70001', $3 = '{Listen}', $4 = '1'