Regarding: " It's just a SQLite command you execute like CREATE INDEX. "
I feel sure Simon was thinking of "EXPLAIN". For the sqlite analyzer visit the download page:
<code> <https://www.sqlite.org/download.html></code>
and download the "bundle of command-line tools" for your machine, or compile from source as needed.
The analyzer is a separate program you'll run from your commandline ("terminal") as follows:
<code> sqlite3_analyzer filespecOfYourDatabase >MyAnalyzeOutput.txt</code>
Then post here the contents of MyAnalyzeOutput.txt, or link to it from somewhere like pastebin.com.
Unrelated question: The field "attributes" is labeled JSON. Is this field's contents always small?