View chrome.sh
#!/bin/sh
export TZ=UTC
/Applications/Google\ Chrome.app/Contents/MacOS/Google\ Chrome &
sleep 10
View 00-log.md

http://techlife.cookpad.com/entry/2016/05/18/180703 を参考に。

$ cp /usr/share/doc/nodejs/guides/doc_img/compare-boxplot.png /tmp/t.png
$ convert -debug Resource t.png -auto-orient -resize "1280x1280>" -quality 90 -strip u.png
  :
2017-11-25T11:39:12-10:00 0:00.550 0.910u 6.9.7 Resource convert-im6.q16[7236]: resource.c/RelinquishMagickResource/1013/Resource
  Memory: 13.11MB/0B/256MiB
View 01-iterm.scpt
on run {input, parameters}
tell application "iTerm"
create window with default profile
activate
end tell
return input
end run
View 01-introduce-buildpack.md

https://github.com/DataDog/heroku-buildpack-datadog

$ heroku buildpacks:add --index 2 https://github.com/DataDog/heroku-buildpack-datadog.git -a zundan-mastodon-experiment
Buildpack added. Next release on zundan-mastodon-experiment will use:
  1. heroku/metrics
  2. https://github.com/DataDog/heroku-buildpack-datadog.git
  3. https://github.com/heroku/heroku-buildpack-apt
  4. heroku/nodejs
  5. heroku/ruby
View Rollbar.txt
ArgumentError: invalid %-encoding (%)
-
78 non-project frames
1 File "/app/vendor/ruby-2.4.2/lib/ruby/2.4.0/uri/common.rb" line 387 in decode_www_form_component
2 File "/app/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/utils.rb" line 51 in unescape
3 File "/app/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/query_parser.rb" line 150 in unescape
4 File "/app/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/query_parser.rb" line 65 in block (2 levels) in parse_nested_query
5 File "/app/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/query_parser.rb" line 65 in map!
6 File "/app/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/query_parser.rb" line 65 in block in parse_nested_query
7 File "/app/vendor/bundle/ruby/2.4.0/gems/rack-2.0.3/lib/rack/query_parser.rb" line 64 in each
View dmesg.txt
usb 4-2: new full-speed USB device number 3 using ohci-pci
usb 4-2: New USB device found, idVendor=1209, idProduct=2301
usb 4-2: New USB device strings: Mfr=1, Product=2, SerialNumber=3
usb 4-2: Product: Model 01
usb 4-2: Manufacturer: Keyboardio
usb 4-2: SerialNumber: ********
input: Keyboardio Model 01 as /devices/pci0000:00/0000:00:12.1/usb4/4-2/4-2:1.2/0003:1209:2301.0005/input/input16
hid-generic 0003:1209:2301.0005: input,hidraw4: USB HID v1.01 Mouse [Keyboardio Model 01] on usb-0000:00:12.1-2/input2
input: Keyboardio Model 01 as /devices/pci0000:00/0000:00:12.1/usb4/4-2/4-2:1.3/0003:1209:2301.0006/input/input17
hid-generic 0003:1209:2301.0006: input,hidraw5: USB HID v1.01 Mouse [Keyboardio Model 01] on usb-0000:00:12.1-2/input3
View index.md

マスター勢いろいろ教えていただいたので、やってみました。

元のクエリ

> EXPLAIN ANALYZE
SELECT "statuses"."id", "statuses"."updated_at" FROM "statuses"
LEFT OUTER JOIN "accounts" ON "accounts"."id" = "statuses"."account_id"
WHERE ("statuses"."local" = TRUE OR "statuses"."uri" IS NULL)
AND "statuses"."visibility" = 0
View 01.sh
$ git clone https://github.com/tootsuite/mastodon.git mastodon-pr515
$ cd mastodon-pr5158
$ git remote add Kjwon15 https://github.com/Kjwon15/mastodon.git
$ git fetch Kjwon15
$ git merge Kjwon15/streaming
$ heroku create
Creating app... done, ⬢ stark-sands-75673
https://stark-sands-75673.herokuapp.com/ | https://git.heroku.com/stark-sands-75673.git
$ heroku buildpacks:add https://github.com/heroku/heroku-buildpack-apt
$ heroku buildpacks:add heroku/nodejs
View ltl.sql
> EXPLAIN ANALYSE SELECT statuses.id, statuses.updated_at FROM statuses LEFT OUTER JOIN accounts a ON a.id = account_id WHERE (local = true OR statuses.uri IS NULL) AND visibility = 0 AND (reblog_of_id IS NULL) AND (not reply OR in_reply_to_account_id = account_id) AND not silenced ORDER BY statuses.id DESC LIMIT 40;
QUERY PLAN
-------------------------------------------------------------------------------------------------------------------------------------------------------------
Limit (cost=0.14..323.77 rows=40 width=16) (actual time=4862.449..8725.201 rows=40 loops=1)
-> Nested Loop (cost=0.14..20947.19 rows=2589 width=16) (actual time=4862.448..8725.184 rows=40 loops=1)
-> Index Scan Backward using statuses_pkey on statuses (cost=0.08..17682.20 rows=2589 width=24) (actual time=4862.429..8724.707 rows=40 loops=1)
Filter: ((local OR (uri IS NULL)) AND (reblog_of_id IS NULL) AND ((NOT reply) OR (in_rep
View with_reblog_is_null.sql
> EXPLAIN ANALYZE SELECT "reblog_of_id" FROM "statuses" WHERE ("reblog_of_id" = 11 OR "reblog_of_id" IS NULL) AND "account_id" = 1 ORDER BY "id" DESC;
QUERY PLAN
-----------------------------------------------------------------------------------------------------------------------------------------------------------
Sort (cost=5391.51..5393.22 rows=3402 width=16) (actual time=49741.632..49741.844 rows=2716 loops=1)
Sort Key: id DESC
Sort Method: quicksort Memory: 224kB
-> Bitmap Heap Scan on statuses (cost=38.43..5351.60 rows=3402 width=16) (actual time=3130.508..49736.730 rows=2716 loops=1)
Recheck Cond: (account_id = 1)
Filter: ((reblog_of_id = 11) OR (reblog_of_id IS NULL))
Rows Removed by Filter: 1167