psql service=staging-swh
psql (11.7, server 11.6 (Debian 11.6-1.pgdg100+1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.

swh=> select * from origin o inner join origin_visit ov on o.id=ov.origin where o.url='https://nix-community.github.io/nixpkgs-swh/sources-unstable.json';
  id   |                                url                                | origin | visit |             date              |  type   | status  | metadata |                  snapshot
-------+-------------------------------------------------------------------+--------+-------+-------------------------------+---------+---------+----------+--------------------------------------------
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     1 | 2020-04-02 15:29:27.811603+00 | nixguix | partial |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     2 | 2020-04-02 18:06:32.201307+00 | nixguix | partial |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     3 | 2020-04-03 14:02:31.593289+00 | nixguix | partial |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     4 | 2020-04-03 14:44:48.514733+00 | nixguix | partial |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     5 | 2020-04-04 09:55:51.907641+00 | nixguix | partial |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     6 | 2020-04-06 08:29:27.431316+00 | nixguix | partial |          |
 37576 | https://nix-community.github.io/nixpkgs-swh/sources-unstable.json |  37576 |     7 | 2020-04-07 16:08:56.976561+00 | nixguix | partial |          | \x3a810cbc026b7bc147b535392babbda85942f906