Mastodawn

@rl_dane @joel @dm @sotolf @thedoctor @orbitalmartian @adamsdesk @krafter @roguefoam @clayton @dmoonfire @alatartheblue @kudzu @jlw_the_jobber @fbievan @btp @gorkmo @tripplehelix

brain hurts from impending notations

Nick (Alatar the Blue)May 25

@kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @tripplehelix @adamsdesk @rl_dane @jlw_the_jobber @gorkmo @amin

This is why my notifications are always on DND.

@alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @tripplehelix @adamsdesk @jlw_the_jobber @gorkmo @amin

I never have notifications turned on for the fediverse, despite how much I love it:

https://polymaths.social/@rl_dane/statuses/01JQFKMMSKBNY9FJP4A2W1G9A8

Post by R.L. Dane 🍵, @rl_dane@polymaths.social

* Loads #Fediverse notifications * @Tusky@mastodon.social whimpers * Phone bursts into flames * Spacetime folds in on itself * I'm playing [Pasur](https://en.m.wikipedia.org/wiki/Pasur_(card_game)) with Dave Bowman in the hotel room at the end of time * The unnerving space fetus is keeping score...

polymaths.social

@tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo @amin

@rl_dane @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo @amin I don't any more however I do have Enafore's beeps enabled. BEEP BEEP BEEP BEEP BEEP

I do too, although I rarely keep a browser window open, except at work, when I'm (supposedly) working. XD

@tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo @amin

@rl_dane @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo @amin I'd bet you haven't worked a day since joining the Fediverse.

I feel attacked. XD

Let's just say it's a constant struggle.

My best productivity was probably for the first two weeks on my first #ADHD medication, and then it went back to normal, no matter how many meds I tried.

So, now I'm off all of the adhd, depression, and anxiety meds. I kinda used them to get a feel for what it was like for my brain to function normally, and I just do my best to maintain THAT.

Also, I keep harping on this like a freaking #INFLUENCER, but #YerbaMate has been the very best long-term ADHD remedy I've found so far. Very stable and strong uplift. Regular tea is like riding an escalator, coffee is like a rocket that explodes half the time, mate is like a 737.
Just perfect.

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

It could just as much be the ritual as the actual actual caffeine or other qualities. I find rituals to be very strong factors in my own ability to focus.

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

No, not at all. Absolutely not a ritual, and the fact that I'm literally quoting the spice guy from Dune when preparing it doesn't mean anything at all. 🤣

Yeah. It's very ritualistic. Kind of like smoking a pipe, but it's a drink.

@tripplehelix @amin @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

@rl_dane @amin @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo Almost definitely not like smoking a pipe.

Have you done both?

The mate + bombilla combo is very pipe-like.
The yerba itself is vaguely similar to flavored pipe tobacco, if... lol... grass were a flavor. XD

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

You haven't had the lawn clippings Jelly Belly flavor?

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

Dude, Jelly Belly flavors are just WRONG.

And no, I haven't had that one. I've had popcorn, though, which is awful in that it's actually enjoyable. XD

Regular black licorice is still the worst flavor. :P

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

That's one of their "beanboozled" flavors, though; the idea is they make identical-looking jelly beans with bad flavors, then mix theme with the regular ones. A kind of russian roulette, I guess.

I liked the black licorice ones, those were my favorites.

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

I liked the black licorice ones, those were my favorites.

#TCK located ;)

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

My mom loves black licorice too, and she's not a TCK. 🤷

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

Interesting. I've not met any Americans my age or younger that liked licorice flavor.
Only my stepdad's age and older.

@tripplehelix @amin @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

Not too surprised, my general impression is that tastes in the UK are somewhere between US and the rest of Europe.

...US tastes being heavily skewed towards sweetness.

P.S., mainly talking about desserts. Tastes regarding other things are extremely varied in the US, and I know for sure Brits can't handle spice like we do. Particularly in #Texas. XD

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

I need something chewy, ideally. Flavor-wise I like cinammon and licorice the most.

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

Now I want a cinnamon twizzler (or something similar, not just that one brand which is mediocre at best). That would be insane.

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

I've had cinnamon licorice and it was glorious. Much thicker and fatter than a twizzler, though.

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

Twizzlers are honestly pretty meh. They're just the most well-known here. They don't have much flavor.

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

Agreed. If I have a choice between 'murican candies, though, I usually will request it as one of them.

Twizzlers, Reese's (pieces or cups), and Hot Tamales. Used to love red hots but haven't had them in a while.

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

ooo, red hots are the little jelly bean-kinda-like things, right? No wait, more like Mike & Ike's, but cinnamon? Those are awesome.

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

You're thinking of Hot Tamales, and yes they're made by the same company as Mike and Ike's.

Red hots are made by the same company as Nerds. And their website is giving me a 403 but maybe it'll let you through: https://www.ferraracandyshopusa.com/brands/red-hots

Redhots

These candies hit you from your nose to your toes. In the early 1930's, the Ferrara Pan Candy Company created the famous Red Hot using the same cold panned candy method used today. Whether you eat them by the handful, put them on birthday cakes or use them as a decorative touch to your gingerbread house, there are a million fiery ways to spice up your life.

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

Ah, yes! Those are way better than hot tamales!

@amin @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

How many total replies has this abomination of a #hellthread had so far? Is there an easy way to tell, other than counting them in tut?

Just counted... 124! XD

@rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

@mirabilos was just testing a query for that earlier today, no?

mirabilos

@amin @rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo enjoy:

gotosocial=> WITH RECURSIVE
    findtop AS (
        SELECT id, in_reply_to_id FROM statuses
        WHERE id='01JW3X0YS8B85R8TEJEWQJC0NS'
        UNION ALL
        SELECT s.id, s.in_reply_to_id
        FROM statuses s INNER JOIN findtop f ON s.id = f.in_reply_to_id
    ),
    threads AS (
        SELECT id, in_reply_to_id, 1 AS depth, id AS op FROM findtop
        WHERE in_reply_to_id IS NULL
        UNION ALL
        SELECT s.id, s.in_reply_to_id, t.depth + 1, t.op
        FROM statuses s INNER JOIN threads t ON s.in_reply_to_id = t.id
    ),
    counts AS (
        SELECT op, COUNT(*) AS count FROM threads GROUP BY op
    ),
    leaves AS (
        SELECT id, depth, op FROM threads
        WHERE NOT EXISTS (
                SELECT * FROM statuses s WHERE s.in_reply_to_id = threads.id
        )
    )
SELECT id AS leaf, depth, counts.op AS threadtop, count
FROM leaves INNER JOIN counts USING (op)
ORDER BY counts.op ASC, depth DESC, id ASC;
            leaf            | depth |         threadtop          | count 
----------------------------+-------+----------------------------+-------
 01JW3X0YS8B85R8TEJEWQJC0NS |    30 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3WY20GSGPJ01XMP5D0ZQ7P |    29 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3W933REMHBXECTMVH1NYDN |    27 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3Y4KD8ESBX7R89ZQWMJTQF |    26 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3VYM50EZX52AQN919NFTRW |    24 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3VTH9GR8STA1Q33PKBM9J3 |    23 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3WX1S85A0YZGA5RKPSRF42 |    23 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3X6MDRYTB6XVWYXS8F751T |    23 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3WWS00YDXQY7TQ4RV3TVQ4 |    22 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3WRH8882FKHSZ3H4WWDNZ8 |    20 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3VQ4WRMG4J2HEY209TEZ91 |    19 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3WT7Y8X1VKZPPM7XT4SP7E |    19 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3V4S08W578VF1MRDF23PXT |    18 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3WRM60PFT0ZQZJ36CGR0JP |    18 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3TS6WGP34VEEQNT02E61Y8 |    17 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3VCZPGPGTZ81GAX469QZY2 |    14 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3VNK30T0X70HKABFVW9XFA |    14 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3VKVDR392DYH91SM00HE1B |    13 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3VKDR80T358A01H5T8C68K |    12 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3X98D86PYSJM78HAEDXYHR |    12 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3V0FA0P038MCJ1CKGG8W4R |    10 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3V2XE0QPV6T2DJHHJAYY7Z |    10 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3VG1BGDFV5HJEBBSEPMKJJ |    10 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3T5C40EJ6XCAJAYW2X5CDN |     8 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3TERX04HP6P1YZW707YJWN |     8 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3TNDSG2R3JC4CMXFX4G9PF |     8 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3S4BFGEJXJY7JTXH31SYQT |     6 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3TG6SRNR6RW9RESKDYE37M |     6 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3MH8EG2M5NZHW57Z14HC18 |     5 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3T7PB0GN3NR7155K8QDN6W |     5 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
 01JW3J0JDG7NPMM8J6AV51YDEK |     2 | 01JW3HZH70G8E94EXNS1A2GNDS |   126
(31 rows)

So, the thread (before posting my reply) has 126 toots in total, 31 leaves, the deepest of which was 29 replies in (30 levels including the OP).

@mirabilos @amin @rl_dane @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo Some people included in this are going to wake up to 128 notifications?!

@tripplehelix @mirabilos @rl_dane @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

Far more, I suspect.

gorkmo May 25

@amin @tripplehelix @mirabilos @rl_dane @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber I got zero because Ice Cubes lost my place in my feed after the maintenance, but then when I refreshed and scrolled back in time…

@gorkmo @tripplehelix @mirabilos @rl_dane @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber

Ah, apologies about the place-losing, though I suspect there wasn't anything I could've done differently.

@gorkmo @tripplehelix @mirabilos @rl_dane @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber

It's probably it was just the database migrations from the GtS version upgrade that did it, too.

@cloud_manul schon recht cool, dieses SQL… bißchen doof noch, daß die Rückgabe immer genau eine rechteckige Tabelle sein muß, aber die Duplikation in den rechten Spalten ist ja auch kein Problem

Cloud Manul May 25

@mirabilos Es gibt in letzter Zeit durchaus vielversprechende Ansätze, dass man mit den Eingaben (nachdem man sie so gut wie möglich reduziert hat natürlich) eine Umwandlung in JSON(B) macht und es dann etwas leichter hat, Ergebnisse mit stark abweichenden Strukturen zusammenzuführen. Ich bin grundsätzlich dafür zu haben, aber man muss immer im Hintergrund behalten, dass das CPU-intensiv sein kann.

@cloud_manul ah, hmja, müßte man dann sehen, wie es es formatiert, aber nette Idee

@cloud_manul hm, not a fan of JSON in PostgreSQL, but it dothe work @amin @rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo

$ psql gotosocial
psql (13.21 (Debian 13.21-0+deb11u1))
Type "help" for help.

gotosocial=> \pset format unaligned
Output format is unaligned.
gotosocial=> \pset tuples_only
Tuples only is on.
gotosocial=> WITH RECURSIVE
gotosocial->     findtop AS (
gotosocial(>         SELECT id, in_reply_to_id FROM statuses
gotosocial(>         -- can use thread_id and/or multiple values here:
gotosocial(>         WHERE id IN ('01JW3X0YS8B85R8TEJEWQJC0NS')
gotosocial(>         UNION
gotosocial(>         SELECT s.id, s.in_reply_to_id
gotosocial(>         FROM statuses s INNER JOIN findtop f ON s.id = f.in_reply_to_id
gotosocial(>     ),
gotosocial->     threads AS (
gotosocial(>         SELECT id, in_reply_to_id, 1 AS depth, id AS op FROM findtop
gotosocial(>         WHERE in_reply_to_id IS NULL
gotosocial(>         UNION ALL
gotosocial(>         SELECT s.id, s.in_reply_to_id, t.depth + 1, t.op
gotosocial(>         FROM statuses s INNER JOIN threads t ON s.in_reply_to_id = t.id
gotosocial(>     ),
gotosocial->     counts AS (
gotosocial(>         SELECT op, COUNT(*) AS count FROM threads GROUP BY op ORDER BY op
gotosocial(>     ),
gotosocial->     leaves AS (
gotosocial(>         SELECT id, depth, op FROM threads WHERE NOT EXISTS (
gotosocial(>                 SELECT * FROM statuses s WHERE s.in_reply_to_id = threads.id)
gotosocial(>         ORDER BY depth DESC, id ASC
gotosocial(>     ),
gotosocial->     jleaves AS (
gotosocial(>         SELECT op, to_jsonb(array_agg(id || ': ' || depth)) AS leaves FROM leaves GROUP BY op
gotosocial(>     ),
gotosocial->     jthreads AS (
gotosocial(>         SELECT jsonb_build_object('OP', j.op, 'TOOTS', c.count, 'leaves',  jsonb_array_length(j.leaves), 'depth', j.leaves) AS t
gotosocial(>         FROM jleaves j INNER JOIN counts c USING (op) ORDER BY j.op
gotosocial(>     )
gotosocial-> SELECT jsonb_pretty(to_jsonb(array_agg(t))) FROM jthreads;
[
    {
        "OP": "01JW3HZH70G8E94EXNS1A2GNDS",
        "TOOTS": 207,
        "depth": [
            "01JW3Z997RARQM8Y7S6CJAH1VY: 37",
            "01JW43WX0X1PAKRZ9WCWKXFXR2: 34",
            "01JW45ECVG4BQT3E7V7YRFMEY4: 34",
            "01JW4004P0R0327M1T2N1Q7C9W: 31",
            "01JW3WY20GSGPJ01XMP5D0ZQ7P: 29",
            "01JW3ZWX5GE8RG3B4VABKV36KN: 29",
            "01JW45KSPRDJTDM7YR2SE7D2AH: 29",
            "01JW3W933REMHBXECTMVH1NYDN: 27",
            "01JW3VYM50EZX52AQN919NFTRW: 24",
            "01JW3Y01X0444RVT310X9RRMKG: 24",
            "01JW494YSR3TD6NKX7B2ESTCA4: 24",
            "01JW4BX24GGMXVAAQVSADPS54B: 24",
            "01JW3VTH9GR8STA1Q33PKBM9J3: 23",
            "01JW3WX1S85A0YZGA5RKPSRF42: 23",
            "01JW3X6MDRYTB6XVWYXS8F751T: 23",
            "01JW3X7VFRCZCKBZV2780BM6S2: 23",
            "01JW492ZAGNK8AN73XE9D8HEYF: 23",
            "01JW3WWS00YDXQY7TQ4RV3TVQ4: 22",
            "01JW3XMSHR0RG905GCNPK0QJX7: 22",
            "01JW48Y9X866PFTGJ7HXSNNXV3: 21",
            "01JW3WRH8882FKHSZ3H4WWDNZ8: 20",
            "01JW48VVS80JHPSNXQE5VX65HV: 20",
            "01JW4D8FS8P4JMRW485P777CZ0: 20",
            "01JW3VQ4WRMG4J2HEY209TEZ91: 19",
            "01JW3WT7Y8X1VKZPPM7XT4SP7E: 19",
            "01JW3V4S08W578VF1MRDF23PXT: 18",
            "01JW3WRM60PFT0ZQZJ36CGR0JP: 18",
            "01JW48RV3GS6R2AG1NCB7A9A2Q: 18",
            "01JW3TS6WGP34VEEQNT02E61Y8: 17",
            "01JW3WA96G8ZMV0375MZN4Y29D: 17",
            "01JW48GJERJE860HQE3TNYZ8FZ: 17",
            "01JW48QQYG6Y1NDT21K8143SE9: 17",
            "01JW3W2TXGVCKZ4GBZVX610S1W: 16",
            "01JW48F5H86GE5FQTJRYP22EX5: 16",
            "01JW4A7EA8VADPMWQ59NX4HN1Z: 16",
            "01JW4B8XKG58WEDRD5HJ27VYFS: 16",
            "01JW48MS78DR4NVZYJXCPAAE70: 15",
            "01JW498RW0E5HBKYJ0Q7305QXY: 15",
            "01JW3VNK30T0X70HKABFVW9XFA: 14",
            "01JW3VKVDR392DYH91SM00HE1B: 13",
            "01JW3W0NJRNT33ZWR10VXKBAQB: 13",
            "01JW3V2MMRXV9JPY4RDBPHF5QG: 12",
            "01JW3X98D86PYSJM78HAEDXYHR: 12",
            "01JW3V0FA0P038MCJ1CKGG8W4R: 10",
            "01JW3V2XE0QPV6T2DJHHJAYY7Z: 10",
            "01JW3VG1BGDFV5HJEBBSEPMKJJ: 10",
            "01JW49YR00EEG28B6GXBMZRPYH: 9",
            "01JW3T5C40EJ6XCAJAYW2X5CDN: 8",
            "01JW3TERX04HP6P1YZW707YJWN: 8",
            "01JW3TNDSG2R3JC4CMXFX4G9PF: 8",
            "01JW47Q21RM92MZKKRP659VY3E: 8",
            "01JW47P3S0GCWSABT2B69SJKKA: 7",
            "01JW3S4BFGEJXJY7JTXH31SYQT: 6",
            "01JW3TG6SRNR6RW9RESKDYE37M: 6",
            "01JW47GM00GBSD1WPB25NSHTKR: 6",
            "01JW3MH8EG2M5NZHW57Z14HC18: 5",
            "01JW47K240HE3XW151GJF0ZWSS: 5",
            "01JW3J0JDG7NPMM8J6AV51YDEK: 2"
        ],
        "leaves": 58
    }
]

@cloud_manul @amin @rl_dane @tripplehelix @alatartheblue @kudzu @dmoonfire @thedoctor @krafter @clayton @roguefoam @fbievan @orbitalmartian @joel @dm @sotolf @btp @adamsdesk @jlw_the_jobber @gorkmo note this also works for multiple starting points, for which you can use WHERE id IN (…) or WHERE thread_id IN (…) or even WHERE id IN (…) OR thread_id IN (…) (the duplication is necessary; while one can combine the search in PostgreSQL, the combined search cannot use the indicēs and is dead slow) if you have either a post ID (like https://semaphore.social/statuses/xxx) or a GtS 0.19+ DB thread ID, thanks to use of UNION ipv UNION ALL in the “findtop” query (which just goes from an arbitrary point (or more than one) in the thread to its starting point a.k.a. the OP), and it’ll show you the information for multiple threads separately, for example…

gotosocial=> WITH RECURSIVE
gotosocial->     findtop AS (
gotosocial(>         SELECT id, in_reply_to_id FROM statuses
gotosocial(>         -- can use thread_id and/or multiple values here:
gotosocial(> WHERE id IN ('01JHC4Q1RXD9XBR3ESVQ2XT6QS', '01JW4BKHEGG216D56XXNC50MJW') OR thread_id IN ('01JHC4Q1RXD9XBR3ESVQ2XT6QS', '01JW4BKHEGG216D56XXNC50MJW')
gotosocial(>         UNION
gotosocial(>         SELECT s.id, s.in_reply_to_id
gotosocial(>         FROM statuses s INNER JOIN findtop f ON s.id = f.in_reply_to_id
gotosocial(>     ),
gotosocial->     threads AS (
gotosocial(>         SELECT id, in_reply_to_id, 1 AS depth, id AS op FROM findtop
gotosocial(>         WHERE in_reply_to_id IS NULL
gotosocial(>         UNION ALL
gotosocial(>         SELECT s.id, s.in_reply_to_id, t.depth + 1, t.op
gotosocial(>         FROM statuses s INNER JOIN threads t ON s.in_reply_to_id = t.id
gotosocial(>     ),
gotosocial->     counts AS (
gotosocial(>         SELECT op, COUNT(*) AS count FROM threads GROUP BY op ORDER BY op
gotosocial(>     ),
gotosocial->     leaves AS (
gotosocial(>         SELECT id, depth, op FROM threads WHERE NOT EXISTS (
gotosocial(>                 SELECT * FROM statuses s WHERE s.in_reply_to_id = threads.id)
gotosocial(>         ORDER BY depth DESC, id ASC
gotosocial(>     ),
gotosocial->     jleaves AS (
gotosocial(>         SELECT op, to_jsonb(array_agg(id || ': ' || depth)) AS leaves FROM leaves GROUP BY op
gotosocial(>     ),
gotosocial->     jthreads AS (
gotosocial(>         SELECT jsonb_build_object('OP', j.op, 'TOOTS', c.count, 'leaves',  jsonb_array_length(j.leaves), 'depth', j.leaves) AS t
gotosocial(>         FROM jleaves j INNER JOIN counts c USING (op) ORDER BY j.op
gotosocial(>     )
gotosocial-> SELECT jsonb_pretty(to_jsonb(array_agg(t))) FROM jthreads;
jsonb_pretty
[
    {
        "OP": "01JHBSJABRE18TSGTNPT0RYBWD",
        "TOOTS": 258,
        "depth": [
            "01JHCC64RR1T09R50TS5REB4CV: 43",
            "01JHCCJWZ8VPCKKKBKMCQ8ESAB: 43",
            "01JHCCXBY0403MN91HH8NZGZJJ: 43",
            "01JHCCPVXRHB9CK422DNWV83J4: 42",
            "01JHCC9C98126988JZ8SC251EB: 41",
            "01JHCCM418V2Q9VBQ8EP0G4SK2: 41",
            "01JHCCND1R4NS0EKPNS8BRSMHV: 41",
            "01JHCBWSY8H3TYKAZVJ7B99XYB: 39",
            "01JHCBXP8G43JDAJYACWKYYMQ5: 39",
            "01JHCC40D849JW3EQDY1AMR8VZ: 39",
            "01JHCEK8NWPJZ1TMKF4F95WB3Y: 39",
            "01JHCCPP282JXHMAV7PQ643EF8: 38",
            "01JHCEEP8CDRWQXKYTCFANCWCY: 38",
            "01JHG4WBK038180C5Z606CRKB3: 38",
            "01JHCBHVBGD4GC3XND3YTFHDX4: 37",
            "01JHCBJHT8F8M8VKPGC9G8S7F3: 37",
            "01JHCB44W8NEEFC1GQDB2N0RQQ: 36",
            "01JHCANJ33DQKK9V0V9NE3283Q: 34",
            "01JHCB3N8809R3EJF47R3QBS6T: 34",
            "01JHCBDFPRR5RBCNMVJ0VC1YHA: 34",
            "01JHEA5PJ53DKFKMJ9KA44A6H0: 34",
            "01JHEFA34RF7JS21WKD440JZHH: 34",
            "01JHES5XW6DW8EKZC29F286F1W: 34",
            "01JHHEQB80BKJ43FGDJ2H4CPGW: 34",
            "01JHCA9PQN6ZH715MQZ5J36RN2: 33",
            "01JHCAF2TXTW7BQRE8C7YQYAGE: 33",
            "01JHCAMB0RJRQF3KRJTKQNDZ02: 33",
            "01JHCARZERY23P10GPFGTKH5AQ: 33",
            "01JHHRN64RFYQZC8HHVJ3NWVFS: 33",
            "01JHCAEEHGW8JKE1PECVVW3YC2: 32",
            "01JHCAGNTRKHZY0BBK7SRX17JG: 32",
            "01JHCAJ5P09CFVJGW66FNCDX6T: 31",
            "01JHCG5EA502J9P5T0VHPTFMCN: 31",
            "01JHE8EETGM75RCQDJ0RK6618J: 31",
            "01JHC9X4VHSQQA4YT1HMA6NY8T: 30",
            "01JHCA4C90T4PS7NP86XG5MGCJ: 29",
            "01JHCAEG40AQF4YD89ZYGY4G88: 29",
            "01JHCESMNRYD8HJEVAD5HYHM20: 29",
            "01JHE5SF5YEVN2QEA23611C96Y: 29",
            "01JHC9W7H8FBP3V0CASXE6Z12A: 28",
            "01JHC9YMP06CXH0W7XBRE3S51W: 28",
            "01JHCA5W485ZM7A9CG9NE9151M: 28",
            "01JHC9JQTG5Q9VPAC6TERTBAMQ: 27",
            "01JHC9W9FR50R0XRQ19PEDW0AW: 27",
            "01JHC9YJQGKZEHGNFT3FVG3176: 27",
            "01JHC9JTR8P6HJ15S56N5E1GD5: 26",
            "01JHC9D260DWZPQA8YVQGAZJP7: 25",
            "01JHC9KS103SNCN1ERF9T1TH0D: 25",
            "01JHC9NJMRHXA9G8A2FT3QTJWG: 25",
            "01JHC9P10Z7G2SB76KHMQ5Q93J: 24",
            "01JHC68M8CWY5YQRZDK1S77GD0: 18",
            "01JHC8Z1Y8PA3Q9WYZDAT5ZCND: 18",
            "01JHC5WZR9WEEPGYXAJGFDWEJH: 17",
            "01JHC5H2QXQ6Y5G35WF7VSBPQ2: 16",
            "01JHC524W061BVBS0VP3M7EB7Y: 15",
            "01JHC5BHER0VYKR1G2APZES1JA: 15",
            "01JHC82A0R1XFBC97FFCYF08BD: 15",
            "01JHC8KT963NED0WTCEWA03PB3: 15",
            "01JHG8SFG0RW6W9FXGEGETN9HN: 15",
            "01JHC7ZRZ0ZFQM4YJS56X1FPER: 13",
            "01JHC4PRKRRF7VGX1X62DDQQBV: 12",
            "01JHG8DBSRQPJN48PG6SCE9CK9: 12",
            "01JHC7W0V8JPE1ZXXN2RDJD1XV: 11",
            "01JHC7XPJ08YEMTD6JMTR4K10T: 11",
            "01JHC43EEG0YJ3KGYNR1RW6BZ2: 10",
            "01JHC2F6JGXZPNM1SQ5W0FX70S: 7",
            "01JHC2EYRGDHPXED5W2RHSAPQE: 6",
            "01JHG018PGTCD65Z16MBMTSA2G: 5"
        ],
        "leaves": 68
    },
    {
        "OP": "01JW4BKHEGG216D56XXNC50MJW",
        "TOOTS": 10,
        "depth": [
            "01JW4D30080K16JM4XWMJ1BG4W: 3",
            "01JW4DD478G4HX9JA6NMPPETK8: 3",
            "01JW4BQ4P0GMD9KBX51XDF4YVC: 2",
            "01JW4BSTM0FTB630JF9F1SMMHW: 2",
            "01JW4C266GDV3DJDD6M79MZ2DQ: 2",
            "01JW4C682RZCJBFKDCXHZPT7ZD: 2",
            "01JW4C9JH0KW0GTTABWP6VD33B: 2"
        ],
        "leaves": 7
    }
]

(this example uses a post ID and a thread ID it turns out)

But one (as instance operator) can map one’s own instance’s IDs with:

gotosocial=> SELECT url FROM statuses WHERE id='01JHBSJABRE18TSGTNPT0RYBWD';

https://polymaths.social/@rl_dane/statuses/01JHBSJAG7MD2ECAVVKVY9Z8BJ

(There’s also uri in case the one from url doesn’t work… grr in the general direction of some weird instance softwares where one works but not the other.)