Skip to content

Instantly share code, notes, and snippets.

@patrickdevivo

patrickdevivo/avg_age.sql Secret

Created September 11, 2021 14:01
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/88dc509c591da856c855674b4f208c37 to your computer and use it in GitHub Desktop.
Save patrickdevivo/88dc509c591da856c855674b4f208c37 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
avg_age.sql
-- average time (in days) since a line of code was last modified
SELECT
AVG(julianday(datetime('now')) - julianday(author_when)) AS avg_age
FROM files, blame('', '', path)
JOIN commits ON hash = commit_hash ORDER BY avg_age
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment