zozo

mc_stage=# EXPLAIN SELECT DISTINCT construction_id
mc_stage-# FROM surfaces
mc_stage-# WHERE 
mc_stage-# (id IN (SELECT surface_id FROM stocks WHERE interval IN ('M1212', 'D11212', 'D21212', 'D31212')  AND status IN (1,2,3,4)))
mc_stage-# ;
                                                   QUERY PLAN                                                   
----------------------------------------------------------------------------------------------------------------
 HashAggregate  (cost=11763.63..11835.57 rows=7194 width=4)
   ->  Nested Loop  (cost=10647.01..11745.64 rows=7194 width=4)
         ->  HashAggregate  (cost=10647.01..10652.21 rows=520 width=4)

zozo

mc_production=# EXPLAIN SELECT DISTINCT construction_id
mc_production-# FROM surfaces
mc_production-# WHERE
mc_production-# (id IN (SELECT surface_id FROM stocks WHERE interval IN ('M1212', 'D11212', 'D21212', 'D31212')  AND status IN (1,2,3,4)))
mc_production-# ;
                                                   QUERY PLAN
-----------------------------------------------------------------------------------------------------------------
 HashAggregate  (cost=56154.68..56503.41 rows=34873 width=4)
   ->  Nested Loop  (cost=53131.33..56067.50 rows=34873 width=4)
         ->  HashAggregate  (cost=53131.33..53136.56 rows=523 width=4)

zozo

App = new Backbone.Marionette.Application()

App.addRegions
  content: "body"

class Model extends Backbone.Model
class Models extends Backbone.Collection
  model: Model

class ItemView extends Backbone.Marionette.ItemView

zozo

[zozo@ZozoW520:/media/c/Program Files (x86)/Sierra Wireless Inc/Gobi/Images/3000/Generic]$ ll `find ./*` | grep -v total | grep -v ' \.'

./0:
-rwxrwxrwx 2 root root  439 Mar 27 08:24 ImageInfo.xml
-rwxrwxrwx 1 root root  29K Jan 20  2011 uqcn.mbn

./1:
-rwxrwxrwx 1 root root 9.2M Feb  4  2011 amss.mbn
-rwxrwxrwx 2 root root  305 Mar 27 08:24 ImageInfo.xml
-rwxrwxrwx 1 root root  35K Feb  4  2011 uqcn.mbn

zozo

Sep  7 12:07:50 ZozoW520 NetworkManager[909]: <info> Activation (ttyUSB1) starting connection 'Excelcomindo (XL) connection 1'
Sep  7 12:07:50 ZozoW520 NetworkManager[909]: <info> (ttyUSB1): device state change: disconnected -> prepare (reason 'none') [30 40 0]
Sep  7 12:07:50 ZozoW520 NetworkManager[909]: <info> Activation (ttyUSB1) Stage 1 of 5 (Device Prepare) scheduled...
Sep  7 12:07:50 ZozoW520 NetworkManager[909]: <info> Activation (ttyUSB1) Stage 1 of 5 (Device Prepare) started...
Sep  7 12:07:50 ZozoW520 NetworkManager[909]: <info> (ttyUSB1): device state change: prepare -> need-auth (reason 'none') [40 60 0]
Sep  7 12:07:50 ZozoW520 NetworkManager[909]: <info> Activation (ttyUSB1) Stage 1 of 5 (Device Prepare) complete.
Sep  7 12:07:50 ZozoW520 NetworkManager[909]: <info> Activation (ttyUSB1) Stage 1 of 5 (Device Prepare) scheduled...
Sep  7 12:07:50 ZozoW520 NetworkManager[909]: <info> Activation (ttyUSB1) Stage 1 of 5 (Device Prepare) started...
Sep  7 12:07:50 ZozoW520 NetworkManager[909]: <info>

zozo

mc_development=# EXPLAIN select distinct surface_id from prices;
                                               QUERY PLAN                                               
--------------------------------------------------------------------------------------------------------
 Unique  (cost=0.00..58326.38 rows=87660 width=4)
   ->  Index Scan using index_prices_on_surface_id on prices  (cost=0.00..57102.49 rows=489558 width=4)
(2 rows)

mc_development=# EXPLAIN select distinct surface_id from stocks;
                             QUERY PLAN                              
---------------------------------------------------------------------

zozo

bash "install rvm" do
  user project_id
  environment ({'HOME' => "/home/#{user_id}"}) 
  code "curl -L get.rvm.io | bash -s stable; echo '[[ -s \"$HOME/.rvm/scripts/rvm\" ]] && . \"$HOME/.rvm/scripts/rvm\"' >> ~/.bashrc"
  not_if "test -d /home/#{project_id}/.rvm"
end

bash "install ruby #{ruby_version}" do
  user project_id
  environment ({'HOME' => "/home/#{user_id}"}) 

zozo

We couldn’t find that file to show.

zozo

# before patch
$ time be rspec spec
......
Finished in 52.15 seconds
417 examples, 0 failures

real	0m54.319s
user	0m47.183s
sys	0m2.356s