Skip to content

Instantly share code, notes, and snippets.

View mattsoldo's full-sized avatar

Matthew Soldo mattsoldo

25 followers · 4 following
  • Google
  • San Francisco, CA
View GitHub Profile
@mattsoldo
mattsoldo / keybase.md
Created August 24, 2017 17:15

Keybase proof

I hereby claim:

  • I am mattsoldo on github.
  • I am mattsoldo (https://keybase.io/mattsoldo) on keybase.
  • I have a public key ASC5-ZXn5Y8UTuVrHFyiwSHZohhLBR0C1TneQs3U9gvCbgo

To claim this, I am signing this object:

@mattsoldo
mattsoldo / alsa-info.txt.sif5wCzfdq
Created February 8, 2017 01:04
upload=true&script=true&cardinfo=
!!################################
!!ALSA Information Script v 0.4.64
!!################################
!!Script ran on: Wed Feb 8 00:30:22 UTC 2017
!!Linux Distribution
!!------------------
@mattsoldo
mattsoldo / construction-quality-copy.txt
Created December 20, 2016 00:48
# Minimum Standard
* A the most simple home that meets building code
* 7 1/2 - 8 foot ceilings
* Concrete or common brick exterior walls
* Drop ceiling
* Less than 10 light fixtures
### Bathrooms
@mattsoldo
mattsoldo / Matt Soldo Christmas 2016.md
Last active December 1, 2016 18:51
@mattsoldo
mattsoldo / pg_index_cache_hit_rate.sql
Last active March 15, 2022 18:26
Postgres Index Hit Rate and Cache Hit Rate
-- Index hit rate
WITH idx_hit_rate as (
SELECT
relname as table_name,
n_live_tup,
round(100.0 * idx_scan / (seq_scan + idx_scan),2) as idx_hit_rate
FROM pg_stat_user_tables
ORDER BY n_live_tup DESC
),
@mattsoldo
mattsoldo / gist:2625185
Created May 7, 2012 00:43
PostgreSQL Index hit percentage by table
SELECT
schemaname::text,
relname::text,
seq_tup_read,
idx_tup_fetch,
seq_tup_read + idx_tup_fetch as total_reads,
round(100 * idx_tup_fetch / (seq_tup_read + idx_tup_fetch)) as idx_read_pct,
pg_size_pretty(pg_total_relation_size(relid)) as total_size
FROM
pg_stat_user_tables
@mattsoldo
mattsoldo / msoldo_rails_template.rb
Created April 24, 2010 18:21
def heroku(command = {})
in_root do
if command.is_a?(Symbol)
log 'running', "heroku #{command}"
run "heroku #{command}"
else
command.each do |command, options|
log 'running', "heroku #{command} #{options}"
run("heroku #{command} #{options}")
end
@mattsoldo
mattsoldo / hassle.rb
Created April 19, 2010 06:31
# Tell Hassle to look for sass templates in app/stylesheets
Sass::Plugin.options[:template_location] = "app/stylesheets"
@mattsoldo
mattsoldo / gist:357873
Created April 6, 2010 17:53
ssh-rsa AAAAB3NzaC1yc2EAAAABIwAAAQEApOiYbMEzcQpqLybNQ6p0sCj93MhQEBtCkFLMDjRJds9H8QLL5zBS3PAEJSMw5Bjk4Je6JjVPTZJsOSggadhoiueTCjAwJfs7ORZaV7UBlXHjsTvA02XbF4rAahSeygrvsmlTG/9+9pDoZD5I+Cp7EnKsFebeO0pi8YB6eKfOclhqZS91VwLkIGuwkvB+s5lAyaLRf5hky3BYOLqPsfaNHhuExyvSEE6/8AH+NOAtnGFyMF0VJpini+EsZngIpH5Fx2Qph2ErVMT3azLs+GBWXfDrePgNNl2cEsxkF8qHQboJqlGs2kbbPI5bscjO0g74QwQFN5AXs3Eo+uxgs9jG8Q== soldo@Matthew-Soldos-MacBook-Pro.local