[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Bug#79493: http://nm.debian.org/ is broken

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

Something is broken there.


-- System Information
Debian Release: woody
Architecture: i386
Kernel: Linux dual 2.2.17 #1 SMP Mon Sep 4 06:13:20 CEST 2000 i686

Reply to: