Changeset View
Changeset View
Standalone View
Standalone View
swh/scheduler/sql/30-schema.sql
| Show First 20 Lines • Show All 166 Lines • ▼ Show 20 Lines | create table origin_visit_stats ( | ||||
| last_eventful timestamptz, | last_eventful timestamptz, | ||||
| last_uneventful timestamptz, | last_uneventful timestamptz, | ||||
| last_failed timestamptz, | last_failed timestamptz, | ||||
| last_notfound timestamptz, | last_notfound timestamptz, | ||||
| -- visit scheduling information | -- visit scheduling information | ||||
| last_scheduled timestamptz, | last_scheduled timestamptz, | ||||
| -- last snapshot resulting from an eventful visit | -- last snapshot resulting from an eventful visit | ||||
| last_snapshot bytea, | last_snapshot bytea, | ||||
| successive_visits int default 0, | |||||
| primary key (url, visit_type) | primary key (url, visit_type) | ||||
| ); | ); | ||||
| comment on column origin_visit_stats.url is 'Origin URL'; | comment on column origin_visit_stats.url is 'Origin URL'; | ||||
| comment on column origin_visit_stats.visit_type is 'Type of the visit for the given url'; | comment on column origin_visit_stats.visit_type is 'Type of the visit for the given url'; | ||||
| comment on column origin_visit_stats.last_eventful is 'Date of the last eventful event'; | comment on column origin_visit_stats.last_eventful is 'Date of the last eventful event'; | ||||
| comment on column origin_visit_stats.last_uneventful is 'Date of the last uneventful event'; | comment on column origin_visit_stats.last_uneventful is 'Date of the last uneventful event'; | ||||
| comment on column origin_visit_stats.last_failed is 'Date of the last failed event'; | comment on column origin_visit_stats.last_failed is 'Date of the last failed event'; | ||||
| comment on column origin_visit_stats.last_notfound is 'Date of the last notfound event'; | comment on column origin_visit_stats.last_notfound is 'Date of the last notfound event'; | ||||
| comment on column origin_visit_stats.last_scheduled is 'Time when this origin was scheduled to be visited last'; | comment on column origin_visit_stats.last_scheduled is 'Time when this origin was scheduled to be visited last'; | ||||
| comment on column origin_visit_stats.last_snapshot is 'sha1_git of the last visit snapshot'; | comment on column origin_visit_stats.last_snapshot is 'sha1_git of the last visit snapshot'; | ||||
| comment on column origin_visit_stats.successive_visits is 'number of successive visits with the same status'; | |||||
| create table scheduler_metrics ( | create table scheduler_metrics ( | ||||
| lister_id uuid not null references listers(id), | lister_id uuid not null references listers(id), | ||||
| visit_type text not null, | visit_type text not null, | ||||
| last_update timestamptz not null, | last_update timestamptz not null, | ||||
| origins_known int not null default 0, | origins_known int not null default 0, | ||||
| origins_enabled int not null default 0, | origins_enabled int not null default 0, | ||||
| Show All 14 Lines | |||||