Page MenuHomeSoftware Heritage
Paste P1533

Command-Line Input
ActivePublic

Authored by olasd on Nov 30 2022, 3:01 PM.
=> select name, instance_name, scheduler_metrics.* from scheduler_metrics inner join listers on id=lister_id where name='save-code-now';
─[ RECORD 1 ]────────────────┬─────────────────────────────────────
name │ save-code-now
instance_name │ archive.softwareheritage.org
lister_id │ 860d41f8-d0c0-4733-a4d8-437c386bc31f
visit_type │ bzr
last_update │ 2022-11-30 12:38:36.165068+00
origins_known │ 2
origins_enabled │ 2
origins_never_visited │ 0
origins_with_pending_changes │ 0
─[ RECORD 2 ]────────────────┼─────────────────────────────────────
name │ save-code-now
instance_name │ archive.softwareheritage.org
lister_id │ 860d41f8-d0c0-4733-a4d8-437c386bc31f
visit_type │ git
last_update │ 2022-11-30 12:38:36.165068+00
origins_known │ 57220
origins_enabled │ 57170
origins_never_visited │ 0
origins_with_pending_changes │ 0
─[ RECORD 3 ]────────────────┼─────────────────────────────────────
name │ save-code-now
instance_name │ archive.softwareheritage.org
lister_id │ 860d41f8-d0c0-4733-a4d8-437c386bc31f
visit_type │ hg
last_update │ 2022-11-30 12:38:36.165068+00
origins_known │ 76
origins_enabled │ 44
origins_never_visited │ 1
origins_with_pending_changes │ 0
─[ RECORD 4 ]────────────────┼─────────────────────────────────────
name │ save-code-now
instance_name │ archive.softwareheritage.org
lister_id │ 860d41f8-d0c0-4733-a4d8-437c386bc31f
visit_type │ svn
last_update │ 2022-11-30 12:38:36.165068+00
origins_known │ 93
origins_enabled │ 73
origins_never_visited │ 0
origins_with_pending_changes │ 0