Skip to content

Instantly share code, notes, and snippets.

@isaaclw

isaaclw/db age

Created September 17, 2021 19:43
Show Gist options
  • Save isaaclw/21bc71b1866aa48c35697e28bf76073b to your computer and use it in GitHub Desktop.
Save isaaclw/21bc71b1866aa48c35697e28bf76073b to your computer and use it in GitHub Desktop.
Download ZIP
Postgresql database age #postgres #age #database
Raw
db age
SELECT (pg_stat_file('base/'||oid ||'/PG_VERSION')).modification, datname FROM pg_database;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment