Docker Image Cleanup

I’ve been playing with Docker off and on for almost a year and noticed that I have a lot of abandoned images on my system that are left over from experimenting.  This post contains a few commands you can use to clean up your system. To illustrate what I mean by “abandoned images”, here’s the output […]

How Big is My Database?

Here’s a nice snippet that can be used in a PostgreSQL database to output the current database’s size. SELECT pg_size_pretty(pg_database_size(current_database())) AS human_size,        pg_database_size(current_database())                 AS raw_size; That statement will output something along the lines of: human_size | raw_size ————+————– 181 GB | 193841573064