run sql query against Socorro production for troubleshooting issue

RESOLVED WORKSFORME

Status

--
critical
RESOLVED WORKSFORME
9 years ago
5 years ago

People

(Reporter: ozten, Unassigned)

Tracking

Details

(Reporter)

Description

9 years ago
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.
(Reporter)

Comment 1

9 years ago
I've found another way to troubleshoot this issue.
Status: NEW → RESOLVED
Last Resolved: 9 years ago
Resolution: --- → WORKSFORME
Component: Server Operations: Web Operations → WebOps: Other
Product: mozilla.org → Infrastructure & Operations
You need to log in before you can comment on or make changes to this bug.