Wyatt Alt wkalt
wkalt
/ gist:55627692f9869569845c
Created
August 20, 2014 16:22
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| BEFORE | |
| QUERY PLAN | |
| --------------------------------------------------------------------------------------------------------------------- | |
| Delete on fact_values (cost=150.14..394.27 rows=4166 width=6) (actual time=6.300..6.300 rows=0 loops=1) | |
| -> Seq Scan on fact_values (cost=150.14..394.27 rows=4166 width=6) (actual time=6.298..6.298 rows=0 loops=1) | |
| Filter: (NOT (hashed SubPlan 1)) | |
| Rows Removed by Filter: 8331 | |
| SubPlan 1 | |
| -> Seq Scan on facts (cost=0.00..129.31 rows=8331 width=8) (actual time=0.011..1.299 rows=8331 loops=1) | |
| Total runtime: 6.440 ms |
wkalt
/ gist:a5153029cee57b85d122
Created
August 20, 2014 18:32
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Timing is on. | |
| QUERY PLAN | |
| ------------------------------------------------------------------------------------------------------------------------------- | |
| Delete on fact_values (cost=0.00..5089117.29 rows=2391 width=6) (actual time=49146.897..49146.897 rows=0 loops=1) | |
| -> Seq Scan on fact_values (cost=0.00..5089117.29 rows=2391 width=6) (actual time=49146.889..49146.889 rows=0 loops=1) | |
| Filter: (NOT (SubPlan 1)) | |
| Rows Removed by Filter: 4782 | |
| SubPlan 1 | |
| -> Materialize (cost=0.00..1930.48 rows=79165 width=8) (actual time=0.002..5.415 rows=35234 loops=4782) | |
| -> Seq Scan on facts (cost=0.00..1224.65 rows=79165 width=8) (actual time=0.018..16.359 rows=79141 loops=1) |
wkalt
/ gist:b8f81e0f12def8471042
Created
August 21, 2014 00:18
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2000 nodes, 100 facts per node, 85% duplicated | |
| NO INDEX INDEX | |
| schema | name | size | index | ratio | total schema | name | size | index | ratio | total | |
| --------------------+------------------------------------+------------+---------+-------+--------- --------------------+------------------------------------+------------+---------+-------+--------- | |
| public | facts | 25 MB | 25 MB | 50% | 50 MB public | facts | 25 MB | 25 MB | 50% | 50 MB | |
| public | fact_paths | 8712 kB | 18 MB | 68% | 26 MB public | fact_paths | 8712 kB | 33 MB | 80% | 42 MB | |
| public |
wkalt
/ gist:42792c53a5dc9f0840c4
Created
August 21, 2014 00:22
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 2000 nodes, 100 facts per node, 85% duplicated | |
| NO INDEX INDEX | |
| schema | name | size | index | ratio | total schema | name | size | index | ratio | total | |
| --------------------+------------------------------------+------------+---------+-------+--------- --------------------+------------------------------------+------------+---------+-------+--------- | |
| public | facts | 25 MB | 25 MB | 50% | 50 MB public | facts | 25 MB | 25 MB | 50% | 50 MB | |
| public | fact_paths | 8712 kB | 18 MB | 68% | 26 MB public | fact_paths | 8712 kB | 33 MB | 80% | 42 MB | |
| public |
wkalt
/ gist:09225b71588c35674827
Created
August 21, 2014 00:37
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 200 nodes, 100 facts per node, 72% duplication | |
| WITH DISTINCT | |
| QUERY PLAN | |
| ------------------------------------------------------------------------------------------------------------------------------------- | |
| Delete on fact_values (cost=11211.39..11990.39 rows=13080 width=6) (actual time=174.480..174.480 rows=0 loops=1) | |
| -> Seq Scan on fact_values (cost=11211.39..11990.39 rows=13080 width=6) (actual time=174.473..174.473 rows=0 loops=1) | |
| Filter: (NOT (hashed SubPlan 1)) | |
| Rows Removed by Filter: 26935 | |
| SubPlan 1 |
wkalt
/ gist:f4179dc92a1975893815
Created
September 24, 2014 23:08
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"commits":[{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T23:21:46Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T22:33:25Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T22:30:34Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T22:13:20Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T21:58:51Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T20:54:48Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T20:45:30Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T20:30:03Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T20:27:37Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T20:25:19Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T20:21:54Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"201 |
wkalt
/ gist:e26d6124c7fa36f8bfbc
Created
September 24, 2014 23:08
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"commits":[{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T23:21:46Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T22:33:25Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T22:30:34Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T22:13:20Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T21:58:51Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T20:54:48Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T20:45:30Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T20:30:03Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T20:27:37Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T20:25:19Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"2014-09-23T20:21:54Z"},{"events":[],"object":"test","subject":"api_user","timestamp":"201 |
wkalt
/ gist:e18a03a6a8446ced1f5e
Created
September 25, 2014 00:05
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| curl -X PUT -H 'Content-Type: application/json' \ | |
| -d '{ "name": "apache", | |
| "environment": "production", | |
| "parameters": { | |
| "confd_dir": "/etc/apache2", | |
| "mod_dir": "/etc/apache2/mods-available", | |
| "logroot": "/var/log/apache2" | |
| } | |
| }' \ | |
| --key ./dev-resources/ssl/key.pem --cert ./dev-resources/ssl/cert.pem -k \ |
wkalt
/ gist:6b08adacb62ce627ec85
Created
October 2, 2014 18:01
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| q_all_in_one_install=n | |
| q_continue_or_reenter_master_hostname=c | |
| q_database_install=n | |
| q_fail_on_unsuccessful_master_lookup=y | |
| q_install=y | |
| q_puppet_cloud_install=n | |
| q_puppet_enterpriseconsole_install=n | |
| q_puppetagent_certname=scratch.debian | |
| q_puppetagent_install=y | |
| q_puppetagent_server=puppet |
wkalt
/ gist:0cd00891cde742df58dd
Created
October 9, 2014 13:19
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /var/lib/puppet/log/masterhttp.log | |
| [2014-10-09 12:59:15] INFO WEBrick::HTTPServer#start: pid=3409 port=8140 | |
| [2014-10-09 12:59:15] ERROR OpenSSL::SSL::SSLError: SSL_accept SYSCALL returned=5 errno=0 state=unknown state | |
| /usr/lib/ruby/vendor_ruby/puppet/network/http/webrick.rb:35:in `accept' | |
| /usr/lib/ruby/vendor_ruby/puppet/network/http/webrick.rb:35:in `block (2 levels) in listen' | |
| /usr/lib/ruby/1.9.1/webrick/server.rb:191:in `call' | |
| /usr/lib/ruby/1.9.1/webrick/server.rb:191:in `block in start_thread' | |
| [2014-10-09 12:59:17] INFO going to shutdown ... | |
| [2014-10-09 12:59:17] INFO WEBrick::HTTPServer#start done. |