Closed Bug 668670 Opened 13 years ago Closed 13 years ago

Fix TCBU query, indexes

Categories

(Socorro :: General, task)

Product:
Socorro
Component:
General
Platform:
x86
macOS
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED WONTFIX

People

(Reporter: jberkus, Assigned: jberkus)

Details

Currently we're doing reports like this against TCBU:

			SELECT 
				sum(tcu.count) as count, 
				at.domain, at.rank
	        FROM top_crashes_by_url tcu 
	 		JOIN urldims ud 
				ON tcu.urldims_id = ud.id
				AND '2011-06-16' <= (tcu.window_end - tcu.window_size)
	            AND tcu.window_end < '2011-06-30'
			JOIN productdims pd 
				ON pd.id = tcu.productdims_id
	            AND pd.product = 'Firefox'
	            AND pd.version = '4.0.1'
			JOIN alexa_topsites at ON ud.domain LIKE '%' || at.domain
	        GROUP BY at.domain, at.rank
	        ORDER BY count DESC
	        LIMIT 100 OFFSET 0

The problem with this is that we're completely unable to use an index for the time dimension on that query.  Both the query and the TCBU indexes need to be adjusted.

That's assuming we don't kill TCBU entirely in 2.1, of course.
Target Milestone: 2.1 → 2.2
TCBU is being dropped or replaced in 2.2, so this bug will become obsolete.
Status: NEW → RESOLVED
Closed: 13 years ago
Resolution: --- → WONTFIX
Component: Socorro → General
Product: Webtools → Socorro
You need to log in before you can comment on or make changes to this bug.