inouire

With regular grep:

sudo grep -RI --exclude-dir={proc,sys,dev,run,tmp} "_PRD" /

or if ripgrep is installed:

sudo rg "_PRD" /

inouire

WITH bloat AS (
  SELECT
    ns.nspname AS schema,
    c.relname AS "table",
    pg_relation_size(c.oid)::bigint AS physical_size,
    (8192::bigint * c.relpages) AS expected_size
  FROM
    pg_catalog.pg_class c
    JOIN pg_catalog.pg_namespace ns ON ns.oid = c.relnamespace
  WHERE

inouire

def regex(str) = str =~ /^https?:\/\//i

def starts_with(str)
  str.start_with?("http://") || str.start_with?("https://")
end

strings = [
  "https://example.com",
  "http://example.com",
  "example1",

inouire

grep -nr search_string search_dir

inouire

xinput # to list devices
alias trackpadoff="xinput disable \"AlpsPS/2 ALPS DualPoint Stick\""
alias trackpadon="xinput enable \"AlpsPS/2 ALPS DualPoint Stick\""

inouire

$requires_index = {}

if true
    # Override the require method to track load times
  def custom_require(file)
    starting = Process.clock_gettime(Process::CLOCK_MONOTONIC)
    
    result   = original_require(file)
    
    ending   = Process.clock_gettime(Process::CLOCK_MONOTONIC)

inouire

bundle show nokogiri
/home/edouard/.rbenv/versions/2.7.2/lib/ruby/gems/2.7.0/gems/nokogiri-1.13.8-x86_64-linux

inouire

SELECT
  pid,
  now() - pg_stat_activity.query_start AS duration,
  query,
  state
FROM pg_stat_activity
WHERE (now() - pg_stat_activity.query_start) > interval '5 minutes';

SELECT pg_cancel_backend(__pid__);

inouire

Limit disk space used by Git

Short on disk space ? Using Git?

$ git fetch --all --prune
$ du -sh .git && git gc --aggressive && du -sh .git
13M     .git
Enumerating […]
6.5M .git

inouire

Pick a date, pick a branch, here you go

git checkout `git rev-list -n 1 --first-parent --before="2019-07-27 13:37" master`