jberkus noticed in the database logs that the 'topcrashurlfactsreports' table is a write only data sink. The 'topCrashesByUrl' cron job writes to that table, but nothing ever reads the data inserted into it. There should be a little research done to see if we can just eliminate it.
http://mozilla.privatepaste.com/baf66c8cd0 (10:36:20 AM) jberkus: and that one seq scan is from when I did a pg_dump
This was never assgned to anyone, so it never happened. Assigning it and making it live, since we're still getting records in that table.
Assignee: nobody → rhelmer
Target Milestone: --- → 2.3
The cron job has been fixed. I'm now assigning the bug to myself so that I can drop the table and get rid of it.
Assignee: rhelmer → josh
This was committed and run as part of 2.2.6. I don't understand why it's been reopened; that table is gone.
Status: NEW → RESOLVED
Last Resolved: 7 years ago
Resolution: --- → FIXED
Component: Socorro → General
Product: Webtools → Socorro
You need to log in before you can comment on or make changes to this bug.