{
  "@context":[
    "https://www.w3.org/ns/activitystreams",
    {"Hashtag":"as:Hashtag"}
  ],
  "published":"2023-11-27T23:32:52.654Z",
  "attributedTo":"https://epiktistes.com/actors/toddsundsted",
  "to":["https://www.w3.org/ns/activitystreams#Public"],
  "cc":["https://epiktistes.com/actors/toddsundsted/followers"],
  "content":"<p>i added code to log slow queries in <a href=\"https://github.com/toddsundsted/ktistec\">ktistec</a> and it's already paying dividends. most are obviously missing indexes and it's great to fix them, but the latest example—which <em>is</em> missing an index—is querying a table that only has <em>one row</em> (in my single user instance). should that table <em>need</em> an index on that column? i mean, just return that row...</p><p>fwiw, a slow query is currently anything that takes longer than 50msec. i wonder if that is tight enough...?</p><p><a href=\"https://epiktistes.com/tags/ktistec\" class=\"hashtag\" rel=\"tag\">#ktistec</a></p>",
  "mediaType":"text/html",
  "attachment":[],
  "tag":[
      {"type":"Hashtag","name":"#ktistec","href":"https://epiktistes.com/tags/ktistec"}
  ],
  "type":"Note",
  "id":"https://epiktistes.com/objects/yAuFh0pW9qk"
}