softwareheritage=> \conninfo
You are connected to database "softwareheritage" as user "guest" on host "somerset.internal.softwareheritage.org" at port "5433".
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-AES256-GCM-SHA384, bits: 256, compression: off)
softwareheritage=> select * from origin where type='deposit' and url like '%hal-01767263%';
┌────┬──────┬─────┬────────┬─────────┐
│ id │ type │ url │ lister │ project │
├────┼──────┼─────┼────────┼─────────┤
└────┴──────┴─────┴────────┴─────────┘
(0 rows)

softwareheritage=> \conninfo
You are connected to database "softwareheritage" as user "guest" on host "db.internal.softwareheritage.org" at port "5432".
SSL connection (protocol: TLSv1.2, cipher: ECDHE-RSA-CHACHA20-POLY1305, bits: 256, compression: off)

softwareheritage=> select * from origin where type='deposit' and url like '%hal-01767263%';
┌──────────┬─────────┬───────────────────────────────────────────────┬────────┬─────────┐
│    id    │  type   │                      url                      │ lister │ project │
├──────────┼─────────┼───────────────────────────────────────────────┼────────┼─────────┤
│ 83805995 │ deposit │ https://hal.archives-ouvertes.fr/hal-01767263 │ ¤      │ ¤       │
└──────────┴─────────┴───────────────────────────────────────────────┴────────┴─────────┘
(1 row)

Time: 102.345 ms