Skip to content

Instantly share code, notes, and snippets.

Keybase proof

I hereby claim:

  • I am jzavisek on github.
  • I am jzavisek (https://keybase.io/jzavisek) on keybase.
  • I have a public key ASDI3x-Rt3qrfgCLchrrBL8iXdhC0R15GzPpVT4WAu9Y4go

To claim this, I am signing this object:

{
"Object.getPrototypeOf": {
"prefix": "op",
"body": "Object.getPrototypeOf(${0})"
},
"Object.getOwnPropertyNames": {
"prefix": "opn",
"body": "Object.getOwnPropertyNames(${0})"
},
"setTimeout": {
@jzavisek
jzavisek / all-indexes.sql
Created June 12, 2019 09:46 — forked from robertrossmann/all-indexes.sql
Postgres diagnostics
-- List all existing indexes and include some useful info about them (incl. the index's definition)
SELECT
schemaname AS schemaname,
t.relname AS tablename,
ix.relname AS indexname,
regexp_replace(pg_get_indexdef(i.indexrelid), '^[^\(]*\((.*)\)$', '\1') AS columns,
regexp_replace(pg_get_indexdef(i.indexrelid), '.* USING ([^ ]*) \(.*', '\1') AS algorithm,
indisunique AS UNIQUE,
indisprimary AS PRIMARY, indisvalid AS valid,
@jzavisek
jzavisek / iterm2-solarized.md
Created January 3, 2017 09:56 — forked from kevin-smets/iterm2-solarized.md
iTerm2 + Oh My Zsh + Solarized color scheme + Meslo powerline font (OS X / macOS)

Solarized