Conversation

Charlotte lotteheartplural/Cinny cinny_heart_plural thetadelta ursaminor treblesand

lotte I really need to find a post where a moot was subtooting me because it would fit in my new quotes section

1
0
1

lotte it was something like “I really should read CWs before auto-expanding them” directly after i posted/boosted scat (properly cwd)

1
0
1

lotte the funny thing about being an instance admin is that you can do fucked up shit like listing all replies you have made to a specific user by reply length with a

select * from objects where data->>'actor' = 'https://akko.chir.rs/users/charlotte' and data->'to' @> '["https://social.treehouse.systems/users/ariadne"]' order by char_length(data->>'content') asc;
1
0
0

the query planner is crying btw

 Sort  (cost=21131.61..21132.08 rows=188 width=1466)
   Sort Key: (char_length((data ->> 'content'::text)))
   ->  Index Scan using objects_actor_type on objects  (cost=0.56..21124.51 rows=188 width=1466)
         Index Cond: ((data ->> 'actor'::text) = 'https://akko.chir.rs/users/charlotte'::text)
         Filter: ((data -> 'to'::text) @> '["https://social.treehouse.systems/users/ariadne"]'::jsonb)
1
0
0

@charlotte someone who is good at the query please help me budget this. my database is dying

0
0
0