Confirmed users
513
edits
Auto-tools/Projects/ActiveData/Redshift: Difference between revisions
Jump to navigation
Jump to search
m
Auto-tools/Projects/ActiveData/Redshift (view source)
Revision as of 20:16, 18 March 2015
, 18 March 2015formatting
Klahnakoski (talk | contribs) m (fixlink) |
Klahnakoski (talk | contribs) m (formatting) |
||
| Line 54: | Line 54: | ||
<pre>sql> select distinct "etl.source.source.id" from test_results where "build.date" is null | <pre>sql> select distinct "etl.source.source.id" from test_results where "build.date" is null | ||
500 row(s) retrieved starting from 0 in 194/35642 ms</pre> | </pre><pre>500 row(s) retrieved starting from 0 in 194/35642 ms</pre> | ||
During loading I realized a majority of the records were corrupted by the ETL. Good to know you can wipe out your database quickly! | During loading I realized a majority of the records were corrupted by the ETL. Good to know you can wipe out your database quickly! | ||
| Line 68: | Line 68: | ||
<pre>sql> select count(1) from test_results | <pre>sql> select count(1) from test_results | ||
441,619,970 | 441,619,970 | ||
1 row(s) retrieved starting from 0 in 5/1891 ms</pre> | </pre><pre>1 row(s) retrieved starting from 0 in 5/1891 ms</pre> | ||
I do not know what pathologically bad thing happened here. Again, probably multiple COPY commands filling the work queue. | I do not know what pathologically bad thing happened here. Again, probably multiple COPY commands filling the work queue. | ||
| Line 77: | Line 77: | ||
<pre>sql> select count(*) from test_results | <pre>sql> select count(*) from test_results | ||
1,156,126,589 | 1,156,126,589 | ||
1 row(s) retrieved starting from 0 in 7/6154 ms</pre> | </pre><pre>1 row(s) retrieved starting from 0 in 7/6154 ms</pre> | ||
Finally, the canonical representative: Chunk timings by platform from the past full week: | Finally, the canonical representative: Chunk timings by platform from the past full week: | ||