3 ms·
A recent work Slack chat had a dev asking what a particular table contained. They were going through our data inventory and found a randomly-named table 18TB in
by kstrauser 8y ago
A recent work Slack chat had a dev asking what a particular table contained. They were going through our data inventory and found a randomly-named table 18TB in size. When I ran "select count()" against it, I got back 5,325,451,020,708 rows (that's a copy-and-paste).
50GB isn't trivial, but it's utterly manageable.
- Aeolun 8y agoIt seems a bit wrong if you have a 18TB table but no idea what it contains...
- kstrauser 8y agoIt was a temp table that we hadn't garbage collected yet. We don't make a habit of leaving that much junk data around, but it bumped our monthly storage bill several percent, not like tripled it.