Mar 23 2009 AFS failure analysis
Content service events
Sat Mar 14 btwn 15:10 and 15:50:
Event | count |
|---|---|
content.revise | 1 |
content.read | 250 |
content.new | 25 |
Sat Mar 28 btwn 15:10 and 15:50:
Event | count |
|---|---|
content.read | 105 |
Sat Apr 25 btwn 15:10 and 15:50:
Event | count |
|---|---|
content.delete | 1 |
content.read | 158 |
content.new | 31 |
Sat May 23 btwn 15:10 and 15:50:
Event | count |
|---|---|
content.revise | 1 |
content.read | 95 |
content.new | 7 |
Count of all types of events, Sat May 23 and day before:
(Last Sat of Spring Quarter)
SELECT TO_CHAR(event_date, 'YYYY-MM-DD HH24') AS Hour,
COUNT(*) AS Events
FROM sakai_event
where
EVENT like 'content.%'
and event_date > to_date('May 22, 2009 00:10', 'Mon dd, YYYY HH24:mi')
and event_date < to_date('May 23, 2009 23:50', 'Mon dd, YYYY HH24:mi')
GROUP BY TO_CHAR(event_date, 'YYYY-MM-DD HH24')
ORDER BY 1;
results:
Day | hour | #-events |
|---|---|---|
2009-05-22 | 00 | 1674 |
2009-05-22 | 01 | 1985 |
2009-05-22 | 02 | 1912 |
2009-05-22 | 03 | 2519 |
2009-05-22 | 04 | 2480 |
2009-05-22 | 05 | 2746 |
2009-05-22 | 06 | 2336 |
2009-05-22 | 07 | 1661 |
2009-05-22 | 08 | 1058 |
2009-05-22 | 09 | 678 |