Skip to content

Instantly share code, notes, and snippets.

View csuhta's full-sized avatar
🔮
Afloat in the multiverse

Corey Csuhta csuhta

🔮
Afloat in the multiverse
View GitHub Profile
@csuhta
csuhta / keybase.md
Created July 14, 2014 19:20
Keybase proof of identity

Keybase proof

I hereby claim:

  • I am csuhta on github.
  • I am csuhta (https://keybase.io/csuhta) on keybase.
  • I have a public key whose fingerprint is 6604 B53E D8FB 9833 E24E 9818 4FCD 5E61 A219 690A

To claim this, I am signing this object:

WITH table_scans as (
SELECT relid,
tables.idx_scan + tables.seq_scan as all_scans,
( tables.n_tup_ins + tables.n_tup_upd + tables.n_tup_del ) as writes,
pg_relation_size(relid) as table_size
FROM pg_stat_user_tables as tables
),
all_writes as (
SELECT sum(writes) as total_writes
FROM table_scans
$cBlack: #16161D;
$cLightGrey: #DDD;
$cMedGrey: #AEAEAE;
$cGrey: #9B9B9B;
$cDarkGrey: #535353;
$cCodeWash: #F5F6F7;
$cWhite: #FEFEFE;
$cPlum: #343242;
$cRaisn: #5F4F66;