It’s been a week since I’ve had to do a major attitude adjustment.

I’ve created tons of local comments on this server to try and figure out what is going on with performance that lemmy.world is still blocking all comment links: https://lemmy.world/post/2697806

I really wish developer would have rushed in a fix for the ampersand munging in URL and other content… a lot of links now on Lemmy are broken because of the damage to the URL.

  • RoundSparrow @ BTOPM
    1•1 year ago
                                                    "Plans": [
                                                  {
                                                    "Node Type": "Nested Loop",
                                                    "Parent Relationship": "Outer",
                                                    "Parallel Aware": false,
                                                    "Async Capable": false,
                                                    "Join Type": "Left",
                                                    "Startup Cost": 10.18,
                                                    "Total Cost": 1208.32,
                                                    "Plan Rows": 57,
                                                    "Plan Width": 3099,
                                                    "Actual Startup Time": 0.189,
                                                    "Actual Total Time": 16.959,
                                                    "Actual Rows": 606,
                                                    "Actual Loops": 1,
                                                    "Inner Unique": true,
                                                    "Join Filter": "((post_aggregates.community_id = community_person_ban.community_id) AND (community_person_ban.person_id = post_aggregates.creator_id))",
                                                    "Rows Removed by Join Filter": 2424,
                                                    "Shared Hit Blocks": 3507,
                                                    "Shared Read Blocks": 2126,
                                                    "Shared Dirtied Blocks": 11,
                                                    "Shared Written Blocks": 0,
                                                    "Local Hit Blocks": 0,
                                                    "Local Read Blocks": 0,
                                                    "Local Dirtied Blocks": 0,
                                                    "Local Written Blocks": 0,
                                                    "Temp Read Blocks": 0,
                                                    "Temp Written Blocks": 0,
    • RoundSparrow @ BTOPM
      1•1 year ago

      Join Filter": “((post_aggregates.community_id = community_person_ban.community_id) AND (community_person_ban.person_id = post_aggregates.creator_id))”,

      “Rows Removed by Join Filter”: 2424,