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
| #!/usr/bin/env bash | |
| last_hash="" | |
| while true; do | |
| clear | |
| if [[ -n "$TMUX" ]]; then | |
| cols=$(tmux display-message -p '#{pane_width}') | |
| lines=$(( $(tmux display-message -p '#{pane_height}') - 2 )) | |
| else |
ngzax
/ index_dupes.sql
Last active
August 29, 2015 14:06
— forked from jberkus/gist:e4cadd6b8877c3bc59c8
Finds duplicate indexes on a PostgreSQL DB
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
| -- check for exact matches | |
| WITH index_cols_ord as ( | |
| SELECT attrelid, attnum, attname | |
| FROM pg_attribute | |
| JOIN pg_index ON indexrelid = attrelid | |
| WHERE indkey[0] > 0 | |
| ORDER BY attrelid, attnum | |
| ), | |
| index_col_list AS ( | |
| SELECT attrelid, |
ngzax
/ remove empty array elements
Created
April 2, 2010 20:56
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
| foreach ($array as $key => $value) { | |
| if (is_null($value) || $value=="") { | |
| unset($array[$key]); | |
| } | |
| } |