Page MenuHomeSoftware Heritage
Paste P1233

debian lister with last_update
ActivePublic

Authored by anlambert on Dec 3 2021, 4:02 PM.
(swh) ✔ ~/swh/swh-environment/docker [master|✚ 1⚑ 41]
16:01 $ doco exec swh-scheduler /bin/bash
swh@ab68bb37fea4:/$ psql service=swh-scheduler
psql (12.9 (Debian 12.9-1.pgdg110+1), server 12.8 (Debian 12.8-1.pgdg100+1))
Type "help" for help.
swh-scheduler=# select url, last_update from listed_origins where last_update is not null limit 10;
url | last_update
-------------------------------------------+------------------------
deb://Debian/packages/bitwise | 2021-10-09 09:17:41+00
deb://Debian/packages/bkchem | 2020-07-18 10:40:51+00
deb://Debian/packages/black | 2021-10-09 10:19:51+00
deb://Debian/packages/black-box | 2020-07-18 10:40:51+00
deb://Debian/packages/blackbird-gtk-theme | 2020-07-18 10:40:51+00
deb://Debian/packages/blackbox | 2020-07-18 10:40:51+00
deb://Debian/packages/blackbox-themes | 2020-07-18 10:40:51+00
deb://Debian/packages/ttf-summersby | 2020-07-18 10:40:51+00
deb://Debian/packages/blastem | 2021-10-09 10:19:51+00
deb://Debian/packages/bleachbit | 2020-07-18 10:40:51+00
(10 rows)
swh-scheduler=#