swh-storage=# select * from origin_visit where origin=424 ; origin | visit | date | type | status | metadata | snapshot --------+-------+-------------------------------+------+---------+----------+-------------------------------------------- 424 | 1 | 2019-08-14 10:02:03.190532+00 | gnu | partial | | 424 | 2 | 2019-08-14 10:02:46.964868+00 | gnu | full | | \x1f3305edbd687c27ca005f7cafea3d6f809c38d1 424 | 3 | 2019-08-14 10:13:38.41934+00 | gnu | full | | \x1f3305edbd687c27ca005f7cafea3d6f809c38d1 (3 rows) =# select * from snapshot where id='\x1f3305edbd687c27ca005f7cafea3d6ff809c38d1'; object_id | id -----------+-------------------------------------------- 9 | \x1f3305edbd687c27ca005f7cafea3d6f809c38d1 (1 row)