nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpqkr85r3xf07he4ccf98a7826v3cafxmw4w88shjrrndp3304fgehq20063n (nprofile…063n)
Nope explain doesn't tell you which index you should create. It just tells you what the query planner does.
BohwaZ
npub1hp…nmvk9
2026-03-01 20:32:47 UTC
in reply to nevent1q…y8g3
Author Public Key
npub1hpdykez8m76fa4ackmyz7wdqedgzg06kfpdqlclqswqnqak9xw9q2nmvk9Seen on
wss://relay.ditto.pubPublished at
2026-03-01 20:32:47 UTCEvent JSON
{
"id": "6cf6fa92a2dacacfe34489787f3bba10ed2783707be19f096f3f070c69397864",
"pubkey": "b85a4b6447dfb49ed7b8b6c82f39a0cb50243f56485a0fe3e083813076c5338a",
"created_at": 1772397167,
"kind": 1,
"tags": [
[
"p",
"b0cf41c4c97faf9ae30929fbe3ab4c8e3a936dd571cf0bc8639b4318bea9466e",
"wss://relay.ditto.pub"
],
[
"p",
"3b5cfa5901da20cbdde156de05d924297910d9a5d791f6693cce48072cd611a5",
"wss://relay.ditto.pub"
],
[
"e",
"dcc0293de90b4e0922fc11ec8f4e2bd3a22d8abf2bcb7d957cd5e4f1a17e3a2c",
"wss://relay.ditto.pub",
"reply"
],
[
"proxy",
"https://mamot.fr/users/bohwaz/statuses/116155820765288127",
"activitypub"
],
[
"client",
"Mostr",
"31990:6be38f8c63df7dbf84db7ec4a6e6fbbd8d19dca3b980efad18585c46f04b26f9:mostr",
"wss://relay.ditto.pub"
]
],
"content": "nostr:nprofile1qy2hwumn8ghj7un9d3shjtnyd968gmewwp6kyqpqkr85r3xf07he4ccf98a7826v3cafxmw4w88shjrrndp3304fgehq20063n\nNope explain doesn't tell you which index you should create. It just tells you what the query planner does.",
"sig": "b14d248f2bc974b3045ac73664ea6c9acf4c0ea200f8b1f224b2d179c11861ed1ace033f857ef2c816529159d67297c5985168e36a68cc0937af832780946b1d"
}