Useful queries against zsh-histdb

zsh-histdb-queries.sql

-- start sqlite monitor with _histdb_query

-- most-often used commands; top ones at the bottom
SELECT 
  commands.argv, count(*) as invocation_count
FROM 
  history 
LEFT JOIN 
    commands 
  ON 
    history.command_id = commands.rowid
LEFT JOIN 
    places 
  ON 
    history.place_id = places.rowid
GROUP BY 
  commands.argv 
ORDER BY 
  invocation_count ASC
;