SamsadSajid

// add the followings in the vscode settings.json
// Credit: James King

"explorer.fileNesting.patterns":{
    "*.ts": "${capture}.test.ts",
    "*.go": "${capture}_test.go",
    "*.js": "${capture}.js.map, ${capture}.min.js, ${capture}.d.ts, ${capture}.test.js",
    "*.jsx": "${capture}.test.jsx",
    "*.tsx": "${capture}.test.tsx",
    "tsconfig.json": "tsconfig.*.json",

SamsadSajid

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=

SamsadSajid

https://api.github.com/gists/0a6b62974bee90234ec863b12c361f38

SamsadSajid

https://api.github.com/gists/7a5807ad3af247f5e0a1b6e337fd3b2f

SamsadSajid

https://api.github.com/gists/669e7d2fb306870068bf0ee5fa99dcee

SamsadSajid

https://api.github.com/gists/c5c58ef2231d6a177bb9f8a2ad9c9332

SamsadSajid

https://api.github.com/gists/04e8c9dbaa4969401daeb528a602e048