Skip to content

Instantly share code, notes, and snippets.

@dlangille

dlangille/gist:3cac9530676e371a0919b17934cea81d

Created September 1, 2019 16:08
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 dlangille/3cac9530676e371a0919b17934cea81d to your computer and use it in GitHub Desktop.
Save dlangille/3cac9530676e371a0919b17934cea81d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT P.path || FN.name as file,
F.lstat,
pg_size_pretty( base64_decode_lstat(8, lstat) ) as size
FROM job J, file F, filename FN, path P
WHERE J.jobid = 295603
AND J.jobid = F.jobid
AND F.filenameid = FN.filenameid
AND F.pathid = P.pathid
ORDER BY 1;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment