Skip to content

Instantly share code, notes, and snippets.

View skehlet's full-sized avatar

Steve Kehlet skehlet

9 followers · 4 following
View GitHub Profile
@skehlet
skehlet / gist:a35f0436ba071bd7feca
Created January 7, 2015 21:51
function my_explode($delimiter, $string, $limit = null) {
$array = call_user_func_array('explode', func_get_args());
if (count($array) === 1 && strlen($array[0]) === 0) {
return array();
}
return $array;
}
@skehlet
skehlet / gist:36aad599171b25826e82
Created May 6, 2015 17:45
Show autovacuum and analyze data, including if the next autovacuum will be a freeze; and how close the table is to being force-freezed
WITH table_opts AS (
SELECT
pg_class.oid, relname, nspname, array_to_string(reloptions, '') AS relopts
FROM
pg_class INNER JOIN pg_namespace ns ON relnamespace = ns.oid
), storage_settings AS (
SELECT
oid, relname, nspname,
CASE
WHEN relopts LIKE '%autovacuum_vacuum_threshold%'
@skehlet
skehlet / gist:592b00c1e4b381c83099
Created May 6, 2015 17:45
schema | table | rowcount | dead_rowcount | autovacuum_threshold | expect_autovacuum | relfrozenxid_age | autovacuum_freeze_table_age | next_autovacuum_will_be_a_freeze | autovacuum_freeze_max_age | % til forced vacuum freeze
---------+---------+----------------+----------------+----------------------+-------------------+------------------+-----------------------------+----------------------------------+---------------------------+----------------------------
public | table01 | 1,336,112,512 | 4,641,856 | 267,222,552 | | 165311956 | 1.5e+08 | yes | 2e+08 | 82.7%
public | table02 | 777,657,088 | 20,662,775 | 155,531,468 | | 165311956 | 1.5e+08 | yes | 2e+08 | 82.7%
public | table03 | 642,018,368 | 9 | 128,403,724 | | 165311956 |
@skehlet
skehlet / gist:bcdbc1ce1f212d3b7bb2
Created May 26, 2015 23:36
mydb=> SELECT name, current_setting(name), source
mydb-> FROM pg_settings
mydb-> WHERE source NOT IN ('default', 'override');
name | current_setting | source
---------------------------------+------------------+--------------------
application_name | psql | client
archive_command | exit 0 | configuration file
archive_mode | on | configuration file
autovacuum | on | configuration file
autovacuum_analyze_scale_factor | 0.1 | configuration file
@skehlet
skehlet / gist:3589b0d83f2cafe19624
Created May 27, 2015 22:07
listen_addresses = '*'
port = 5432
max_connections = 300
shared_buffers = 2GB
work_mem = 10MB
maintenance_work_mem = 256MB
max_stack_depth = 8MB
wal_buffers = 16MB
checkpoint_segments = 32
checkpoint_completion_target = .9
@skehlet
skehlet / gist:8244928
Created January 3, 2014 19:34
2014/01/03 11:24:26 Packer Version: 0.5.1 eeefde8fc71444fdfc77711dc0e2789fa9b3b7d2
2014/01/03 11:24:26 Packer Target OS/Arch: darwin amd64
2014/01/03 11:24:26 Built with Go Version: go1.2
2014/01/03 11:24:26 Detected home directory from env var: /Users/stevek
2014/01/03 11:24:26 Attempting to open config file: /Users/stevek/.packerconfig
2014/01/03 11:24:26 File doesn't exist, but doesn't need to. Ignoring.
2014/01/03 11:24:26 Packer config: &{PluginMinPort:0 PluginMaxPort:0 Builders:map[amazon-ebs:packer-builder-amazon-ebs digitalocean:packer-builder-digitalocean googlecompute:packer-builder-googlecompute virtualbox-ovf:packer-builder-virtualbox-ovf vmware-iso:packer-builder-vmware-iso amazon-chroot:packer-builder-amazon-chroot amazon-instance:packer-builder-amazon-instance docker:packer-builder-docker openstack:packer-builder-openstack qemu:packer-builder-qemu virtualbox-iso:packer-builder-virtualbox-iso vmware-vmx:packer-builder-vmware-vmx] Commands:map[build:packer-command-build fix:packer-command-fix in
@skehlet
skehlet / gist:8564020
Created January 22, 2014 18:07
My FreeNAS box's dmesg
freenas# dmesg | less
Copyright (c) 1992-2013 The FreeBSD Project.
Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994
The Regents of the University of California. All rights reserved.
FreeBSD is a registered trademark of The FreeBSD Foundation.
FreeBSD 9.2-RELEASE #0 r+2315ea3: Fri Dec 20 12:48:50 PST 2013
root@build.ixsystems.com:/tank/home/jkh/checkout/freenas/os-base/amd64/tank/home/jkh/checkout/freenas/FreeBSD/src/sys/FREENAS.amd64 amd64
gcc version 4.2.1 20070831 patched [FreeBSD]
CPU: Intel(R) Xeon(R) CPU E3-1230 v3 @ 3.30GHz (3292.44-MHz K8-class CPU)
Origin = "GenuineIntel" Id = 0x306c3 Family = 0x6 Model = 0x3c Stepping = 3
@skehlet
skehlet / gist:8564107
Created January 22, 2014 18:13
My FreeNAS box's /data/crash/textdump.tar.last
freenas# less textdump.tar.last
"textdump.tar.last" may be a binary file. See it anyway?
ddb.txt^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@0600^@^@^@^@0^@^@^@^@^@^@^@0^@^@^@^@^@^@^@140000^@^@^@^@^@^@12267724774^@ 7114^@ ^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@ustar^@^@^@root^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@wheel^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@
^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@^@
@skehlet
skehlet / gist:08aeed3d06f1c35bc780
Created March 17, 2016 18:58
my custom postgres settings
postgres=# SELECT version();
version
---------------------------------------------------------------------------------------------------------------
PostgreSQL 9.4.5 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-44), 64-bit
(1 row)
postgres=# SELECT name, current_setting(name), SOURCE
postgres-# FROM pg_settings
postgres-# WHERE SOURCE NOT IN ('default', 'override');
name | current_setting | source
@skehlet
skehlet / gist:47c7f92daa0bd3d1a3aee2bb001da140
Created May 17, 2016 00:05
postgres=# SELECT version();
version
---------------------------------------------------------------------------------------------------------------
PostgreSQL 9.4.4 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.1.2 20080704 (Red Hat 4.1.2-44), 64-bit
(1 row)
postgres=# SELECT name, current_setting(name), SOURCE
postgres-# FROM pg_settings
postgres-# WHERE SOURCE NOT IN ('default', 'override');
name | current_setting | source