Skip to content

Instantly share code, notes, and snippets.

@angerman

angerman/gist:3e36cf6b3bbe156f3ff72e8e6dc11c3e Secret

Created December 10, 2019 16:30
Show Gist options
  • Save angerman/3e36cf6b3bbe156f3ff72e8e6dc11c3e to your computer and use it in GitHub Desktop.
Save angerman/3e36cf6b3bbe156f3ff72e8e6dc11c3e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
sqlite> select id, 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;
id pct location
---------- ---------- --------------------------------------------------------------------------------------------------------------------
2 0.560508 undefined position
7626473 0.415297 /nix/store/09qcj1bfpdxbcq8c2f9byblxidp0p1pk-nix-2.4pre7146_98ef116/share/nix/corepkgs/derivation.nix:8:12
7485830 0.010015 /nix/store/5zbv9dp1v2ibs1cmy92x39rjqg5f8kr5-source/builder/shell-for.nix:19:13
13253401 0.006560 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/top-level/all-packages.nix:7269:21
13311690 0.006543 /nix/store/09qcj1bfpdxbcq8c2f9byblxidp0p1pk-nix-2.4pre7146_98ef116/share/nix/corepkgs/derivation.nix:8:12
13246499 0.001056 (string):1:2
7626361 0.000007 undefined position
13246492 0.000006 (string):1:2
7626285 0.000005 undefined position
13311670 0.000001 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/stdenv/generic/make-derivation.nix:278:18
7626464 0.000001 /nix/store/75y8imsw20c1r0y1hb4l45qpk3szrpw3-nixpkgs/pkgs/stdenv/generic/make-derivation.nix:278:18
1 0.000000 undefined position
13311664 0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/shells/bash/4.4.nix:23:74
13253398 0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/top-level/splice.nix:128:17
13394915 0.000000 /nix/store/09qcj1bfpdxbcq8c2f9byblxidp0p1pk-nix-2.4pre7146_98ef116/share/nix/corepkgs/derivation.nix:18:19
13311669 0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/stdenv/generic/make-derivation.nix:4:15
13311668 0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/stdenv/generic/make-derivation.nix:4:15
13394916 0.000000 /nix/store/09qcj1bfpdxbcq8c2f9byblxidp0p1pk-nix-2.4pre7146_98ef116/share/nix/corepkgs/derivation.nix:18:19
13311662 0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/shells/bash/4.4.nix:23:18
13253400 0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/top-level/all-packages.nix:7269:21
13311663 0.000000 /nix/store/b9jjs2d5vaxpgyhbah6c14f3822icgln-nixpkgs-19.09pre191265.c4adeddb5f8/nixpkgs/pkgs/shells/bash/4.4.nix:23:18
7626284 0.000000 /nix/store/5zbv9dp1v2ibs1cmy92x39rjqg5f8kr5-source/builder/shell-for.nix:20:28
sqlite> select id, printf("%.6f",time/(select sum(time)*1.0 from prof where parent == -1)) as pct, name as location from prof where parent == 2 order by time desc;
id pct location
---------- ---------- --------------------------------------------------------------------------------------------------------------------
4 0.560495 /Users/angerman/Projects/iohk/hokey-pokey/shell.nix:2:2
7485706 0.000011 /Users/angerman/Projects/iohk/hokey-pokey/default.nix:50:11
3 0.000002 /Users/angerman/Projects/iohk/hokey-pokey/shell.nix:2:2
sqlite> select id, printf("%.6f",time/(select sum(time)*1.0 from prof where parent == -1)) as pct, name as location from prof where parent == 4 order by time desc;
id pct location
---------- ---------- --------------------------------------------------------------------------------------------------------------------
6715 0.559668 /Users/angerman/Projects/iohk/hokey-pokey/default.nix:17:13
7 0.000813 /Users/angerman/Projects/iohk/hokey-pokey/default.nix:1:10
5 0.000010 /Users/angerman/Projects/iohk/hokey-pokey/default.nix:1:10
6641 0.000004 /nix/store/5zbv9dp1v2ibs1cmy92x39rjqg5f8kr5-source/overlays/ghc.nix:27:6
6710 0.000000 /nix/store/75y8imsw20c1r0y1hb4l45qpk3szrpw3-nixpkgs/lib/attrsets.nix:344:15
6709 0.000000 /nix/store/75y8imsw20c1r0y1hb4l45qpk3szrpw3-nixpkgs/lib/attrsets.nix:344:15
6640 0.000000 /nix/store/5zbv9dp1v2ibs1cmy92x39rjqg5f8kr5-source/overlays/ghc.nix:27:6
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment