Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
-- average time (in days) since a line of code was last modified
-- broken out by file path
SELECT
path,
AVG(julianday(datetime('now')) - julianday(author_when)) AS avg_age
FROM files, blame('', '', path)
JOIN commits ON hash = commit_hash
GROUP BY path
ORDER BY avg_age
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment