Package: www.debian.org
Version: N/A; reported 2000-12-13
Severity: normal
...
Aggregate Statistics
To give you some idea of the size of the application process and
where, as a whole, applicants are in the
system we have provided some overall statistics. The waiting times
are taken from data for the last two
months and are incremental for each stage except for the 'New
Maintainers Processed' line which is the
total time from application to becoming a new maintainer.
SELECT date_part('epoch', age(manager_date,apply_date))/86400
FROM applicant WHERE
manager_date IS NOT NULL AND age('now'::date, manager_date) < '2
months' AND manager_date>
apply_date ORDER by age(manager_date,apply_date) LIMIT
1 OFFSET 99
35.0416666666667 SELECT date_part('epoch',
age(am_confirm_date,manager_date))/86400 FROM
applicant WHERE am_confirm_date IS NOT NULL AND
age('now'::date, am_confirm_date) < '2
months' AND am_confirm_date> manager_date ORDER by
age(am_confirm_date,manager_date) LIMIT
1 OFFSET 27
2 SELECT date_part('epoch',
age(am_contact,am_confirm_date))/86400 FROM applicant WHERE
am_contact IS NOT NULL AND age('now'::date, am_contact) < '2
months' AND am_contact>
am_confirm_date ORDER by age(am_contact,am_confirm_date)
LIMIT 1 OFFSET 3
1 SELECT date_part('epoch', age(decision,am_contact))/86400 FROM
applicant WHERE decision IS
NOT NULL AND age('now'::date, decision) < '2 months' AND
decision> am_contact ORDER by
age(decision,am_contact) LIMIT 1 OFFSET 64
20 SELECT date_part('epoch', age(newmaint,decision))/86400 FROM
applicant WHERE newmaint IS
NOT NULL AND age('now'::date, newmaint) < '2 months' AND
newmaint> decision ORDER by
age(newmaint,decision) LIMIT 1 OFFSET 38
8 SELECT date_part('epoch', age(newmaint,apply_date))/86400 FROM
applicant WHERE newmaint IS
NOT NULL AND age('now'::date, newmaint) < '2 months' AND
newmaint> apply_date ORDER by
age(newmaint,apply_date) LIMIT 1
OFFSET 41
Something is broken there.
MfG
Goswin
-- System Information
Debian Release: woody
Architecture: i386
Kernel: Linux dual 2.2.17 #1 SMP Mon Sep 4 06:13:20 CEST 2000 i686
