[{"_1":2,"_2811":-5,"_2812":-5},"loaderData",{"_3":4,"_12":13},"root",{"_5":6,"_7":8,"_9":10,"_11":10},"isProd",true,"enableStats",false,"domain","nodosdeconocimiento.es","siteHost","routes/$",{"_14":15,"_2433":2434},"json",{"_16":17,"_18":19,"_20":21,"_22":-5,"_23":-5,"_24":8,"_25":-5,"_26":27,"_863":6,"_37":864,"_877":878,"_879":880,"_2418":2419,"_2420":6,"_11":2421,"_2422":2421,"_2423":2424,"_2428":2429},"prefersLanguages",[],"viewTerm","activity","panelParam","activity/citations","openComment","accountUid","isInspect","inspectTab","document",{"_28":29,"_839":40,"_840":841,"_842":843,"_845":846,"_847":848,"_849":848,"_850":851,"_854":855,"_856":40,"_857":858,"_861":862},"content",[30,60,93,254,335,412,489,532,683,764],{"_31":32,"_33":34},"children",[],"block",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_58":59,"_56":57},"type","Paragraph","id","y9oOlsGl","revision","bafyreid24v4m2ixrkrkihakmnh5fb664eremwfyych2dr263k6bokbofsq","attributes",{},"annotations",[45],{"_35":46,"_47":48,"_51":52,"_41":55,"_56":57},"Code","starts",[49,50],43,84,"ends",[53,54],79,97,{},"link","","text","Performance report from fresh snapshots at http://localhost:58001/debug/network and /debug/sqlite.",{"_31":61,"_33":85},[62,78],{"_31":63,"_33":64},[],{"_35":36,"_37":65,"_39":40,"_41":66,"_43":67,"_58":77,"_56":57},"xGjKo9vH",{},[68],{"_35":69,"_47":70,"_51":73,"_41":76,"_56":57},"Bold",[71,72],11,99,[74,75],59,129,{},"The app is not currently blocked by SQLite lock/busy errors. The main performance problem is still network/discovery sync latency, especially waiting on already-connected peer syncs.",{"_31":79,"_33":80},[],{"_35":36,"_37":81,"_39":40,"_41":82,"_43":83,"_58":84,"_56":57},"3ljCdm88",{},[],"The daemon is doing lots of peer sync attempts; many fail or get preempted, and the successful path often waits seconds.",{"_35":86,"_37":87,"_39":40,"_41":88,"_43":91,"_58":92,"_56":57},"Heading","VqtCtM8j",{"_89":90},"childrenType","Group",[],"Executive summary",{"_31":94,"_33":249},[95,134,236],{"_31":96,"_33":97},[],{"_35":36,"_37":98,"_39":40,"_41":99,"_43":100,"_58":133,"_56":57},"tgMU7Duk",{},[101,119],{"_35":69,"_47":102,"_51":110,"_41":118,"_56":57},[103,104,105,106,107,108,109],71,114,136,154,240,270,302,[111,112,113,114,115,116,117],75,115,139,161,246,276,309,{},{"_35":46,"_47":120,"_51":126,"_41":132,"_56":57},[121,122,123,124,125],87,101,187,220,251,[127,128,129,130,131],98,111,215,227,258,{},"| Signal | Current state | |---|---:| | Write transactions in flight | None | | Recent SQLITE_BUSY / begin_busy | 0 | | WAL file size | 0 B | | DB size | 4.0 GiB | | Worst write caller | blob.(*Index).PutMany-range1 | | PutMany p99 total | 458 ms | | PutMany p99 hold | 120 ms | | WAL checkpoint p99 | 17.6 ms |",{"_31":135,"_33":231},[136,143,150,163,170],{"_31":137,"_33":138},[],{"_35":36,"_37":139,"_39":40,"_41":140,"_43":141,"_58":142,"_56":57},"hHOPNAve",{},[],"No active writer lock.",{"_31":144,"_33":145},[],{"_35":36,"_37":146,"_39":40,"_41":147,"_43":148,"_58":149,"_56":57},"R9Kb6K7i",{},[],"No recent busy timeout events.",{"_31":151,"_33":152},[],{"_35":36,"_37":153,"_39":40,"_41":154,"_43":155,"_58":162,"_56":57},"pbV_LbQ_",{},[156],{"_35":46,"_47":157,"_51":159,"_41":161,"_56":57},[158],20,[160],22,{},"WAL is truncated to 0B, so there is no large WAL backlog.",{"_31":164,"_33":165},[],{"_35":36,"_37":166,"_39":40,"_41":167,"_43":168,"_58":169,"_56":57},"_K5tc2Pa",{},[],"Writes are present, but not dominating wall time.",{"_31":171,"_33":225},[172,191,207],{"_31":173,"_33":174},[],{"_35":36,"_37":175,"_39":40,"_41":176,"_43":177,"_58":190,"_56":57},"h6lSpmR2",{},[178,184],{"_35":46,"_47":179,"_51":181,"_41":183,"_56":57},[180],0,[182],12,{},{"_35":69,"_47":185,"_51":187,"_41":189,"_56":57},[186],18,[188],24,{},"ListAccounts p99: 328 ms",{"_31":192,"_33":193},[],{"_35":36,"_37":194,"_39":40,"_41":195,"_43":196,"_58":206,"_56":57},"s7fvSfp_",{},[197,201],{"_35":46,"_47":198,"_51":199,"_41":200,"_56":57},[180],[186],{},{"_35":69,"_47":202,"_51":203,"_41":205,"_56":57},[188],[204],30,{},"ListEntityMentions p99: 289 ms",{"_31":208,"_33":209},[],{"_35":36,"_37":210,"_39":40,"_41":211,"_43":212,"_58":224,"_56":57},"PVfLmqcI",{},[213,218],{"_35":46,"_47":214,"_51":215,"_41":217,"_56":57},[180],[216],27,{},{"_35":69,"_47":219,"_51":221,"_41":223,"_56":57},[220],33,[222],39,{},"syncing.(*Server).loadStore p99: 156 ms",{"_35":36,"_37":226,"_39":40,"_41":227,"_43":229,"_58":230,"_56":57},"kh53vex5",{"_89":228},"Unordered",[],"Some reads are moderately slow:",{"_35":36,"_37":232,"_39":40,"_41":233,"_43":234,"_58":235,"_56":57},"Mv59vQy5",{"_89":228},[],"SQLite looks mostly healthy right now:",{"_31":237,"_33":238},[],{"_35":36,"_37":239,"_39":40,"_41":240,"_43":241,"_58":248,"_56":57},"G9VoX1XM",{},[242],{"_35":69,"_47":243,"_51":245,"_41":247,"_56":57},[244],4,[246],83,{},"So: SQLite is contributing some latency, but it is not the current main bottleneck.",{"_35":86,"_37":250,"_39":40,"_41":251,"_43":252,"_58":253,"_56":57},"RkWxGXJn",{"_89":90},[],"SQLite health",{"_31":255,"_33":330},[256,296,316],{"_31":257,"_33":258},[],{"_35":36,"_37":259,"_39":40,"_41":260,"_43":261,"_58":295,"_56":57},"wsfQNVdh",{},[262,281],{"_35":69,"_47":263,"_51":271,"_41":280,"_56":57},[264,72,265,266,267,107,268,269,270],68,131,164,202,263,295,326,[272,273,274,275,276,277,108,278,279],73,105,138,171,209,247,301,332,{},{"_35":46,"_47":282,"_51":288,"_41":294,"_56":57},[283,284,285,286,287],78,110,143,186,224,[289,290,291,292,293],92,124,157,195,233,{},"| Signal | Current state | |---|---:| | Daemon uptime in snapshot | 3m50s | | connected_sync p50 | 4.02 s | | connected_sync p90 | 18.51 s | | connected_sync p99 | 21.09 s | | Discovery connected p50 | 17.34 s | | Discovery connected p99 | 21.29 s | | Dial p99 | 10.85 s | | Reconcile RPC p99 | 1.96 s | | Bitswap fetch p99 | 313 ms |",{"_31":297,"_33":310},[298],{"_31":299,"_33":300},[],{"_35":36,"_37":301,"_39":40,"_41":302,"_43":303,"_58":309,"_56":57},"-LGXBSBS",{},[304],{"_35":46,"_47":305,"_51":306,"_41":308,"_56":57},[180],[307],14,{},"connected_sync: reconcile + download from connected peers, and it waits for all of them.",{"_35":36,"_37":311,"_39":40,"_41":312,"_43":314,"_58":315,"_56":57},"v8WapwEd",{"_89":313},"Blockquote",[],"The bad user-visible delay is:",{"_31":317,"_33":318},[],{"_35":36,"_37":319,"_39":40,"_41":320,"_43":321,"_58":329,"_56":57},"50z1_rGC",{},[322],{"_35":69,"_47":323,"_51":326,"_41":328,"_56":57},[324,325],26,55,[327,264],35,{},"That phase has p50 around 4 seconds and p90/p99 around 18–21 seconds.",{"_35":86,"_37":331,"_39":40,"_41":332,"_43":333,"_58":334,"_56":57},"2Xh0eXAT",{"_89":90},[],"Network / sync performance",{"_31":336,"_33":407},[337,359],{"_31":338,"_33":339},[],{"_35":36,"_37":340,"_39":40,"_41":341,"_43":342,"_58":358,"_56":57},"wCh9ENhc",{},[343],{"_35":69,"_47":344,"_51":350,"_41":357,"_56":57},[345,346,347,284,348,349],38,61,82,130,155,[351,352,353,354,355,356],42,65,85,113,133,156,{},"| Outcome | Count | |---|---:| | ok | 1210 | | dial_failed | 3272 | | preempted | 852 | | protocol_mismatch | 243 | | rpc_error | 102 | | putmany_failed | 0 |",{"_31":360,"_33":402},[361,372,383,395],{"_31":362,"_33":363},[],{"_35":36,"_37":364,"_39":40,"_41":365,"_43":366,"_58":371,"_56":57},"jjykqOSt",{},[367],{"_35":46,"_47":368,"_51":369,"_41":370,"_56":57},[180],[186],{},"putmany_failed = 0, so SQLite writes are not failing.",{"_31":373,"_33":374},[],{"_35":36,"_37":375,"_39":40,"_41":376,"_43":377,"_58":382,"_56":57},"z6iqjaL-",{},[378],{"_35":46,"_47":379,"_51":380,"_41":381,"_56":57},[180],[186],{},"dial_failed = 3272, very high.",{"_31":384,"_33":385},[],{"_35":36,"_37":386,"_39":40,"_41":387,"_43":388,"_58":394,"_56":57},"OijsQyaA",{},[389],{"_35":46,"_47":390,"_51":391,"_41":393,"_56":57},[180],[392],15,{},"preempted = 852, also high.",{"_31":396,"_33":397},[],{"_35":36,"_37":398,"_39":40,"_41":399,"_43":400,"_58":401,"_56":57},"P3WYfdSG",{},[],"Many peer sync attempts are wasted or cancelled.",{"_35":36,"_37":403,"_39":40,"_41":404,"_43":405,"_58":406,"_56":57},"v9feG5Av",{"_89":228},[],"This is important:",{"_35":86,"_37":408,"_39":40,"_41":409,"_43":410,"_58":411,"_56":57},"zCbi_IN9",{"_89":90},[],"Sync outcomes",{"_31":413,"_33":484},[414,434,441],{"_31":415,"_33":416},[],{"_35":36,"_37":417,"_39":40,"_41":418,"_43":419,"_58":433,"_56":57},"EI7yM3bW",{},[420],{"_35":69,"_47":421,"_51":427,"_41":432,"_56":57},[422,128,423,424,425,426],70,147,174,212,249,[53,428,349,429,430,431],120,181,219,264,{},"| Signal | Current state | |---|---:| | Total traffic since startup | 214.6 MiB | | HTTP server loopback out | 188.7 MiB | | libp2p remote total | 24.7 MiB | | SQLite grew | 3.0 MiB | | Bitswap unique received | 4.5 MiB | | Duplicate bitswap data | 33.4 KiB / 0.7% |",{"_31":435,"_33":436},[],{"_35":36,"_37":437,"_39":40,"_41":438,"_43":439,"_58":440,"_56":57},"xQ4rI6Ib",{},[],"Most traffic is local frontend/backend gRPC-Web loopback, not external network.",{"_31":442,"_33":479},[443,450,461,468],{"_31":444,"_33":445},[],{"_35":36,"_37":446,"_39":40,"_41":447,"_43":448,"_58":449,"_56":57},"3x9yJ_fP",{},[],"Fetches complete.",{"_31":451,"_33":452},[],{"_35":36,"_37":453,"_39":40,"_41":454,"_43":455,"_58":460,"_56":57},"qGSs-wlt",{},[456],{"_35":69,"_47":457,"_51":458,"_41":459,"_56":57},[160],[324],{},"Completeness ratio is 1.00.",{"_31":462,"_33":463},[],{"_35":36,"_37":464,"_39":40,"_41":465,"_43":466,"_58":467,"_56":57},"-SE-RQBr",{},[],"Duplicate waste is low.",{"_31":469,"_33":470},[],{"_35":36,"_37":471,"_39":40,"_41":472,"_43":473,"_58":478,"_56":57},"nJwCYbgw",{},[474],{"_35":46,"_47":475,"_51":476,"_41":477,"_56":57},[180],[186],{},"putmany_failed = 0.",{"_35":36,"_37":480,"_39":40,"_41":481,"_43":482,"_58":483,"_56":57},"YHiaTEwu",{"_89":228},[],"Bitswap itself looks healthy:",{"_35":86,"_37":485,"_39":40,"_41":486,"_43":487,"_58":488,"_56":57},"J2GSCeKi",{"_89":90},[],"Bandwidth / data movement",{"_31":490,"_33":527},[491,498,506,513,520],{"_31":492,"_33":493},[],{"_35":36,"_37":494,"_39":40,"_41":495,"_43":496,"_58":497,"_56":57},"XtJd2Yy-",{},[],"Current bottleneck is:",{"_31":499,"_33":500},[],{"_35":46,"_37":501,"_39":40,"_41":502,"_43":504,"_58":505,"_56":57},"nU1REnIj",{"_503":58},"language",[],"Frontend asks daemon for document/content\n ↓\nDaemon runs discovery\n ↓\nDaemon syncs with many peers\n ↓\nMany peer syncs dial-fail, timeout, preempt, or take seconds\n ↓\nconnected_sync waits too long\n ↓\nUser sees slow app\n",{"_31":507,"_33":508},[],{"_35":36,"_37":509,"_39":40,"_41":510,"_43":511,"_58":512,"_56":57},"6cNyrmDf",{},[],"Not:",{"_31":514,"_33":515},[],{"_35":46,"_37":516,"_39":40,"_41":517,"_43":518,"_58":519,"_56":57},"8OHUywuZ",{"_503":58},[],"SQLite locked\n",{"_31":521,"_33":522},[],{"_35":36,"_37":523,"_39":40,"_41":524,"_43":525,"_58":526,"_56":57},"nRjwK-SW",{},[],"At least in this snapshot, SQLite is not locked.",{"_35":86,"_37":528,"_39":40,"_41":529,"_43":530,"_58":531,"_56":57},"eQIExFJt",{"_89":90},[],"Likely bottleneck",{"_31":533,"_33":677},[534,567,597,626],{"_31":535,"_33":558},[536,547],{"_31":537,"_33":538},[],{"_35":36,"_37":539,"_39":40,"_41":540,"_43":541,"_58":546,"_56":57},"w-_TaUKd",{},[542],{"_35":46,"_47":543,"_51":544,"_41":545,"_56":57},[180],[216],{},"connected_sync p90 = 18.51s",{"_31":548,"_33":549},[],{"_35":36,"_37":550,"_39":40,"_41":551,"_43":552,"_58":557,"_56":57},"vGsBtPgX",{},[553],{"_35":46,"_47":554,"_51":555,"_41":556,"_56":57},[180],[216],{},"connected_sync p99 = 21.09s",{"_35":36,"_37":559,"_39":40,"_41":560,"_43":561,"_58":566,"_56":57},"8yBb0af_",{"_89":228},[562],{"_35":69,"_47":563,"_51":564,"_41":565,"_56":57},[180],[345],{},"Discovery waits too long on peer syncs",{"_31":568,"_33":587},[569,580],{"_31":570,"_33":571},[],{"_35":36,"_37":572,"_39":40,"_41":573,"_43":574,"_58":579,"_56":57},"1QvULobm",{},[575],{"_35":46,"_47":576,"_51":577,"_41":578,"_56":57},[180],[186],{},"dial_failed = 3272",{"_31":581,"_33":582},[],{"_35":36,"_37":583,"_39":40,"_41":584,"_43":585,"_58":586,"_56":57},"H6CIf_cG",{},[],"more failures than successful syncs.",{"_35":36,"_37":588,"_39":40,"_41":589,"_43":590,"_58":596,"_56":57},"fV_SvFqY",{"_89":228},[591],{"_35":69,"_47":592,"_51":593,"_41":595,"_56":57},[180],[594],29,{},"Too many failed peer attempts",{"_31":598,"_33":617},[599,610],{"_31":600,"_33":601},[],{"_35":36,"_37":602,"_39":40,"_41":603,"_43":604,"_58":609,"_56":57},"8-IoWK9Y",{},[605],{"_35":46,"_47":606,"_51":607,"_41":608,"_56":57},[180],[392],{},"preempted = 852",{"_31":611,"_33":612},[],{"_35":36,"_37":613,"_39":40,"_41":614,"_43":615,"_58":616,"_56":57},"e5zSNJhB",{},[],"suggests work starts, then gets cancelled before useful completion.",{"_35":36,"_37":618,"_39":40,"_41":619,"_43":620,"_58":625,"_56":57},"o38o4-5y",{"_89":228},[621],{"_35":69,"_47":622,"_51":623,"_41":624,"_56":57},[180],[186],{},"Preemption is high",{"_31":627,"_33":668},[628,641,648,661],{"_31":629,"_33":630},[],{"_35":36,"_37":631,"_39":40,"_41":632,"_43":633,"_58":640,"_56":57},"ZEV6bHqb",{},[634],{"_35":46,"_47":635,"_51":637,"_41":639,"_56":57},[636],3,[638],13,{},"no begin_busy",{"_31":642,"_33":643},[],{"_35":36,"_37":644,"_39":40,"_41":645,"_43":646,"_58":647,"_56":57},"DQJ-_uVd",{},[],"no in-flight writer",{"_31":649,"_33":650},[],{"_35":36,"_37":651,"_39":40,"_41":652,"_43":653,"_58":660,"_56":57},"oSYM5G_G",{},[654],{"_35":46,"_47":655,"_51":657,"_41":659,"_56":57},[656],7,[658],9,{},"WAL is 0B",{"_31":662,"_33":663},[],{"_35":36,"_37":664,"_39":40,"_41":665,"_43":666,"_58":667,"_56":57},"_viOPetZ",{},[],"writes are measurable but not the main pain.",{"_35":36,"_37":669,"_39":40,"_41":670,"_43":671,"_58":676,"_56":57},"nIVWWDpF",{"_89":228},[672],{"_35":69,"_47":673,"_51":674,"_41":675,"_56":57},[180],[186],{},"SQLite is okay now",{"_35":86,"_37":678,"_39":40,"_41":679,"_43":681,"_58":682,"_56":57},"xbFyCTen",{"_89":680},"Ordered",[],"What looks wrong",{"_31":684,"_33":759},[685,741],{"_31":686,"_33":736},[687,694,701,708,715,722,729],{"_31":688,"_33":689},[],{"_35":36,"_37":690,"_39":40,"_41":691,"_43":692,"_58":693,"_56":57},"LtGWs92r",{},[],"dedupe concurrent discovery requests for the same resource;",{"_31":695,"_33":696},[],{"_35":36,"_37":697,"_39":40,"_41":698,"_43":699,"_58":700,"_56":57},"lhBOCaZ1",{},[],"reduce number of peers queried per discovery;",{"_31":702,"_33":703},[],{"_35":36,"_37":704,"_39":40,"_41":705,"_43":706,"_58":707,"_56":57},"T915wGE1",{},[],"stop earlier once enough peers answered/found content;",{"_31":709,"_33":710},[],{"_35":36,"_37":711,"_39":40,"_41":712,"_43":713,"_58":714,"_56":57},"9wEvihlx",{},[],"avoid waiting for all connected peer syncs;",{"_31":716,"_33":717},[],{"_35":36,"_37":718,"_39":40,"_41":719,"_43":720,"_58":721,"_56":57},"_8Zpnxq_",{},[],"prioritize historically good peers;",{"_31":723,"_33":724},[],{"_35":36,"_37":725,"_39":40,"_41":726,"_43":727,"_58":728,"_56":57},"zwG6j4er",{},[],"cache negative/positive discovery results briefly;",{"_31":730,"_33":731},[],{"_35":36,"_37":732,"_39":40,"_41":733,"_43":734,"_58":735,"_56":57},"xE4qjrFV",{},[],"reduce frontend query block requests to daemon.",{"_35":36,"_37":737,"_39":40,"_41":738,"_43":739,"_58":740,"_56":57},"U9VkBSTg",{"_89":228},[],"Focus on reducing discovery/network fanout before optimizing SQLite further:",{"_31":742,"_33":743},[],{"_35":36,"_37":744,"_39":40,"_41":745,"_43":746,"_58":758,"_56":57},"equvuEJr",{},[747,752],{"_35":46,"_47":748,"_51":749,"_41":751,"_56":57},[49],[750],50,{},{"_35":69,"_47":753,"_51":755,"_41":757,"_56":57},[754],118,[756],146,{},"SQLite should still be watched, especially PutMany and slow reads, but the current app performance issue is primarily network/discovery contention, not SQLite lock contention.",{"_35":86,"_37":760,"_39":40,"_41":761,"_43":762,"_58":763,"_56":57},"sB0cwJrs",{"_89":90},[],"Recommendation to discuss with team",{"_31":765,"_33":834},[766],{"_31":767,"_33":815},[768,779,793,808],{"_31":769,"_33":770},[],{"_35":36,"_37":771,"_39":40,"_41":772,"_43":773,"_58":778,"_56":57},"Nbu5qY13",{},[774],{"_35":46,"_47":775,"_51":776,"_41":777,"_56":57},[244,186],[71,158],{},"DB: 4.0 GiB; WAL: 0B.",{"_31":780,"_33":781},[],{"_35":36,"_37":782,"_39":40,"_41":783,"_43":784,"_58":792,"_56":57},"VgXxQ4-Y",{},[785],{"_35":46,"_47":786,"_51":788,"_41":791,"_56":57},[188,222,787],53,[789,790,74],31,45,{},"Worst SQLite write p99: PutMany around 458 ms total, 120 ms hold.",{"_31":794,"_33":795},[],{"_35":36,"_37":796,"_39":40,"_41":797,"_43":798,"_58":807,"_56":57},"VAgPlZPt",{},[799],{"_35":46,"_47":800,"_51":803,"_41":806,"_56":57},[801,802],34,60,[804,805],48,64,{},"Worst user-visible network phase: connected_sync p99 around 21 s.",{"_31":809,"_33":810},[],{"_35":36,"_37":811,"_39":40,"_41":812,"_43":813,"_58":814,"_56":57},"QtlGvX5O",{},[],"Best next fix area: reduce/dedupe/short-circuit discovery peer sync work.",{"_35":36,"_37":816,"_39":40,"_41":817,"_43":818,"_58":833,"_56":57},"HMROJbUR",{"_89":228},[819],{"_35":46,"_47":820,"_51":827,"_41":832,"_56":57},[821,822,823,824,825,826],41,100,116,201,216,252,[325,128,828,829,830,831],125,211,230,254,{},"The app is currently slow mainly because connected_sync takes seconds to tens of seconds, with many dial_failed and preempted peer syncs. SQLite is not currently locked: no writer in flight, no recent begin_busy, no putmany_failed, and the WAL file is 0B.",{"_35":86,"_37":835,"_39":40,"_41":836,"_43":837,"_58":838,"_56":57},"OvG0ws1r",{"_89":90},[],"Recap","version","account","z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno","authors",[844],"z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou","path","/tech-talks/sql-busy/performance-reports/performance-gabo-laptop-2026-05-26-2022","createTime","2026-05-26T18:22:46.076Z","updateTime","metadata",{"_852":853},"name","Performance Gabo Laptop 2026-05-26 20:22","detachedBlocks",{},"genesis","generationInfo",{"_856":40,"_859":860},"generation","1779819766087","visibility","PUBLIC","isLatest",{"_845":865,"_839":40,"_870":8,"_871":841,"_37":872,"_873":-5,"_874":-5,"_875":-5,"_876":-5},[866,867,868,869],"tech-talks","sql-busy","performance-reports","performance-gabo-laptop-2026-05-26-2022","latest","uid","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sql-busy/performance-reports/performance-gabo-laptop-2026-05-26-2022","blockRef","blockRange","hostname","scheme","siteHomeIcon","ipfs://bafkreibbbufz2nmtqikzu4xilamfp2z77umkmlj5r7h4vqvgydf4gq57rm","dehydratedState",{"_881":882,"_883":884},"mutations",[],"queries",[885,1439,1578,2195,2201,2217,2280,2362,2393],{"_886":887,"_1434":1435,"_1437":1438},"state",{"_888":889,"_1419":1420,"_1421":1422,"_1423":-5,"_1424":180,"_1425":180,"_1426":180,"_1427":-5,"_1428":-5,"_1429":8,"_1430":1431,"_1432":1433},"data",{"_35":26,"_26":890,"_37":1417},{"_28":891,"_839":40,"_840":841,"_842":1413,"_845":846,"_847":848,"_849":848,"_850":1414,"_854":1415,"_856":40,"_857":1416,"_861":862},[892,901,920,1020,1061,1112,1164,1194,1309,1367],{"_31":893,"_33":894},[],{"_35":36,"_37":38,"_39":40,"_41":895,"_43":896,"_58":59,"_56":57},{},[897],{"_35":46,"_47":898,"_51":899,"_41":900,"_56":57},[49,50],[53,54],{},{"_31":902,"_33":917},[903,912],{"_31":904,"_33":905},[],{"_35":36,"_37":65,"_39":40,"_41":906,"_43":907,"_58":77,"_56":57},{},[908],{"_35":69,"_47":909,"_51":910,"_41":911,"_56":57},[71,72],[74,75],{},{"_31":913,"_33":914},[],{"_35":36,"_37":81,"_39":40,"_41":915,"_43":916,"_58":84,"_56":57},{},[],{"_35":86,"_37":87,"_39":40,"_41":918,"_43":919,"_58":92,"_56":57},{"_89":90},[],{"_31":921,"_33":1017},[922,935,1008],{"_31":923,"_33":924},[],{"_35":36,"_37":98,"_39":40,"_41":925,"_43":926,"_58":133,"_56":57},{},[927,931],{"_35":69,"_47":928,"_51":929,"_41":930,"_56":57},[103,104,105,106,107,108,109],[111,112,113,114,115,116,117],{},{"_35":46,"_47":932,"_51":933,"_41":934,"_56":57},[121,122,123,124,125],[127,128,129,130,131],{},{"_31":936,"_33":1005},[937,942,947,956,961],{"_31":938,"_33":939},[],{"_35":36,"_37":139,"_39":40,"_41":940,"_43":941,"_58":142,"_56":57},{},[],{"_31":943,"_33":944},[],{"_35":36,"_37":146,"_39":40,"_41":945,"_43":946,"_58":149,"_56":57},{},[],{"_31":948,"_33":949},[],{"_35":36,"_37":153,"_39":40,"_41":950,"_43":951,"_58":162,"_56":57},{},[952],{"_35":46,"_47":953,"_51":954,"_41":955,"_56":57},[158],[160],{},{"_31":957,"_33":958},[],{"_35":36,"_37":166,"_39":40,"_41":959,"_43":960,"_58":169,"_56":57},{},[],{"_31":962,"_33":1002},[963,976,989],{"_31":964,"_33":965},[],{"_35":36,"_37":175,"_39":40,"_41":966,"_43":967,"_58":190,"_56":57},{},[968,972],{"_35":46,"_47":969,"_51":970,"_41":971,"_56":57},[180],[182],{},{"_35":69,"_47":973,"_51":974,"_41":975,"_56":57},[186],[188],{},{"_31":977,"_33":978},[],{"_35":36,"_37":194,"_39":40,"_41":979,"_43":980,"_58":206,"_56":57},{},[981,985],{"_35":46,"_47":982,"_51":983,"_41":984,"_56":57},[180],[186],{},{"_35":69,"_47":986,"_51":987,"_41":988,"_56":57},[188],[204],{},{"_31":990,"_33":991},[],{"_35":36,"_37":210,"_39":40,"_41":992,"_43":993,"_58":224,"_56":57},{},[994,998],{"_35":46,"_47":995,"_51":996,"_41":997,"_56":57},[180],[216],{},{"_35":69,"_47":999,"_51":1000,"_41":1001,"_56":57},[220],[222],{},{"_35":36,"_37":226,"_39":40,"_41":1003,"_43":1004,"_58":230,"_56":57},{"_89":228},[],{"_35":36,"_37":232,"_39":40,"_41":1006,"_43":1007,"_58":235,"_56":57},{"_89":228},[],{"_31":1009,"_33":1010},[],{"_35":36,"_37":239,"_39":40,"_41":1011,"_43":1012,"_58":248,"_56":57},{},[1013],{"_35":69,"_47":1014,"_51":1015,"_41":1016,"_56":57},[244],[246],{},{"_35":86,"_37":250,"_39":40,"_41":1018,"_43":1019,"_58":253,"_56":57},{"_89":90},[],{"_31":1021,"_33":1058},[1022,1035,1049],{"_31":1023,"_33":1024},[],{"_35":36,"_37":259,"_39":40,"_41":1025,"_43":1026,"_58":295,"_56":57},{},[1027,1031],{"_35":69,"_47":1028,"_51":1029,"_41":1030,"_56":57},[264,72,265,266,267,107,268,269,270],[272,273,274,275,276,277,108,278,279],{},{"_35":46,"_47":1032,"_51":1033,"_41":1034,"_56":57},[283,284,285,286,287],[289,290,291,292,293],{},{"_31":1036,"_33":1046},[1037],{"_31":1038,"_33":1039},[],{"_35":36,"_37":301,"_39":40,"_41":1040,"_43":1041,"_58":309,"_56":57},{},[1042],{"_35":46,"_47":1043,"_51":1044,"_41":1045,"_56":57},[180],[307],{},{"_35":36,"_37":311,"_39":40,"_41":1047,"_43":1048,"_58":315,"_56":57},{"_89":313},[],{"_31":1050,"_33":1051},[],{"_35":36,"_37":319,"_39":40,"_41":1052,"_43":1053,"_58":329,"_56":57},{},[1054],{"_35":69,"_47":1055,"_51":1056,"_41":1057,"_56":57},[324,325],[327,264],{},{"_35":86,"_37":331,"_39":40,"_41":1059,"_43":1060,"_58":334,"_56":57},{"_89":90},[],{"_31":1062,"_33":1109},[1063,1072],{"_31":1064,"_33":1065},[],{"_35":36,"_37":340,"_39":40,"_41":1066,"_43":1067,"_58":358,"_56":57},{},[1068],{"_35":69,"_47":1069,"_51":1070,"_41":1071,"_56":57},[345,346,347,284,348,349],[351,352,353,354,355,356],{},{"_31":1073,"_33":1106},[1074,1083,1092,1101],{"_31":1075,"_33":1076},[],{"_35":36,"_37":364,"_39":40,"_41":1077,"_43":1078,"_58":371,"_56":57},{},[1079],{"_35":46,"_47":1080,"_51":1081,"_41":1082,"_56":57},[180],[186],{},{"_31":1084,"_33":1085},[],{"_35":36,"_37":375,"_39":40,"_41":1086,"_43":1087,"_58":382,"_56":57},{},[1088],{"_35":46,"_47":1089,"_51":1090,"_41":1091,"_56":57},[180],[186],{},{"_31":1093,"_33":1094},[],{"_35":36,"_37":386,"_39":40,"_41":1095,"_43":1096,"_58":394,"_56":57},{},[1097],{"_35":46,"_47":1098,"_51":1099,"_41":1100,"_56":57},[180],[392],{},{"_31":1102,"_33":1103},[],{"_35":36,"_37":398,"_39":40,"_41":1104,"_43":1105,"_58":401,"_56":57},{},[],{"_35":36,"_37":403,"_39":40,"_41":1107,"_43":1108,"_58":406,"_56":57},{"_89":228},[],{"_35":86,"_37":408,"_39":40,"_41":1110,"_43":1111,"_58":411,"_56":57},{"_89":90},[],{"_31":1113,"_33":1161},[1114,1123,1128],{"_31":1115,"_33":1116},[],{"_35":36,"_37":417,"_39":40,"_41":1117,"_43":1118,"_58":433,"_56":57},{},[1119],{"_35":69,"_47":1120,"_51":1121,"_41":1122,"_56":57},[422,128,423,424,425,426],[53,428,349,429,430,431],{},{"_31":1124,"_33":1125},[],{"_35":36,"_37":437,"_39":40,"_41":1126,"_43":1127,"_58":440,"_56":57},{},[],{"_31":1129,"_33":1158},[1130,1135,1144,1149],{"_31":1131,"_33":1132},[],{"_35":36,"_37":446,"_39":40,"_41":1133,"_43":1134,"_58":449,"_56":57},{},[],{"_31":1136,"_33":1137},[],{"_35":36,"_37":453,"_39":40,"_41":1138,"_43":1139,"_58":460,"_56":57},{},[1140],{"_35":69,"_47":1141,"_51":1142,"_41":1143,"_56":57},[160],[324],{},{"_31":1145,"_33":1146},[],{"_35":36,"_37":464,"_39":40,"_41":1147,"_43":1148,"_58":467,"_56":57},{},[],{"_31":1150,"_33":1151},[],{"_35":36,"_37":471,"_39":40,"_41":1152,"_43":1153,"_58":478,"_56":57},{},[1154],{"_35":46,"_47":1155,"_51":1156,"_41":1157,"_56":57},[180],[186],{},{"_35":36,"_37":480,"_39":40,"_41":1159,"_43":1160,"_58":483,"_56":57},{"_89":228},[],{"_35":86,"_37":485,"_39":40,"_41":1162,"_43":1163,"_58":488,"_56":57},{"_89":90},[],{"_31":1165,"_33":1191},[1166,1171,1176,1181,1186],{"_31":1167,"_33":1168},[],{"_35":36,"_37":494,"_39":40,"_41":1169,"_43":1170,"_58":497,"_56":57},{},[],{"_31":1172,"_33":1173},[],{"_35":46,"_37":501,"_39":40,"_41":1174,"_43":1175,"_58":505,"_56":57},{"_503":58},[],{"_31":1177,"_33":1178},[],{"_35":36,"_37":509,"_39":40,"_41":1179,"_43":1180,"_58":512,"_56":57},{},[],{"_31":1182,"_33":1183},[],{"_35":46,"_37":516,"_39":40,"_41":1184,"_43":1185,"_58":519,"_56":57},{"_503":58},[],{"_31":1187,"_33":1188},[],{"_35":36,"_37":523,"_39":40,"_41":1189,"_43":1190,"_58":526,"_56":57},{},[],{"_35":86,"_37":528,"_39":40,"_41":1192,"_43":1193,"_58":531,"_56":57},{"_89":90},[],{"_31":1195,"_33":1306},[1196,1223,1246,1269],{"_31":1197,"_33":1216},[1198,1207],{"_31":1199,"_33":1200},[],{"_35":36,"_37":539,"_39":40,"_41":1201,"_43":1202,"_58":546,"_56":57},{},[1203],{"_35":46,"_47":1204,"_51":1205,"_41":1206,"_56":57},[180],[216],{},{"_31":1208,"_33":1209},[],{"_35":36,"_37":550,"_39":40,"_41":1210,"_43":1211,"_58":557,"_56":57},{},[1212],{"_35":46,"_47":1213,"_51":1214,"_41":1215,"_56":57},[180],[216],{},{"_35":36,"_37":559,"_39":40,"_41":1217,"_43":1218,"_58":566,"_56":57},{"_89":228},[1219],{"_35":69,"_47":1220,"_51":1221,"_41":1222,"_56":57},[180],[345],{},{"_31":1224,"_33":1239},[1225,1234],{"_31":1226,"_33":1227},[],{"_35":36,"_37":572,"_39":40,"_41":1228,"_43":1229,"_58":579,"_56":57},{},[1230],{"_35":46,"_47":1231,"_51":1232,"_41":1233,"_56":57},[180],[186],{},{"_31":1235,"_33":1236},[],{"_35":36,"_37":583,"_39":40,"_41":1237,"_43":1238,"_58":586,"_56":57},{},[],{"_35":36,"_37":588,"_39":40,"_41":1240,"_43":1241,"_58":596,"_56":57},{"_89":228},[1242],{"_35":69,"_47":1243,"_51":1244,"_41":1245,"_56":57},[180],[594],{},{"_31":1247,"_33":1262},[1248,1257],{"_31":1249,"_33":1250},[],{"_35":36,"_37":602,"_39":40,"_41":1251,"_43":1252,"_58":609,"_56":57},{},[1253],{"_35":46,"_47":1254,"_51":1255,"_41":1256,"_56":57},[180],[392],{},{"_31":1258,"_33":1259},[],{"_35":36,"_37":613,"_39":40,"_41":1260,"_43":1261,"_58":616,"_56":57},{},[],{"_35":36,"_37":618,"_39":40,"_41":1263,"_43":1264,"_58":625,"_56":57},{"_89":228},[1265],{"_35":69,"_47":1266,"_51":1267,"_41":1268,"_56":57},[180],[186],{},{"_31":1270,"_33":1299},[1271,1280,1285,1294],{"_31":1272,"_33":1273},[],{"_35":36,"_37":631,"_39":40,"_41":1274,"_43":1275,"_58":640,"_56":57},{},[1276],{"_35":46,"_47":1277,"_51":1278,"_41":1279,"_56":57},[636],[638],{},{"_31":1281,"_33":1282},[],{"_35":36,"_37":644,"_39":40,"_41":1283,"_43":1284,"_58":647,"_56":57},{},[],{"_31":1286,"_33":1287},[],{"_35":36,"_37":651,"_39":40,"_41":1288,"_43":1289,"_58":660,"_56":57},{},[1290],{"_35":46,"_47":1291,"_51":1292,"_41":1293,"_56":57},[656],[658],{},{"_31":1295,"_33":1296},[],{"_35":36,"_37":664,"_39":40,"_41":1297,"_43":1298,"_58":667,"_56":57},{},[],{"_35":36,"_37":669,"_39":40,"_41":1300,"_43":1301,"_58":676,"_56":57},{"_89":228},[1302],{"_35":69,"_47":1303,"_51":1304,"_41":1305,"_56":57},[180],[186],{},{"_35":86,"_37":678,"_39":40,"_41":1307,"_43":1308,"_58":682,"_56":57},{"_89":680},[],{"_31":1310,"_33":1364},[1311,1351],{"_31":1312,"_33":1348},[1313,1318,1323,1328,1333,1338,1343],{"_31":1314,"_33":1315},[],{"_35":36,"_37":690,"_39":40,"_41":1316,"_43":1317,"_58":693,"_56":57},{},[],{"_31":1319,"_33":1320},[],{"_35":36,"_37":697,"_39":40,"_41":1321,"_43":1322,"_58":700,"_56":57},{},[],{"_31":1324,"_33":1325},[],{"_35":36,"_37":704,"_39":40,"_41":1326,"_43":1327,"_58":707,"_56":57},{},[],{"_31":1329,"_33":1330},[],{"_35":36,"_37":711,"_39":40,"_41":1331,"_43":1332,"_58":714,"_56":57},{},[],{"_31":1334,"_33":1335},[],{"_35":36,"_37":718,"_39":40,"_41":1336,"_43":1337,"_58":721,"_56":57},{},[],{"_31":1339,"_33":1340},[],{"_35":36,"_37":725,"_39":40,"_41":1341,"_43":1342,"_58":728,"_56":57},{},[],{"_31":1344,"_33":1345},[],{"_35":36,"_37":732,"_39":40,"_41":1346,"_43":1347,"_58":735,"_56":57},{},[],{"_35":36,"_37":737,"_39":40,"_41":1349,"_43":1350,"_58":740,"_56":57},{"_89":228},[],{"_31":1352,"_33":1353},[],{"_35":36,"_37":744,"_39":40,"_41":1354,"_43":1355,"_58":758,"_56":57},{},[1356,1360],{"_35":46,"_47":1357,"_51":1358,"_41":1359,"_56":57},[49],[750],{},{"_35":69,"_47":1361,"_51":1362,"_41":1363,"_56":57},[754],[756],{},{"_35":86,"_37":760,"_39":40,"_41":1365,"_43":1366,"_58":763,"_56":57},{"_89":90},[],{"_31":1368,"_33":1410},[1369],{"_31":1370,"_33":1403},[1371,1380,1389,1398],{"_31":1372,"_33":1373},[],{"_35":36,"_37":771,"_39":40,"_41":1374,"_43":1375,"_58":778,"_56":57},{},[1376],{"_35":46,"_47":1377,"_51":1378,"_41":1379,"_56":57},[244,186],[71,158],{},{"_31":1381,"_33":1382},[],{"_35":36,"_37":782,"_39":40,"_41":1383,"_43":1384,"_58":792,"_56":57},{},[1385],{"_35":46,"_47":1386,"_51":1387,"_41":1388,"_56":57},[188,222,787],[789,790,74],{},{"_31":1390,"_33":1391},[],{"_35":36,"_37":796,"_39":40,"_41":1392,"_43":1393,"_58":807,"_56":57},{},[1394],{"_35":46,"_47":1395,"_51":1396,"_41":1397,"_56":57},[801,802],[804,805],{},{"_31":1399,"_33":1400},[],{"_35":36,"_37":811,"_39":40,"_41":1401,"_43":1402,"_58":814,"_56":57},{},[],{"_35":36,"_37":816,"_39":40,"_41":1404,"_43":1405,"_58":833,"_56":57},{"_89":228},[1406],{"_35":46,"_47":1407,"_51":1408,"_41":1409,"_56":57},[821,822,823,824,825,826],[325,128,828,829,830,831],{},{"_35":86,"_37":835,"_39":40,"_41":1411,"_43":1412,"_58":838,"_56":57},{"_89":90},[],[844],{"_852":853},{},{"_856":40,"_859":860},{"_37":872,"_871":841,"_845":1418,"_839":40,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":8},[866,867,868,869],"dataUpdateCount",1,"dataUpdatedAt",1781393346210,"error","errorUpdateCount","errorUpdatedAt","fetchFailureCount","fetchFailureReason","fetchMeta","isInvalidated","status","success","fetchStatus","idle","queryKey",[1436,872,40,8],"ENTITY","queryHash","[\"ENTITY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sql-busy/performance-reports/performance-gabo-laptop-2026-05-26-2022\",\"bafyreid24v4m2ixrkrkihakmnh5fb664eremwfyych2dr263k6bokbofsq\",false]",{"_886":1440,"_1434":1576,"_1437":1577},{"_888":1441,"_1419":1420,"_1421":1575,"_1423":-5,"_1424":180,"_1425":180,"_1426":180,"_1427":-5,"_1428":-5,"_1429":8,"_1430":1431,"_1432":1433},{"_35":26,"_26":1442,"_37":1572},{"_28":1443,"_839":1475,"_840":841,"_842":1504,"_845":57,"_847":1509,"_849":1510,"_850":1511,"_854":1521,"_856":1569,"_857":1570,"_861":862},[1444,1480],{"_31":1445,"_33":1473},[1446,1457,1465],{"_31":1447,"_33":1448},[],{"_35":1449,"_37":1450,"_39":1451,"_41":1452,"_43":1455,"_58":57,"_56":1456},"Embed","JzDiekeG","bafy2bzaceb6vo6nfnsujzojtiitop2ycqcejc2lqbayespgoai4xkrwdmaap6",{"_1453":1454},"view","Card",[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/lobby",{"_31":1458,"_33":1459},[],{"_35":1449,"_37":1460,"_39":1461,"_41":1462,"_43":1463,"_58":57,"_56":1464},"qsJ3aWZe","bafy2bzaceajcg6uys5tb2hibj2e3ywgezt5ftc7q567byeddnc7fhv5l2clho",{"_1453":1454},[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/projects",{"_31":1466,"_33":1467},[],{"_35":1449,"_37":1468,"_39":1469,"_41":1470,"_43":1471,"_58":57,"_56":1472},"lcgyxCBZ","bafy2bzacea7raw7olci3j6dgeajcaf24yr74icckniodcnquru4iznvs2lwli",{"_1453":1454},[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/discussions?v=bafy2bzacecvarageluwv6zqedpezmnd2occdc5mokufzp74vkhnbcj6uvq76e&l",{"_35":36,"_37":1474,"_39":1475,"_41":1476,"_43":1479,"_58":57,"_56":57},"mLbe1CgL","bafy2bzacear3ixjf7genpuezdfpo4wxcncp2sznytnzl3ro3iw43ljh26djym",{"_89":1477,"_1478":636},"Grid","columnCount",[],{"_31":1481,"_33":1482},[],{"_35":1483,"_37":1484,"_39":1475,"_41":1485,"_43":1503,"_58":57,"_56":57},"Query","52yr-hKs",{"_1478":636,"_1486":1487,"_1488":1489,"_1502":8},"style","List","query",{"_1490":1491,"_1496":1497},"includes",[1492],{"_1493":841,"_845":57,"_1494":1495},"space","mode","AllDescendants","sort",[1498],{"_1499":8,"_1500":1501},"reverse","term","ActivityTime","banner",[],[1505,1506,1507,844,841,1508],"z6MkgYR76i3w2Xc2fcvgFJWfYjsop6YwUonDhQx3AdLmQ4BQ","z6MkgisVMELvqnsCo3dYmtVpy8PiqPGMVwfAyBWFn84vebq4","z6MkkGNjfnikRkxK9EaxMPYy3HYxNGkRyXTWxxRtynB2kyeb","z6Mkvz9TgGtv9zsGsdrksfNk1ajbFancgHREJEz3Y2HsAVdk","1970-01-01T00:00:00Z","2026-06-10T07:22:19.920Z",{"_852":1512,"_1513":878,"_1514":1515,"_1516":1517,"_1518":8,"_1519":1520},"Develop Seed Hypermedia","icon","cover","ipfs://bafybeib4utfkwzslucqnkinoar5cdo4ajz4zx45ytqjrfdfbgqebjteyt4","siteUrl","https://seedteamtalks.hyper.media","showActivity","contentWidth","L",{"_1522":1523},"navigation",{"_31":1524,"_33":1568},[1525,1532,1538,1544,1550,1556,1562],{"_31":1526,"_33":1527},[],{"_35":1528,"_37":1529,"_56":1530,"_58":1531},"Link","AeqtyYA8apaxmPuA12SpD","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/issues","Issues",{"_31":1533,"_33":1534},[],{"_35":1528,"_37":1535,"_56":1536,"_58":1537},"UvOMbyhnsjpL3CaU8_0pg","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/projects?v=bafy2bzacec3blhe775ddawbmajnfdac7xee6yoajs2brtdc5mbzg24sn6hjhg&l","Projects",{"_31":1539,"_33":1540},[],{"_35":1528,"_37":1541,"_56":1542,"_58":1543},"Os3QakPzxNB8OzZpVdpQ3","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks","Tech",{"_31":1545,"_33":1546},[],{"_35":1528,"_37":1547,"_56":1548,"_58":1549},"Jh7YrFGNfT5LqzWXR9hZ-","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/design?v=bafy2bzaceayy24fxpivoesrczcbq7auiulnqskfghntdkqynbjzj5ilnmvpkq&l","Design",{"_31":1551,"_33":1552},[],{"_35":1528,"_37":1553,"_56":1554,"_58":1555},"7QpiCgdQDsxYY4tekQd47","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/notes","Notes",{"_31":1557,"_33":1558},[],{"_35":1528,"_37":1559,"_56":1560,"_58":1561},"bdfz0tfzzZc0Kho3U3ZKw","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/meeting-notes?v=bafy2bzacecdujov4k6h3filkpqwm4kgrrjxj3dpnurspxw2pbbpeyewqnesry&l","Meetings",{"_31":1563,"_33":1564},[],{"_35":1528,"_37":1565,"_56":1566,"_58":1567},"rj2H3o4s_OMBQEO2RSCIy","hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/workflows","Workflows",{"_35":90,"_37":1522},"bafy2bzacec7wxg3z4sucahp62txnbuf4k2qv3vzpwh72ivlmchvbzw5anhzku",{"_856":1569,"_859":1571},"1781030633283",{"_37":1573,"_871":841,"_845":1574,"_839":-5,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno",[],1781393346229,[1436,1573,-5,6],"[\"ENTITY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno\",null,true]",{"_886":1579,"_1434":2191,"_1437":2194},{"_888":1580,"_1419":1420,"_1421":2190,"_1423":-5,"_1424":180,"_1425":180,"_1426":180,"_1427":-5,"_1428":-5,"_1429":8,"_1430":1431,"_1432":1433},[1581,1618,1646,1669,1695,1719,1745,1774,1803,1827,1855,1877,1905,1933,1962,1987,2010,2033,2057,2081,2109,2132,2160],{"_35":26,"_37":1582,"_845":1586,"_842":1587,"_847":1588,"_849":1593,"_1596":1597,"_856":1598,"_839":1585,"_1599":1600,"_1603":1604,"_857":1611,"_1613":-5,"_850":1614,"_861":862},{"_37":1554,"_871":841,"_845":1583,"_839":1585,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},[1584],"notes","bafy2bzacebdou5mdc3dvl47iy5lzmp3cucfaemqzcbnidwzbmenbu3rqzujac",[1584],[844,1508,841],{"_1589":1590,"_1591":1592},"seconds","1732791826","nanos",161000000,{"_1589":1594,"_1591":1595},"1781041525",139000000,"sortTime","2024-11-28T11:03:46.161Z","bafy2bzacecai7zv2yssq7j6on5wnylvsdgg2ctbyrnwoknh4wwtasexjh22wm","breadcrumbs",[1601],{"_852":1512,"_845":57,"_1602":8},"isMissing","activitySummary",{"_1605":-5,"_1606":57,"_1607":180,"_1608":1609,"_1610":6},"latestCommentTime","latestCommentId","commentCount","latestChangeTime",{"_1589":1594,"_1591":1595},"isUnread",{"_856":1598,"_859":1612},"1781030224525","redirectInfo",{"_852":1555,"_1615":1616,"_1519":1617},"summary","Sometimes a Comment is not enough","M",{"_35":26,"_37":1619,"_845":1622,"_842":1623,"_847":1626,"_849":1629,"_1596":1632,"_856":1633,"_839":1621,"_1599":1634,"_1603":1636,"_857":1642,"_1613":-5,"_850":1644,"_861":862},{"_37":1542,"_871":841,"_845":1620,"_839":1621,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},[866],"bafy2bzaced25tvjhsdwkcykufkvmjxbs4j6ufg7k6iyprnvjb3tu7qnxawg2o",[866],[844,1508,1506,1624,1625],"z6Mkq9emq1yUBq4KSeiSH5yzgNBJSnidPVqFnTpzjCdLxB3R","z6MkqULds7oeqGPgtSpqpisK77FxhwP57ikVNFVfYfsMb2KZ",{"_1589":1627,"_1591":1628},"1760379588",8000000,{"_1589":1630,"_1591":1631},"1781041506",689000000,"2025-10-13T18:19:48.008Z","bafy2bzaceci4odwwqtrrrhrntnq46pdvkpshot2xnkm3jpatfyvpfqwjmlhnq",[1635],{"_852":1512,"_845":57,"_1602":8},{"_1605":1637,"_1606":1640,"_1607":801,"_1608":1641,"_1610":6},{"_1589":1638,"_1591":1639},"1781078073",428000000,"z6MkgisVMELvqnsCo3dYmtVpy8PiqPGMVwfAyBWFn84vebq4/z6H9j5pizDHsfa",{"_1589":1630,"_1591":1631},{"_856":1633,"_859":1643},"1776675116178",{"_852":1543,"_1615":1645,"_1519":1617},"Conversations about technology and enlightenment.",{"_35":26,"_37":1647,"_845":1651,"_842":1652,"_847":1653,"_849":1656,"_1596":1659,"_856":1660,"_839":1650,"_1599":1661,"_1603":1663,"_857":1665,"_1613":-5,"_850":1667,"_861":862},{"_37":1464,"_871":841,"_845":1648,"_839":1650,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},[1649],"projects","bafy2bzaceaje5fkrqdxcjdg5zi57geknvcwcgls7yvjp7gzla2ogld7eoey4k",[1649],[844,1508,1507,1506,841,1624,1505,1625],{"_1589":1654,"_1591":1655},"1737452534",659000000,{"_1589":1657,"_1591":1658},"1781041482",798000000,"2025-01-21T09:42:14.659Z","bafy2bzaceclwoffe3urzgxzxeuaozsyftjoswi7kymxmnbame5ruwmf665oei",[1662],{"_852":1512,"_845":57,"_1602":8},{"_1605":-5,"_1606":57,"_1607":180,"_1608":1664,"_1610":6},{"_1589":1657,"_1591":1658},{"_856":1660,"_859":1666},"1778686114503",{"_852":1537,"_1615":1668,"_1519":1617},"Product Development Workflow",{"_35":26,"_37":1670,"_845":1674,"_842":1675,"_847":1676,"_849":1679,"_1596":1682,"_856":1683,"_839":1673,"_1599":1684,"_1603":1686,"_857":1692,"_1613":-5,"_850":1694,"_861":862},{"_37":1566,"_871":841,"_845":1671,"_839":1673,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},[1672],"workflows","bafy2bzaceaeaccgy7f5kbq3wzqefo5uxhyg4eywjdkl6flr7ejs6t6nf3t456",[1672],[844],{"_1589":1677,"_1591":1678},"1778655935",673000000,{"_1589":1680,"_1591":1681},"1781041233",833000000,"2026-05-13T07:05:35.673Z","bafyreic5qanb4v2dwkothgoa6g2iqbl7chh3poxxr6zeeh54wyerjzlk5e",[1685],{"_852":1512,"_845":57,"_1602":8},{"_1605":1687,"_1606":1690,"_1607":636,"_1608":1691,"_1610":8},{"_1589":1688,"_1591":1689},"1779174388",314000000,"z6Mkh2DY3CRyfsx6rtPpE8NsiHmnwyPqoEfqPQxfUL4zf4fk/z6GpkJDTvYgwAw",{"_1589":1680,"_1591":1681},{"_856":1683,"_859":1693},"1778655935681",{"_852":1567},{"_35":26,"_37":1696,"_845":1701,"_842":1702,"_847":1704,"_849":1707,"_1596":1710,"_856":1711,"_839":1700,"_1599":1712,"_1603":1714,"_857":1716,"_1613":-5,"_850":1718,"_861":862},{"_37":1697,"_871":841,"_845":1698,"_839":1700,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/design",[1699],"design","bafy2bzacecihwzrdxamcrnewd3nwdqf43pwpjtnwmqpopte33qqvvhngircue",[1699],[844,1508,1507,1506,1703],"z6MkfnCSnmstMXTAb6MBXXCj4zdPwZedtRF6YBgYtE5Q8Sov",{"_1589":1705,"_1591":1706},"1752161904",417000000,{"_1589":1708,"_1591":1709},"1781022624",190000000,"2025-07-10T15:38:24.417Z","bafy2bzacec6hrmu6x3i4sig3v65yimreki35vksxz7rvahnhcgbn4zbnqxh4c",[1713],{"_852":1512,"_845":57,"_1602":8},{"_1605":-5,"_1606":57,"_1607":180,"_1608":1715,"_1610":6},{"_1589":1708,"_1591":1709},{"_856":1711,"_859":1717},"0",{"_852":1549,"_1519":1617},{"_35":26,"_37":1720,"_845":1725,"_842":1726,"_847":1727,"_849":1728,"_1596":1710,"_856":1711,"_839":1724,"_1599":1731,"_1603":1733,"_857":1739,"_1613":1740,"_850":1744,"_861":862},{"_37":1721,"_871":841,"_845":1722,"_839":1724,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/human-interface-library",[1723],"human-interface-library","bafy2bzaceauiiz4b25x6wwaqbjemi72kym3jqz3sksniluqn4sz2qv6gbr5ra.bafy2bzacebd6bz26cyn4ic5yaa4uwfc6kzmbhpfo72xsut2ih5slg5nemyoo4.bafy2bzaceca7uch6ymb6xzxvujitcc77skokb34a7tsksqqgirko6qdtikve4.bafy2bzacectmzmjl7irjxa7fjour2mvhspqftjt2vtqzxrrbwv5svtnc234y6",[1723],[844,1508,1507,1506,1703],{"_1589":1705,"_1591":1706},{"_1589":1729,"_1591":1730},"1780410733",856000000,[1732],{"_852":1512,"_845":57,"_1602":8},{"_1605":1734,"_1606":1737,"_1607":327,"_1608":1738,"_1610":6},{"_1589":1735,"_1591":1736},"1779923306",678000000,"z6MkgYR76i3w2Xc2fcvgFJWfYjsop6YwUonDhQx3AdLmQ4BQ/z6GxDMNGzQJo9r",{"_1589":1729,"_1591":1730},{"_856":1711,"_859":1717},{"_35":1741,"_1742":1743},"redirect","target","z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno//design",{"_852":1549,"_1519":1617},{"_35":26,"_37":1746,"_845":1750,"_842":1751,"_847":1752,"_849":1755,"_1596":1758,"_856":1759,"_839":1749,"_1599":1760,"_1603":1762,"_857":1769,"_1613":-5,"_850":1771,"_861":862},{"_37":1456,"_871":841,"_845":1747,"_839":1749,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},[1748],"lobby","bafy2bzacedlj3rqkxxw2bism74p4zifj6ayfntiuc6xmd3gi4sb2ss52ok7ci",[1748],[844],{"_1589":1753,"_1591":1754},"1773912200",806000000,{"_1589":1756,"_1591":1757},"1780223376",821000000,"2026-03-19T09:23:20.806Z","bafyreihidbvykdfeh7juqbzorm3f2rkwhjes2d3tsutcikuwnozupzg5gm",[1761],{"_852":1512,"_845":57,"_1602":8},{"_1605":1763,"_1606":1766,"_1607":1767,"_1608":1768,"_1610":8},{"_1589":1764,"_1591":1765},"1781128574",177000000,"z6Mkvz9TgGtv9zsGsdrksfNk1ajbFancgHREJEz3Y2HsAVdk/z6HAEHWheKPSZo",37,{"_1589":1756,"_1591":1757},{"_856":1759,"_859":1770},"1773912200838",{"_852":1772,"_1615":1773,"_1519":1520},"Lobby","Good morning sunshine",{"_35":26,"_37":1775,"_845":1779,"_842":1780,"_847":1781,"_849":1784,"_1596":1787,"_856":1788,"_839":1778,"_1599":1789,"_1603":1791,"_857":1798,"_1613":-5,"_850":1800,"_861":862},{"_37":1530,"_871":841,"_845":1776,"_839":1778,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},[1777],"issues","bafy2bzaceakaj7grszxisbtdi4v22i2pf6rj6h6q4w72rpedzsuakdcazlxry",[1777],[844],{"_1589":1782,"_1591":1783},"1759157680",878000000,{"_1589":1785,"_1591":1786},"1779302728",154000000,"2025-09-29T14:54:40.878Z","bafy2bzaceb7yeja5qwvz52essbe7cb7uskjlhzmqhphzxeuuacdqfit74ykcs",[1790],{"_852":1512,"_845":57,"_1602":8},{"_1605":1792,"_1606":1795,"_1607":1796,"_1608":1797,"_1610":6},{"_1589":1793,"_1591":1794},"1780913344",433000000,"z6Mkk7BYiBuZBKW5cDJJyFL65Rvmbq2DPKP6qjAQkZs9cYny/z6H85qA9NN5vKK",185,{"_1589":1785,"_1591":1786},{"_856":1788,"_859":1799},"1759157680878",{"_852":1801,"_1615":1802},"Product Issues","Still figuring out how to use Issues in Seed and moving away from Github",{"_35":26,"_37":1804,"_845":1809,"_842":1810,"_847":1811,"_849":1814,"_1596":1817,"_856":1818,"_839":1808,"_1599":1819,"_1603":1821,"_857":1823,"_1613":-5,"_850":1825,"_861":862},{"_37":1805,"_871":841,"_845":1806,"_839":1808,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/opportunities",[1807],"opportunities","bafy2bzacec55iq3mqr6jew4kfusxlar6sfpmt546embha7cohaz7eqbd6j6r6",[1807],[844,1507,841],{"_1589":1812,"_1591":1813},"1773675441",829000000,{"_1589":1815,"_1591":1816},"1775740910",405000000,"2026-03-16T15:37:21.829Z","bafyreiaxt6v6p36usl3ymb4m55nvf6vld7p2qjmpncxh3fpu53zdiokxou",[1820],{"_852":1512,"_845":57,"_1602":8},{"_1605":-5,"_1606":57,"_1607":180,"_1608":1822,"_1610":6},{"_1589":1815,"_1591":1816},{"_856":1818,"_859":1824},"1773675441867",{"_852":1826},"Opportunities",{"_35":26,"_37":1828,"_845":1833,"_842":1834,"_847":1835,"_849":1838,"_1596":1841,"_856":1842,"_839":1832,"_1599":1843,"_1603":1845,"_857":1851,"_1613":-5,"_850":1853,"_861":862},{"_37":1829,"_871":841,"_845":1830,"_839":1832,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/user-story-map",[1831],"user-story-map","bafy2bzacebkvsp55y66yio2qcnf6sqi56nouw6pb4jski76heq4loruz7ureo",[1831],[844,1506],{"_1589":1836,"_1591":1837},"1753177046",860000000,{"_1589":1839,"_1591":1840},"1774859074",164000000,"2025-07-22T09:37:26.860Z","bafy2bzacealtqjbqauikxnocl2so3eorgne3ggkhv7cogtf4onodqaxartg7o",[1844],{"_852":1512,"_845":57,"_1602":8},{"_1605":1846,"_1606":1849,"_1607":244,"_1608":1850,"_1610":8},{"_1589":1847,"_1591":1848},"1770976718",280000000,"z6MkgisVMELvqnsCo3dYmtVpy8PiqPGMVwfAyBWFn84vebq4/z6FR25YjTujXE6",{"_1589":1839,"_1591":1840},{"_856":1842,"_859":1852},"1753177046858",{"_852":1854},"User Story Map",{"_35":26,"_37":1856,"_845":1861,"_842":1862,"_847":1863,"_849":1865,"_1596":1868,"_856":1869,"_839":1860,"_1599":1870,"_1603":1872,"_857":1874,"_1613":-5,"_850":1876,"_861":862},{"_37":1857,"_871":841,"_845":1858,"_839":1860,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tags",[1859],"tags","bafy2bzacebh3uai5xosfuptcc7odxbksnhq2fbwhxhzhgto4zbgmyhyyi2n7a",[1859],[844],{"_1589":1864,"_1591":1754},"1773928289",{"_1589":1866,"_1591":1867},"1774091072",932000000,"2026-03-19T13:51:29.806Z","bafyreib7lekmh45w6pw5ctoz7t2vlyox44umxddr73jdzadncm5nnfexje",[1871],{"_852":1512,"_845":57,"_1602":8},{"_1605":-5,"_1606":57,"_1607":180,"_1608":1873,"_1610":6},{"_1589":1866,"_1591":1867},{"_856":1869,"_859":1875},"1773928289849",{"_852":1859},{"_35":26,"_37":1878,"_845":1883,"_842":1884,"_847":1885,"_849":1888,"_1596":1891,"_856":1892,"_839":1882,"_1599":1893,"_1603":1895,"_857":1901,"_1613":-5,"_850":1903,"_861":862},{"_37":1879,"_871":841,"_845":1880,"_839":1882,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/roadmap",[1881],"roadmap","bafyreia57kttdwgrrwsrc2l4z6amvovcbhrcp3xig5oojvlnrlwlubiggq",[1881],[844,1506,841,1505,1703],{"_1589":1886,"_1591":1887},"1751702529",991000000,{"_1589":1889,"_1591":1890},"1773744906",927000000,"2025-07-05T08:02:09.991Z","bafy2bzaced3t5nb4pyuu5iukdirwdsblmggv2vuq6urpnd4vftg5lnu5yjuey",[1894],{"_852":1512,"_845":57,"_1602":8},{"_1605":1896,"_1606":1899,"_1607":351,"_1608":1900,"_1610":6},{"_1589":1897,"_1591":1898},"1771863047",262000000,"z6MkomKJd58PhVSoDZPi9RtUZ6rLrT2P8UN9ijLpb7Hj2tdn/z6FZrbATfsngbe",{"_1589":1889,"_1591":1890},{"_856":1892,"_859":1902},"1751702529991",{"_852":1904},"Roadmap",{"_35":26,"_37":1906,"_845":1911,"_842":1912,"_847":1913,"_849":1916,"_1596":1919,"_856":1920,"_839":1910,"_1599":1921,"_1603":1923,"_857":1929,"_1613":-5,"_850":1931,"_861":862},{"_37":1907,"_871":841,"_845":1908,"_839":1910,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/stories",[1909],"stories","bafyreiaw6iu4ehtc5kn2cfdwr2y3yxa3hu6snyujjnn2qc5rkzsl7t7bxe",[1909],[844,1508,841],{"_1589":1914,"_1591":1915},"1756300583",462000000,{"_1589":1917,"_1591":1918},"1773744591",518000000,"2025-08-27T13:16:23.462Z","bafy2bzacecrattxfobgydg3rqsirjsquulwbxpermpxqfohwlugmidlepcqi2",[1922],{"_852":1512,"_845":57,"_1602":8},{"_1605":1924,"_1606":1927,"_1607":204,"_1608":1928,"_1610":6},{"_1589":1925,"_1591":1926},"1778596374",544000000,"z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou/z6Giz4qzkm7Z4q",{"_1589":1917,"_1591":1918},{"_856":1920,"_859":1930},"1756300583462",{"_852":1932},"Stories",{"_35":26,"_37":1934,"_845":1939,"_842":1940,"_847":1941,"_849":1944,"_1596":1947,"_856":1948,"_839":1938,"_1599":1949,"_1603":1951,"_857":1957,"_1613":-5,"_850":1959,"_861":862},{"_37":1935,"_871":841,"_845":1936,"_839":1938,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/methodologies",[1937],"methodologies","bafyreiaegtx6u7ok6fbhsarksggyrmsruf7eki3g6txntzdue2basya5tu",[1937],[844],{"_1589":1942,"_1591":1943},"1752483694",123000000,{"_1589":1945,"_1591":1946},"1773743554",608000000,"2025-07-14T09:01:34.123Z","bafy2bzacebip7pvsmdoewquvcmipekt53gcksnn7pbc7igu7u5wpsonneptvq",[1950],{"_852":1512,"_845":57,"_1602":8},{"_1605":1952,"_1606":1955,"_1607":244,"_1608":1956,"_1610":6},{"_1589":1953,"_1591":1954},"1762185594",5000000,"z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou/z6DuNhfkk1A2qb",{"_1589":1945,"_1591":1946},{"_856":1948,"_859":1958},"1752483694123",{"_852":1960,"_1615":1961},"Methodologies","Methodologies are a necessary element for human intellect augmentation. ",{"_35":26,"_37":1963,"_845":1968,"_842":1969,"_847":1970,"_849":1973,"_1596":1976,"_856":1977,"_839":1967,"_1599":1978,"_1603":1980,"_857":1982,"_1613":-5,"_850":1984,"_861":862},{"_37":1964,"_871":841,"_845":1965,"_839":1967,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/meeting-notes",[1966],"meeting-notes","bafy2bzaceb3t47birzausbjryuzwdkop24jy7cxtkytzvax5lgsxmjrksm6ng",[1966],[1505],{"_1589":1971,"_1591":1972},"1758055379",977000000,{"_1589":1974,"_1591":1975},"1772015186",609000000,"2025-09-16T20:42:59.977Z","bafy2bzaceba7jlw74w3a6fh5yq7y7tp4hpzp4ubbqkknmuel3nogbihkthzes",[1979],{"_852":1512,"_845":57,"_1602":8},{"_1605":-5,"_1606":57,"_1607":180,"_1608":1981,"_1610":6},{"_1589":1974,"_1591":1975},{"_856":1977,"_859":1983},"1758055379977",{"_852":1985,"_1615":1986},"Meeting Notes","Every time we have a meeting, it's useful to take notes. When we do, let's put them in this directory.",{"_35":26,"_37":1988,"_845":1993,"_842":1994,"_847":1995,"_849":1998,"_1596":2001,"_856":2002,"_839":1992,"_1599":2003,"_1603":2005,"_857":2007,"_1613":-5,"_850":2008,"_861":862},{"_37":1989,"_871":841,"_845":1990,"_839":1992,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/specs",[1991],"specs","bafy2bzacedfa3cmxkeswnj5eqvsuzyg3n2jrihwkrekq2u7v7p7xfdot53a4e",[1991],[844,1508,1506,841],{"_1589":1996,"_1591":1997},"1757507072",743000000,{"_1589":1999,"_1591":2000},"1770899043",471000000,"2025-09-10T12:24:32.743Z","bafy2bzacedgzqyw4bffanmgxuxigf7w4qksk4ib5ut7mhfcggm5w4f3ud3xwm",[2004],{"_852":1512,"_845":57,"_1602":8},{"_1605":-5,"_1606":57,"_1607":180,"_1608":2006,"_1610":6},{"_1589":1999,"_1591":2000},{"_856":2002,"_859":1717},{"_852":2009},"Specs",{"_35":26,"_37":2011,"_845":2016,"_842":2017,"_847":2018,"_849":2021,"_1596":2024,"_856":2025,"_839":2015,"_1599":2026,"_1603":2028,"_857":2030,"_1613":-5,"_850":2032,"_861":862},{"_37":2012,"_871":841,"_845":2013,"_839":2015,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/2DtXp0zvkX88AUvxftQzE",[2014],"2DtXp0zvkX88AUvxftQzE","bafy2bzaceatrlakvv6xo4374eb2shvx6wttzwfy2bgg7kpxie7upmfgyp2klo",[2014],[844],{"_1589":2019,"_1591":2020},"1770368762",56000000,{"_1589":2022,"_1591":2023},"1770727089",776000000,"2026-02-06T09:06:02.056Z","bafy2bzaceazpxfu7qeaoriflpo4jsdb7265b3vnnwzft474vcgm4uypdymzeg",[2027],{"_852":1512,"_845":57,"_1602":8},{"_1605":-5,"_1606":57,"_1607":180,"_1608":2029,"_1610":8},{"_1589":2022,"_1591":2023},{"_856":2025,"_859":2031},"1770368762055",{"_852":1555},{"_35":26,"_37":2034,"_845":2039,"_842":2040,"_847":2041,"_849":2044,"_1596":2047,"_856":2048,"_839":2038,"_1599":2049,"_1603":2051,"_857":2053,"_1613":-5,"_850":2055,"_861":862},{"_37":2035,"_871":841,"_845":2036,"_839":2038,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/academic-papers",[2037],"academic-papers","bafy2bzacecpciyww7skadu3wxqzgp6tlfslyyymp7kixspmwn74panl6l2n54",[2037],[844],{"_1589":2042,"_1591":2043},"1763396740",165000000,{"_1589":2045,"_1591":2046},"1763396788",635000000,"2025-11-17T16:25:40.165Z","bafy2bzacechg2zqbfzsobwuifyzc7iprmi2qr4b4h3owejttu473kd25wbipw",[2050],{"_852":1512,"_845":57,"_1602":8},{"_1605":-5,"_1606":57,"_1607":180,"_1608":2052,"_1610":6},{"_1589":2045,"_1591":2046},{"_856":2048,"_859":2054},"1763396740165",{"_852":2056},"Academic Papers",{"_35":26,"_37":2058,"_845":2063,"_842":2064,"_847":2065,"_849":2068,"_1596":2071,"_856":2072,"_839":2062,"_1599":2073,"_1603":2075,"_857":2077,"_1613":-5,"_850":2079,"_861":862},{"_37":2059,"_871":841,"_845":2060,"_839":2062,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/site-organization",[2061],"site-organization","bafy2bzacebjuo7m4ljbnnw6f3qwve3wqnu24wkmcwmv4scjsqizgfyk6ls2wm",[2061],[844,841],{"_1589":2066,"_1591":2067},"1757971251",134000000,{"_1589":2069,"_1591":2070},"1758011895",764000000,"2025-09-15T21:20:51.134Z","bafy2bzacecspxqbvg4vyrgwuazy766ndx7i2aa2zfc76kt5awvr2lzz4tb65y",[2074],{"_852":1512,"_845":57,"_1602":8},{"_1605":-5,"_1606":57,"_1607":180,"_1608":2076,"_1610":6},{"_1589":2069,"_1591":2070},{"_856":2072,"_859":2078},"1757971251133",{"_852":2080},"Site Organization",{"_35":26,"_37":2082,"_845":2087,"_842":2088,"_847":2089,"_849":2092,"_1596":2095,"_856":2096,"_839":2086,"_1599":2097,"_1603":2099,"_857":2105,"_1613":-5,"_850":2107,"_861":862},{"_37":2083,"_871":841,"_845":2084,"_839":2086,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/create-a-new-discussion",[2085],"create-a-new-discussion","bafy2bzacecwyuyxhqqfwmkd4hek7yudoebwjaqt2ehun346r5vah6qnyqaau2",[2085],[844,1505],{"_1589":2090,"_1591":2091},"1756300679",383000000,{"_1589":2093,"_1591":2094},"1757423008",601000000,"2025-08-27T13:17:59.383Z","bafy2bzacedokt2n6ku35tovylopn76r4vbcuwf4je7v5rdomdyr35adapsdaq",[2098],{"_852":1512,"_845":57,"_1602":8},{"_1605":2100,"_1606":2103,"_1607":656,"_1608":2104,"_1610":6},{"_1589":2101,"_1591":2102},"1756457180",886000000,"z6MkfnCSnmstMXTAb6MBXXCj4zdPwZedtRF6YBgYtE5Q8Sov/z6CvGJhetZ6XBp",{"_1589":2093,"_1591":2094},{"_856":2096,"_859":2106},"1756300679383",{"_852":2108},"Create a new Discussion",{"_35":26,"_37":2110,"_845":2115,"_842":2116,"_847":2117,"_849":2120,"_1596":2123,"_856":2124,"_839":2114,"_1599":2125,"_1603":2127,"_857":2129,"_1613":-5,"_850":2130,"_861":862},{"_37":2111,"_871":841,"_845":2112,"_839":2114,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/identified-pain-points",[2113],"identified-pain-points","bafy2bzacebfghlcvjde3rqylxfryihwrc6gmo7rkbr6kokvti54utiy7ghdwy",[2113],[844],{"_1589":2118,"_1591":2119},"1753351865",631000000,{"_1589":2121,"_1591":2122},"1753363231",549000000,"2025-07-24T10:11:05.631Z","bafy2bzacebpdextl7sosiws4oprqfldkj3lswtl3mng3lxkqagwtqgnza5rfo",[2126],{"_852":1512,"_845":57,"_1602":8},{"_1605":-5,"_1606":57,"_1607":180,"_1608":2128,"_1610":6},{"_1589":2121,"_1591":2122},{"_856":2124,"_859":1717},{"_852":2131},"Identified Pain Points",{"_35":26,"_37":2133,"_845":2138,"_842":2139,"_847":2140,"_849":2143,"_1596":2146,"_856":2147,"_839":2137,"_1599":2148,"_1603":2150,"_857":2156,"_1613":-5,"_850":2158,"_861":862},{"_37":2134,"_871":841,"_845":2135,"_839":2137,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/definitions",[2136],"definitions","bafy2bzaceardarkdfmc7l5gko4v2zi3z5kf6y7alekquvqxzp3ioexqzabo72",[2136],[844,841],{"_1589":2141,"_1591":2142},"1752232211",716000000,{"_1589":2144,"_1591":2145},"1752232556",193000000,"2025-07-11T11:10:11.716Z","bafy2bzaceaqctzadpz27ncr674vzix6jgcvuqvuix3jcqlfhpetpblxm6o2fg",[2149],{"_852":1512,"_845":57,"_1602":8},{"_1605":2151,"_1606":2154,"_1607":1420,"_1608":2155,"_1610":6},{"_1589":2152,"_1591":2153},"1755849403",214000000,"z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou/z6CpCs7VU9rip8",{"_1589":2144,"_1591":2145},{"_856":2147,"_859":2157},"1752232211716",{"_852":2159},"Definitions",{"_35":26,"_37":2161,"_845":2166,"_842":2167,"_847":2168,"_849":2171,"_1596":2174,"_856":2175,"_839":2165,"_1599":2176,"_1603":2178,"_857":2185,"_1613":-5,"_850":2187,"_861":862},{"_37":2162,"_871":841,"_845":2163,"_839":2165,"_873":-5,"_874":-5,"_875":-5,"_876":-5,"_870":6},"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/updates",[2164],"updates","bafy2bzacedjhk4r4tzf2bfkhd3rqbzep2o7s6ec3tzuwpn3jbqo4ipv2vrnle",[2164],[1508,1506,1624,1505],{"_1589":2169,"_1591":2170},"1745330217",834000000,{"_1589":2172,"_1591":2173},"1746610473",772000000,"2025-04-22T13:56:57.834Z","bafy2bzacedajlr6y5olm3ee24vmpat7yxi7ysb35qnyu3z7fkmsd7sloxwpm6",[2177],{"_852":1512,"_845":57,"_1602":8},{"_1605":2179,"_1606":2182,"_1607":2183,"_1608":2184,"_1610":6},{"_1589":2180,"_1591":2181},"1763480049",21000000,"zDnaeUAteHX98erunHCNphgNFnXeQnAegvQjUKqxKJWQFP6Z3/z6E8HCybawN6HA",2,{"_1589":2172,"_1591":2173},{"_856":2175,"_859":2186},"1745330217833",{"_852":2188,"_2189":8,"_1519":1520},"Updates","showOutline",1781393346161,[2192,1573,2193],"DOC_LIST_DIRECTORY","Children","[\"DOC_LIST_DIRECTORY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno\",\"Children\"]",{"_886":2196,"_1434":2199,"_1437":2200},{"_888":2197,"_1419":1420,"_1421":2198,"_1423":-5,"_1424":180,"_1425":180,"_1426":180,"_1427":-5,"_1428":-5,"_1429":8,"_1430":1431,"_1432":1433},[],1781393346163,[2192,872,2193],"[\"DOC_LIST_DIRECTORY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sql-busy/performance-reports/performance-gabo-laptop-2026-05-26-2022\",\"Children\"]",{"_886":2202,"_1434":2214,"_1437":2216},{"_888":2203,"_1419":1420,"_1421":2213,"_1423":-5,"_1424":180,"_1425":180,"_1426":180,"_1427":-5,"_1428":-5,"_1429":8,"_1430":1431,"_1432":1433},{"_2204":180,"_2205":1420,"_2206":1420,"_31":180,"_2207":2208,"_2210":2211},"citations","comments","changes","authorUids",[2209],"z6MkvFZ7vTAE58gQmhiECRg3MAHbnC6zXwzBYEdZhcRpoWXM","blocks",{"_494":2212},{"_2204":180,"_2205":1420},1781393346242,[2215,872],"DOCUMENT_INTERACTION_SUMMARY","[\"DOCUMENT_INTERACTION_SUMMARY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sql-busy/performance-reports/performance-gabo-laptop-2026-05-26-2022\"]",{"_886":2218,"_1434":2278,"_1437":2279},{"_888":2219,"_1419":1420,"_1421":2277,"_1423":-5,"_1424":180,"_1425":180,"_1426":180,"_1427":-5,"_1428":-5,"_1429":8,"_1430":1431,"_1432":1433},{"_35":26,"_26":2220,"_37":2275},{"_28":2221,"_839":1621,"_840":841,"_842":2269,"_845":2270,"_847":1632,"_849":2271,"_850":2272,"_854":2273,"_856":1633,"_857":2274,"_861":862},[2222,2229,2258],{"_31":2223,"_33":2224},[],{"_35":36,"_37":2225,"_39":2226,"_41":2227,"_43":2228,"_58":57,"_56":57},"ZneEYQJl","bafy2bzacebqx372uatpdaj6iqfgywxc5j5l2qpq5ny2hlwbgabcouj4gc2nvu",{},[],{"_31":2230,"_33":2254},[2231,2238,2246],{"_31":2232,"_33":2233},[],{"_35":1449,"_37":2234,"_39":2226,"_41":2235,"_43":2236,"_58":57,"_56":2237},"EleZWT_b",{"_1453":1454},[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/fundamentals",{"_31":2239,"_33":2240},[],{"_35":1449,"_37":2241,"_39":2242,"_41":2243,"_43":2244,"_58":57,"_56":2245},"I2bf_hAN","bafy2bzacebvskl7vhxefz7tr5pmvuwov3ftrrilv5twvs4mbgnapls7lgoeyy",{"_1453":1454},[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/system-components",{"_31":2247,"_33":2248},[],{"_35":1449,"_37":2249,"_39":2250,"_41":2251,"_43":2252,"_58":57,"_56":2253},"v43lRwCt","bafy2bzaceafqk6q5nqj2q7tw4s6xj6ytglad33auxdopfjvrtyg6s33pio6bq",{"_1453":1454},[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sql-busy",{"_35":36,"_37":2255,"_39":1621,"_41":2256,"_43":2257,"_58":57,"_56":57},"CWhPlOVO",{"_89":1477,"_1478":636},[],{"_31":2259,"_33":2260},[],{"_35":1483,"_37":2261,"_39":1621,"_41":2262,"_43":2268,"_58":57,"_56":57},"8iPbCi14",{"_1478":636,"_1486":1454,"_1488":2263,"_1502":8},{"_1490":2264,"_1496":2266},[2265],{"_1493":841,"_845":866,"_1494":2193},[2267],{"_1499":8,"_1500":1501},[],[1506,1624,1625,844,1508],"/tech-talks","2026-06-09T21:45:06.689Z",{"_852":1543,"_1615":1645,"_1519":1617},{},{"_856":1633,"_859":1643},{"_37":1542,"_871":841,"_845":2276,"_839":-5,"_873":-5,"_874":-5,"_875":-5,"_876":-5},[866],1781393346128,[1436,1542,-5,8],"[\"ENTITY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks\",null,false]",{"_886":2281,"_1434":2360,"_1437":2361},{"_888":2282,"_1419":1420,"_1421":2359,"_1423":-5,"_1424":180,"_1425":180,"_1426":180,"_1427":-5,"_1428":-5,"_1429":8,"_1430":1431,"_1432":1433},{"_35":26,"_26":2283,"_37":2357},{"_28":2284,"_839":2312,"_840":841,"_842":2347,"_845":2348,"_847":2349,"_849":2350,"_850":2351,"_854":2353,"_856":2354,"_857":2355,"_861":862},[2285,2315,2321,2335],{"_31":2286,"_33":2310},[2287,2295,2303],{"_31":2288,"_33":2289},[],{"_35":1449,"_37":2290,"_39":2291,"_41":2292,"_43":2293,"_58":57,"_56":2294},"Bd2IKeeg","bafy2bzacebtmryaja5fjqq5s2ppqu6dsavzgci3ridsxacki3baxx3x5ghgo2",{"_1453":1454},[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sql-busy/global-picture",{"_31":2296,"_33":2297},[],{"_35":1449,"_37":2298,"_39":2299,"_41":2300,"_43":2301,"_58":57,"_56":2302},"RNuHjo1W","bafy2bzaceb7o4nexcwlzr3vk44jbxhjrxec6gn75cgx47ui25vwypsjlm7th6",{"_1453":1454},[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sql-busy/actions",{"_31":2304,"_33":2305},[],{"_35":1449,"_37":2306,"_39":2299,"_41":2307,"_43":2308,"_58":57,"_56":2309},"zXiyD5bo",{"_1453":1454},[],"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sql-busy/performance-reports",{"_35":36,"_37":2311,"_39":2312,"_41":2313,"_43":2314,"_58":57,"_56":57},"6wYFYgEc","bafy2bzaceccyiayc5tqlcq3yrsx4j7ywji5epr6jee6trizjmcs3iiiteee6m",{"_89":1477,"_1478":636},[],{"_31":2316,"_33":2317},[],{"_35":36,"_37":2318,"_39":2299,"_41":2319,"_43":2320,"_58":57,"_56":57},"fefgfuIp",{},[],{"_31":2322,"_33":2331},[2323],{"_31":2324,"_33":2325},[],{"_35":86,"_37":2326,"_39":2327,"_41":2328,"_43":2329,"_58":2330,"_56":57},"9IYz7ACQ","bafy2bzaceavk2c5eo4y6u55s5avdodczquwcdgf7gssnppdp3f2srhcks7ji6",{},[],"Discussions",{"_35":36,"_37":2332,"_39":2312,"_41":2333,"_43":2334,"_58":57,"_56":57},"hLFotulM",{"_89":1477,"_1478":2183},[],{"_31":2336,"_33":2337},[],{"_35":1483,"_37":2338,"_39":2312,"_41":2339,"_43":2346,"_58":57,"_56":57},"mLtd-e5b",{"_1478":636,"_1486":1487,"_1488":2340,"_1502":8},{"_1490":2341,"_1496":2344},[2342],{"_1493":841,"_845":2343,"_1494":2193},"tech-talks/sql-busy",[2345],{"_1499":8,"_1500":1501},[],[844],"/tech-talks/sql-busy","2026-05-22T21:56:36.431Z","2026-05-26T08:42:29.965Z",{"_852":2352,"_1519":1520},"Performance",{},"bafyreiadu7nl2jhvmrpiv6elqkf5ykhqy4tcmiwpcfeznfji6u6cvduuye",{"_856":2354,"_859":2356},"1779486996440",{"_37":2253,"_871":841,"_845":2358,"_839":-5,"_873":-5,"_874":-5,"_875":-5,"_876":-5},[866,867],1781393346216,[1436,2253,-5,8],"[\"ENTITY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sql-busy\",null,false]",{"_886":2363,"_1434":2391,"_1437":2392},{"_888":2364,"_1419":1420,"_1421":2390,"_1423":-5,"_1424":180,"_1425":180,"_1426":180,"_1427":-5,"_1428":-5,"_1429":8,"_1430":1431,"_1432":1433},{"_35":26,"_26":2365,"_37":2388},{"_28":2366,"_839":2371,"_840":841,"_842":2380,"_845":2381,"_847":2382,"_849":2382,"_850":2383,"_854":2385,"_856":2371,"_857":2386,"_861":862},[2367],{"_31":2368,"_33":2369},[],{"_35":1483,"_37":2370,"_39":2371,"_41":2372,"_43":2379,"_58":57,"_56":57},"empty","bafyreihwut5r6uiydirma5nerlykmlfhqtznkrb3e2ok2pgh3hd7nywhlq",{"_1478":636,"_1486":1487,"_1488":2373,"_1502":8},{"_1490":2374,"_1496":2377},[2375],{"_1493":841,"_845":2376,"_1494":2193},"tech-talks/sql-busy/-JRSlPbyRd0",[2378],{"_1499":8,"_1500":1501},[],[844],"/tech-talks/sql-busy/performance-reports","2026-05-25T21:17:29.613Z",{"_852":2384},"Performance Reports",{},{"_856":2371,"_859":2387},"1779743849622",{"_37":2309,"_871":841,"_845":2389,"_839":-5,"_873":-5,"_874":-5,"_875":-5,"_876":-5},[866,867,868],1781393346123,[1436,2309,-5,8],"[\"ENTITY\",\"hm://z6MkuBbsB1HbSNXLvJCRCrPhimY6g7tzhr4qvcYKPuSZzhno/tech-talks/sql-busy/performance-reports\",null,false]",{"_886":2394,"_1434":2415,"_1437":2417},{"_888":2395,"_1419":1420,"_1421":2414,"_1423":-5,"_1424":180,"_1425":180,"_1426":180,"_1427":-5,"_1428":-5,"_1429":8,"_1430":1431,"_1432":1433},{"_35":840,"_37":2396,"_850":2400},{"_839":2397,"_871":844,"_37":2398,"_845":2399,"_873":-5,"_874":-5,"_875":-5,"_876":-5},"bafy2bzacecupfxbd7v5xvsqlg5tukvxe366col5exfazr3x2rnnu5vkwjsurc","hm://z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou",[],{"_852":2401,"_1513":2402,"_2403":2402,"_1514":2404,"_1516":2405,"_2406":57,"_2407":2408,"_2409":57,"_1518":8,"_1519":1520,"_2410":2411,"_1615":-5},"Gabo H Beaumont","ipfs://bafkreifg4zwc2bidz3zuddxbld6dzeq5xfmbfhrzgx4hpj5bkxqtw6mgku","thumbnail","ipfs://bafybeiguwj7jll23xgh37usasgzapg7n5x2xfbzyat3jyrdthmwv2mufe4","https://gabo.es","layout","displayPublishTime","2025-01-21","seedExperimentalLogo","theme",{"_2412":2413},"headerLayout","Center",1781393346254,[2416,844],"ACCOUNT","[\"ACCOUNT\",\"z6MkrbYsRzKb1VABdvhsDSAk6JK8fAszKsyHhcaZigYeWCou\"]","ssrContentHTML","

Performance report from fresh snapshots at http://localhost:58001/debug/network and /debug/sqlite.

Executive summary

The app is not currently blocked by SQLite lock/busy errors. The main performance problem is still network/discovery sync latency, especially waiting on already-connected peer syncs.

The daemon is doing lots of peer sync attempts; many fail or get preempted, and the successful path often waits seconds.

SQLite health

| Signal | Current state | |---|---:| | Write transactions in flight | None | | Recent SQLITE_BUSY / begin_busy | 0 | | WAL file size | 0 B | | DB size | 4.0 GiB | | Worst write caller | blob.(*Index).PutMany-range1 | | PutMany p99 total | 458 ms | | PutMany p99 hold | 120 ms | | WAL checkpoint p99 | 17.6 ms |

SQLite looks mostly healthy right now:

No active writer lock.
No recent busy timeout events.
WAL is truncated to 0B, so there is no large WAL backlog.
Writes are present, but not dominating wall time.
Some reads are moderately slow:
- ListAccounts p99: 328 ms
- ListEntityMentions p99: 289 ms
- syncing.(*Server).loadStore p99: 156 ms

So: SQLite is contributing some latency, but it is not the current main bottleneck.

Network / sync performance

| Signal | Current state | |---|---:| | Daemon uptime in snapshot | 3m50s | | connected_sync p50 | 4.02 s | | connected_sync p90 | 18.51 s | | connected_sync p99 | 21.09 s | | Discovery connected p50 | 17.34 s | | Discovery connected p99 | 21.29 s | | Dial p99 | 10.85 s | | Reconcile RPC p99 | 1.96 s | | Bitswap fetch p99 | 313 ms |

The bad user-visible delay is:

connected_sync: reconcile + download from connected peers, and it waits for all of them.

That phase has p50 around 4 seconds and p90/p99 around 18–21 seconds.

Sync outcomes

| Outcome | Count | |---|---:| | ok | 1210 | | dial_failed | 3272 | | preempted | 852 | | protocol_mismatch | 243 | | rpc_error | 102 | | putmany_failed | 0 |

This is important:

putmany_failed = 0, so SQLite writes are not failing.
dial_failed = 3272, very high.
preempted = 852, also high.
Many peer sync attempts are wasted or cancelled.

Bandwidth / data movement

| Signal | Current state | |---|---:| | Total traffic since startup | 214.6 MiB | | HTTP server loopback out | 188.7 MiB | | libp2p remote total | 24.7 MiB | | SQLite grew | 3.0 MiB | | Bitswap unique received | 4.5 MiB | | Duplicate bitswap data | 33.4 KiB / 0.7% |

Most traffic is local frontend/backend gRPC-Web loopback, not external network.

Bitswap itself looks healthy:

Fetches complete.
Completeness ratio is 1.00.
Duplicate waste is low.
putmany_failed = 0.

Likely bottleneck

Current bottleneck is:

Frontend asks daemon for document/content\n        ↓\nDaemon runs discovery\n        ↓\nDaemon syncs with many peers\n        ↓\nMany peer syncs dial-fail, timeout, preempt, or take seconds\n        ↓\nconnected_sync waits too long\n        ↓\nUser sees slow app\n

Not:

SQLite locked\n

At least in this snapshot, SQLite is not locked.

What looks wrong

Discovery waits too long on peer syncs
- connected_sync p90 = 18.51s
- connected_sync p99 = 21.09s
Too many failed peer attempts
- dial_failed = 3272
- more failures than successful syncs.
Preemption is high
- preempted = 852
- suggests work starts, then gets cancelled before useful completion.
SQLite is okay now
- no begin_busy
- no in-flight writer
- WAL is 0B
- writes are measurable but not the main pain.

Recommendation to discuss with team

Focus on reducing discovery/network fanout before optimizing SQLite further:

dedupe concurrent discovery requests for the same resource;
reduce number of peers queried per discovery;
stop earlier once enough peers answered/found content;
avoid waiting for all connected peer syncs;
prioritize historically good peers;
cache negative/positive discovery results briefly;
reduce frontend query block requests to daemon.

SQLite should still be watched, especially PutMany and slow reads, but the current app performance issue is primarily network/discovery contention, not SQLite lock contention.

Recap

The app is currently slow mainly because connected_sync takes seconds to tens of seconds, with many dial_failed and preempted peer syncs. SQLite is not currently locked: no writer in flight, no recent begin_busy, no putmany_failed, and the WAL file is 0B.

DB: 4.0 GiB; WAL: 0B.
Worst SQLite write p99: PutMany around 458 ms total, 120 ms hold.
Worst user-visible network phase: connected_sync p99 around 21 s.
Best next fix area: reduce/dedupe/short-circuit discovery peer sync work.

","enableWebSigning","https://nodosdeconocimiento.es","origin","homeMetadata",{"_852":2425,"_1513":57,"_1514":2426,"_1516":2421,"_2409":2427,"_1518":8,"_1519":1520},"Nodos de Conocimiento","ipfs://bafybeici4e4shhiim2mwufsaypj7n6qltsllppzuyy6bel2gvj7vzuoddm","ipfs://bafkreidtocm3drhlggo6euxr4bbxusmtztjdtoq4h5fdoyptq2p6pqtrn4","originHomeId",{"_871":2430,"_37":2431,"_845":2432,"_839":-5,"_873":-5,"_874":-5,"_875":-5,"_876":-5},"z6MkhGQJc96o3UNQ3JyUbCKfQo2bvaQ9KDNa9xxYHJFWWTwg","hm://z6MkhGQJc96o3UNQ3JyUbCKfQo2bvaQ9KDNa9xxYHJFWWTwg",[],"meta",{"_2435":2436,"_2782":2783},"values",{"_2437":2438,"_2440":2441,"_2442":2443,"_2444":2445,"_2447":2448,"_2449":2450,"_2451":2452,"_2454":2455,"_2456":2457,"_2458":2459,"_2460":2461,"_2462":2463,"_2464":2465,"_2466":2467,"_2468":2469,"_2470":2471,"_2472":2473,"_2474":2475,"_2476":2477,"_2478":2479,"_2480":2481,"_2482":2483,"_2484":2485,"_2486":2487,"_2488":2489,"_2490":2491,"_2492":2493,"_2494":2495,"_2496":2497,"_2498":2499,"_2500":2501,"_2502":2503,"_2504":2505,"_2506":2507,"_2508":2509,"_2510":2511,"_2512":2513,"_2514":2515,"_2516":2517,"_2518":2519,"_2520":2521,"_2522":2523,"_2524":2525,"_2526":2527,"_2528":2529,"_2530":2531,"_2532":2533,"_2534":2535,"_2536":2537,"_2538":2539,"_2540":2541,"_2542":2543,"_2544":2545,"_2546":2547,"_2548":2549,"_2550":2551,"_2552":2553,"_2554":2555,"_2556":2557,"_2558":2559,"_2560":2561,"_2562":2563,"_2564":2565,"_2566":2567,"_2568":2569,"_2570":2571,"_2572":2573,"_2574":2575,"_2576":2577,"_2578":2579,"_2580":2581,"_2582":2583,"_2584":2585,"_2586":2587,"_2588":2589,"_2590":2591,"_2592":2593,"_2594":2595,"_2596":2597,"_2598":2599,"_2600":2601,"_2602":2603,"_2604":2605,"_2606":2607,"_2608":2609,"_2610":2611,"_2612":2613,"_2614":2615,"_2616":2617,"_2618":2619,"_2620":2621,"_2622":2623,"_2624":2625,"_2626":2627,"_2628":2629,"_2630":2631,"_2632":2633,"_2634":2635,"_2636":2637,"_2638":2639,"_2640":2641,"_2642":2643,"_2644":2645,"_2646":2647,"_2648":2649,"_2650":2651,"_2652":2653,"_2654":2655,"_2656":2657,"_2658":2659,"_2660":2661,"_2662":2663,"_2664":2665,"_2666":2667,"_2668":2669,"_2670":2671,"_2672":2673,"_2674":2675,"_2676":2677,"_2678":2679,"_2680":2681,"_2682":2683,"_2684":2685,"_2686":2687,"_2688":2689,"_2690":2691,"_2692":2693,"_2694":2695,"_2696":2697,"_2698":2699,"_2700":2701,"_2702":2703,"_2704":2705,"_2706":2707,"_2708":2709,"_2710":2711,"_2712":2713,"_2714":2715,"_2716":2717,"_2718":2719,"_2720":2721,"_2722":2723,"_2724":2725,"_2726":2727,"_2728":2729,"_2730":2731,"_2732":2733,"_2734":2735,"_2736":2737,"_2738":2739,"_2740":2741,"_2742":2743,"_2744":2745,"_2746":2747,"_2748":2749,"_2750":2751,"_2752":2753,"_2754":2755,"_2756":2757,"_2758":2759,"_2760":2761,"_2762":2763,"_2764":2765,"_2766":2767,"_2768":2769,"_2770":2771,"_2772":2773,"_2774":2775,"_2776":2777,"_2778":2779,"_2780":2781},"document.generationInfo.generation",[2439],"bigint","dehydratedState.queries.0.state.data.document.generationInfo.generation",[2439],"dehydratedState.queries.1.state.data.document.generationInfo.generation",[2439],"dehydratedState.queries.1.queryKey.2",[2446],"undefined","dehydratedState.queries.2.state.data.0.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.0.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.0.sortTime",[2453],"Date","dehydratedState.queries.2.state.data.0.activitySummary.latestCommentTime",[2446],"dehydratedState.queries.2.state.data.0.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.0.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.0.redirectInfo",[2446],"dehydratedState.queries.2.state.data.1.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.1.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.1.sortTime",[2453],"dehydratedState.queries.2.state.data.1.activitySummary.latestCommentTime.seconds",[2439],"dehydratedState.queries.2.state.data.1.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.1.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.1.redirectInfo",[2446],"dehydratedState.queries.2.state.data.2.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.2.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.2.sortTime",[2453],"dehydratedState.queries.2.state.data.2.activitySummary.latestCommentTime",[2446],"dehydratedState.queries.2.state.data.2.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.2.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.2.redirectInfo",[2446],"dehydratedState.queries.2.state.data.3.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.3.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.3.sortTime",[2453],"dehydratedState.queries.2.state.data.3.activitySummary.latestCommentTime.seconds",[2439],"dehydratedState.queries.2.state.data.3.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.3.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.3.redirectInfo",[2446],"dehydratedState.queries.2.state.data.4.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.4.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.4.sortTime",[2453],"dehydratedState.queries.2.state.data.4.activitySummary.latestCommentTime",[2446],"dehydratedState.queries.2.state.data.4.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.4.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.4.redirectInfo",[2446],"dehydratedState.queries.2.state.data.5.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.5.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.5.sortTime",[2453],"dehydratedState.queries.2.state.data.5.activitySummary.latestCommentTime.seconds",[2439],"dehydratedState.queries.2.state.data.5.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.5.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.6.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.6.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.6.sortTime",[2453],"dehydratedState.queries.2.state.data.6.activitySummary.latestCommentTime.seconds",[2439],"dehydratedState.queries.2.state.data.6.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.6.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.6.redirectInfo",[2446],"dehydratedState.queries.2.state.data.7.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.7.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.7.sortTime",[2453],"dehydratedState.queries.2.state.data.7.activitySummary.latestCommentTime.seconds",[2439],"dehydratedState.queries.2.state.data.7.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.7.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.7.redirectInfo",[2446],"dehydratedState.queries.2.state.data.8.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.8.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.8.sortTime",[2453],"dehydratedState.queries.2.state.data.8.activitySummary.latestCommentTime",[2446],"dehydratedState.queries.2.state.data.8.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.8.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.8.redirectInfo",[2446],"dehydratedState.queries.2.state.data.9.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.9.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.9.sortTime",[2453],"dehydratedState.queries.2.state.data.9.activitySummary.latestCommentTime.seconds",[2439],"dehydratedState.queries.2.state.data.9.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.9.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.9.redirectInfo",[2446],"dehydratedState.queries.2.state.data.10.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.10.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.10.sortTime",[2453],"dehydratedState.queries.2.state.data.10.activitySummary.latestCommentTime",[2446],"dehydratedState.queries.2.state.data.10.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.10.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.10.redirectInfo",[2446],"dehydratedState.queries.2.state.data.11.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.11.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.11.sortTime",[2453],"dehydratedState.queries.2.state.data.11.activitySummary.latestCommentTime.seconds",[2439],"dehydratedState.queries.2.state.data.11.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.11.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.11.redirectInfo",[2446],"dehydratedState.queries.2.state.data.12.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.12.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.12.sortTime",[2453],"dehydratedState.queries.2.state.data.12.activitySummary.latestCommentTime.seconds",[2439],"dehydratedState.queries.2.state.data.12.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.12.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.12.redirectInfo",[2446],"dehydratedState.queries.2.state.data.13.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.13.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.13.sortTime",[2453],"dehydratedState.queries.2.state.data.13.activitySummary.latestCommentTime.seconds",[2439],"dehydratedState.queries.2.state.data.13.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.13.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.13.redirectInfo",[2446],"dehydratedState.queries.2.state.data.14.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.14.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.14.sortTime",[2453],"dehydratedState.queries.2.state.data.14.activitySummary.latestCommentTime",[2446],"dehydratedState.queries.2.state.data.14.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.14.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.14.redirectInfo",[2446],"dehydratedState.queries.2.state.data.15.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.15.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.15.sortTime",[2453],"dehydratedState.queries.2.state.data.15.activitySummary.latestCommentTime",[2446],"dehydratedState.queries.2.state.data.15.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.15.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.15.redirectInfo",[2446],"dehydratedState.queries.2.state.data.16.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.16.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.16.sortTime",[2453],"dehydratedState.queries.2.state.data.16.activitySummary.latestCommentTime",[2446],"dehydratedState.queries.2.state.data.16.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.16.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.16.redirectInfo",[2446],"dehydratedState.queries.2.state.data.17.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.17.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.17.sortTime",[2453],"dehydratedState.queries.2.state.data.17.activitySummary.latestCommentTime",[2446],"dehydratedState.queries.2.state.data.17.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.17.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.17.redirectInfo",[2446],"dehydratedState.queries.2.state.data.18.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.18.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.18.sortTime",[2453],"dehydratedState.queries.2.state.data.18.activitySummary.latestCommentTime",[2446],"dehydratedState.queries.2.state.data.18.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.18.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.18.redirectInfo",[2446],"dehydratedState.queries.2.state.data.19.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.19.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.19.sortTime",[2453],"dehydratedState.queries.2.state.data.19.activitySummary.latestCommentTime.seconds",[2439],"dehydratedState.queries.2.state.data.19.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.19.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.19.redirectInfo",[2446],"dehydratedState.queries.2.state.data.20.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.20.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.20.sortTime",[2453],"dehydratedState.queries.2.state.data.20.activitySummary.latestCommentTime",[2446],"dehydratedState.queries.2.state.data.20.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.20.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.20.redirectInfo",[2446],"dehydratedState.queries.2.state.data.21.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.21.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.21.sortTime",[2453],"dehydratedState.queries.2.state.data.21.activitySummary.latestCommentTime.seconds",[2439],"dehydratedState.queries.2.state.data.21.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.21.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.21.redirectInfo",[2446],"dehydratedState.queries.2.state.data.22.createTime.seconds",[2439],"dehydratedState.queries.2.state.data.22.updateTime.seconds",[2439],"dehydratedState.queries.2.state.data.22.sortTime",[2453],"dehydratedState.queries.2.state.data.22.activitySummary.latestCommentTime.seconds",[2439],"dehydratedState.queries.2.state.data.22.activitySummary.latestChangeTime.seconds",[2439],"dehydratedState.queries.2.state.data.22.generationInfo.generation",[2439],"dehydratedState.queries.2.state.data.22.redirectInfo",[2446],"dehydratedState.queries.5.state.data.document.generationInfo.generation",[2439],"dehydratedState.queries.5.queryKey.2",[2446],"dehydratedState.queries.6.state.data.document.generationInfo.generation",[2439],"dehydratedState.queries.6.queryKey.2",[2446],"dehydratedState.queries.7.state.data.document.generationInfo.generation",[2439],"dehydratedState.queries.7.queryKey.2",[2446],"dehydratedState.queries.8.state.data.metadata.summary",[2446],"referentialEqualities",{"_2437":2784,"_2449":2785,"_2464":2786,"_2472":2787,"_2478":2788,"_2492":2789,"_2504":2790,"_2506":2791,"_2514":2792,"_2520":2793,"_2532":2794,"_2546":2795,"_2560":2796,"_2574":2797,"_2588":2798,"_2602":2799,"_2616":2800,"_2630":2801,"_2644":2802,"_2658":2803,"_2672":2804,"_2686":2805,"_2700":2806,"_2714":2807,"_2728":2808,"_2742":2809,"_2756":2810},[2440],[2456],[2470],[2768],[2484],[2498],[2518],[2512],[2528,2666,2736],[2526],[2538],[2552],[2566],[2580],[2594],[2608],[2622],[2636],[2650],[2664],[2678],[2692],[2706],[2720],[2734],[2748],[2762],"actionData","errors"]