lainy (nprofile…hmru) nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqcnzueayt70cpsg82adtku6amtyejwuhhshu4c7vcp9h6vgc8rqmqszdq6p (nprofile…dq6p) we do gotta confront the bad query plans because of statistics tho. I just realized there's a manual way to work around it if you can identify it and I don't recall seeing this in our schema
https://pganalyze.com/blog/5mins-postgres-planner-jsonb-selectivity
feld /
npub1c5…fh8gn
2025-02-22 08:26:47
in reply to nevent1q…rq3s
Author Public Key
npub1c5tlngqj4f9f3lkxnu2swe98pem78ss6xf380ldh3rlrm595zrustfh8gnSeen on
wss://relay.mostr.pubPublished at
2025-02-22 08:26:47Event JSON
{
"id": "8abeb6e37dce0eb8be54a0c96a50a584a68d8d589b0efdd055ead249c56abeb5",
"pubkey": "c517f9a012aa4a98fec69f150764a70e77e3c21a326277fdb788fe3dd0b410f9",
"created_at": 1740212807,
"kind": 1,
"tags": [
[
"p",
"776ed1a547e2693a2c964e4824d6306a11aa364cd9c798f3e1ccd638af3d3725",
"wss://relay.mostr.pub"
],
[
"p",
"c4c5ccf48bf3f01820eaeb576e6bbb59332772f785f95c7998096fa623071836",
"wss://relay.mostr.pub"
],
[
"p",
"90cce09a83fbf5df37e416948994d04fe694a0f04dae2b5b795c81e8c53357f4",
"wss://relay.mostr.pub"
],
[
"zap",
"c517f9a012aa4a98fec69f150764a70e77e3c21a326277fdb788fe3dd0b410f9",
"wss://relay.mostr.pub",
"0.915"
],
[
"zap",
"6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9",
"wss://relay.mostr.pub",
"0.085"
],
[
"e",
"38df7b0c3d32f2ac83832ee5316e52c39bcca172645ac2c73000d482c19d6855",
"wss://relay.mostr.pub",
"reply"
],
[
"proxy",
"https://friedcheese.us/objects/09f80a25-947a-41a7-94e9-6b08e9ce4a0a",
"activitypub"
]
],
"content": "nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqwahdrf28uf5n5tykfeyzf43sdgg65djvm8re3ulpentr3teaxujsnyhmru nostr:nprofile1qy2hwumn8ghj7un9d3shjtnddaehgu3wwp6kyqpqcnzueayt70cpsg82adtku6amtyejwuhhshu4c7vcp9h6vgc8rqmqszdq6p we do gotta confront the bad query plans because of statistics tho. I just realized there's a manual way to work around it if you can identify it and I don't recall seeing this in our schema\n\nhttps://pganalyze.com/blog/5mins-postgres-planner-jsonb-selectivity",
"sig": "0ba8654660a109c0556d0f022d07ad8e28058b16ec8588479fe138673d8c67acb855e21e7f0c2f988bea7f9ebacea15b5004e9f69ae779e301d82799adb431db"
}