gistfile1.txt

[root@system76:~]# sqlite3 /nix/var/nix/db/db.sqlite
SQLite version 3.22.0 2018-01-22 18:45:57
Enter ".help" for usage hints.
sqlite> .mode line
sqlite> select * from ValidPaths where path = "/nix/store/qrxs7sabhqcr3j9ai0j0cp58zfnny0jz-coreutils-8.29";
              id = 157219
            path = /nix/store/qrxs7sabhqcr3j9ai0j0cp58zfnny0jz-coreutils-8.29
            hash = sha256:0b3d9eae63e9934c05a40a9024351c26af0c70f5b41c14e188f2bb31dead30d2
registrationTime = 1525049585
         deriver = /nix/store/hixdnzz2wp75x1jy65cysq06yl74vx7q-coreutils-8.29.drv
         narSize = 10721792
        ultimate =
            sigs = cache.nixos.org-1:9HR2wWUfc16Itri0KS3p2rFJtuwtRQI3E0NdaFrjpObH4AkFd3XeXwd9WfZlw2AhOWdQI8UNK0yNHjEZYK9SCA== system76.angeldsis.com-1:bADy7+IZBcwUfMgjMiEb7YEVzD6jlzYJyKcDSVrPlGyO0In17hn3M8Voyc/opVTrNZasiA9LHheiWuhThaN2Dw==
              ca =
sqlite> select path from ValidPaths where id in (select reference from Refs where referrer = 157219);
 path = /nix/store/84h2zni7h805k0i1ys2bba3dsp1cqnhh-glibc-2.26-131

 path = /nix/store/w5vxs0xrvxnz4qpgcbqhvavnbdnf8k6c-attr-2.4.47

 path = /nix/store/hr386dzm459zc9q82ylwcgwci7jqwzfz-acl-2.2.52

 path = /nix/store/qrxs7sabhqcr3j9ai0j0cp58zfnny0jz-coreutils-8.29