munckymagik

PostgreSQL - EXPLAIN cheatsheet

• -> Marks the start of info on a "plan node"
• Work from the leaves to the root to understand what happened first

(cost=0.00..5.04 rows=101 width=0)

• (cost=

AleenaCodes

This requires imgcat to be installed

• Download the GIFs provided or select your own (make sure the file names are consecutive numbers)
• Navigate into the git hooks folder (under .git/hooks in the repo) and create a file called post-commit
• Add the following into the file

#!/bin/sh

echo 

romainl

Vim: pushing built-in features beyond their limits

The situation

Searching can be an efficient way to navigate the current buffer.

The first search commands we learn are usually / and ?. These are seriously cool, especially with the incsearch option enabled which lets us keep typing to refine our search pattern. / and ? really shine when all we want is to jump to something we already have our eyeballs on but they are not fit for every situation:

• when we want to search something that's not directly there, those two commands can make us lose context very quickly,
• when we need to compare the matches.