Taskcluster/Deprecated/Query Historical Tasks

From MozillaWiki
< Taskcluster
Revision as of 19:43, 14 July 2017 by Djmitche (talk | contribs) (Created page with "_NOTE_: this is currently a proof-of-concept, and this data is not available via an API or anything like that. [https://github.com/taskcluster/taskcluster-rfcs/issues/49 Soon...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

_NOTE_: this is currently a proof-of-concept, and this data is not available via an API or anything like that. Soon! 

   heroku psql -a taskcluster-task-analysis

The `tasks` table is the one you want to look at. Use `\d tasks` to see its columns. It is not particularly well-indexed, so queries may take a while! Temporary tables are helpful (they will be dropped when you exit the session): 

   create temporary table mystuff as select ...
Retrieved from "https://wiki.mozilla.org/index.php?title=Taskcluster/Deprecated/Query_Historical_Tasks&oldid=1175778"