Skip to content

Instantly share code, notes, and snippets.

@patrickdevivo

patrickdevivo/avg_age_by_file.sql Secret

Created September 11, 2021 14:15
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save patrickdevivo/f5ebbe0f0de0be2b8012427ab2736608 to your computer and use it in GitHub Desktop.
Save patrickdevivo/f5ebbe0f0de0be2b8012427ab2736608 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
avg_age_by_file.sql
-- 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