Skip to content

Instantly share code, notes, and snippets.

@angerman
Created December 10, 2019 16:25
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 angerman/68eca2ee18e3f4ff057cd08501a934a5 to your computer and use it in GitHub Desktop.
Save angerman/68eca2ee18e3f4ff057cd08501a934a5 to your computer and use it in GitHub Desktop.
sqlite> select printf("%.6f",time/(select sum(time)*1.0 from prof where parent == -1)) as pct, name as location from prof where parent == -1 order by time desc;
pct location
---------- --------------------------------------------------------------------------------------------------------------------
0.560508 undefined position
0.415297 /nix/store/09qcj1bfpdxbcq8c2f9byblxidp0p1pk-nix-2.4pre7146_98ef116/share/nix/corepkgs/derivation.nix:8:12
0.010015 /nix/store/5zbv9dp1v2ibs1cmy92x39rjqg5f8kr5-source/builder/shell-for.nix:19:13
0.006560 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/top-level/all-packages.nix:7269:21
0.006543 /nix/store/09qcj1bfpdxbcq8c2f9byblxidp0p1pk-nix-2.4pre7146_98ef116/share/nix/corepkgs/derivation.nix:8:12
0.001056 (string):1:2
0.000007 undefined position
0.000006 (string):1:2
0.000005 undefined position
0.000001 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/stdenv/generic/make-derivation.nix:278:18
0.000001 /nix/store/75y8imsw20c1r0y1hb4l45qpk3szrpw3-nixpkgs/pkgs/stdenv/generic/make-derivation.nix:278:18
0.000000 undefined position
0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/shells/bash/4.4.nix:23:74
0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/top-level/splice.nix:128:17
0.000000 /nix/store/09qcj1bfpdxbcq8c2f9byblxidp0p1pk-nix-2.4pre7146_98ef116/share/nix/corepkgs/derivation.nix:18:19
0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/stdenv/generic/make-derivation.nix:4:15
0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/stdenv/generic/make-derivation.nix:4:15
0.000000 /nix/store/09qcj1bfpdxbcq8c2f9byblxidp0p1pk-nix-2.4pre7146_98ef116/share/nix/corepkgs/derivation.nix:18:19
0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/shells/bash/4.4.nix:23:18
0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/top-level/all-packages.nix:7269:21
0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/shells/bash/4.4.nix:23:18
0.000000 /nix/store/5zbv9dp1v2ibs1cmy92x39rjqg5f8kr5-source/builder/shell-for.nix:20:28
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment