Closed Bug 538649 Opened 15 years ago Closed 15 years ago

run sql query against Socorro production for troubleshooting issue

Categories

(Infrastructure & Operations Graveyard :: WebOps: Other, task)

All
Other
task
Not set
critical

Tracking

(Not tracked)

RESOLVED WORKSFORME

People

(Reporter: ozten, Unassigned)

Details

Please run the following query in production to help with troubleshooting a prod issue. select CAST(ceil(EXTRACT(EPOCH FROM (window_end - timestamp without time zone '2009-12-25 00:00:00' - interval '8 hours')) / 86400) AS INT) * interval '24 hours' + timestamp without time zone '2009-12-25 00:00:00' as day, case when os.os_name = 'Windows NT' then 'Windows' when os.os_name = 'Mac OS X' then 'Mac' else os.os_name end as os_name, sum(count) from top_crashes_by_signature tcbs join osdims os on tcbs.osdims_id = os.id and os.os_name in ('Windows','Mac OS X','Linux','Windows NT') where (timestamp without time zone '2009-12-25 00:00:00' - interval '8 hours') < window_end and window_end <= (timestamp without time zone '2010-01-08 00:00:00' - interval '8 hours') and productdims_id = 169 group by day, os_name order by 1, 2; This is a read only query... CCing morgamic for oversight.
I've found another way to troubleshoot this issue.
Status: NEW → RESOLVED
Closed: 15 years ago
Resolution: --- → WORKSFORME
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in before you can comment on or make changes to this bug.