Table sizes, largest first

Sql

Where the disk actually went, including indexes and TOAST.

SELECT
  relname,
  pg_size_pretty(pg_total_relation_size(relid)) AS total,
  pg_size_pretty(pg_relation_size(relid)) AS heap
FROM pg_catalog.pg_statio_user_tables
ORDER BY pg_total_relation_size(relid) DESC
LIMIT 20;

Download

Databases postgres disk sizes chris

More in Databases

Delete duplicate rows, keeping the oldest Databases Uses a window function to number the duplicates and removes everything but the first of each group. Reset a Postgres sequence after a bulk import Databases Copying rows with explicit ids leaves the identity sequence behind, so the next insert collides with an existing row. Find slow queries in Postgres Databases Ranks statements by total time spent. Needs the pg_stat_statements extension enabled. Upsert a row in SQLite Databases Inserts, or updates the existing row when the unique column already holds that value. Which indexes is nobody using? Databases Lists indexes that have never been scanned, which are pure write cost. Check against a long uptime before dropping any. Group rows into a JSON array Databases Returns one row per author with their posts nested, instead of a join that repeats the author on every row. Add a column without locking the table Databases On Postgres 11 and later a nullable column with a default is a metadata-only change. Adding NOT NULL afterwards is the part that needs care.

Random picks

Responsive grid without media queries Web & CSS auto-fill with minmax reflows on its own, so the column count follows the container rather than a breakpoint list. Narrow a union with a type guard TypeScript A predicate returning `x is T` teaches the compiler what a runtime check proved. Freeze time in a test Testing Node's mock timers make anything date-dependent deterministic without injecting a clock everywhere. Fetch with a timeout JavaScript fetch has no timeout of its own. AbortSignal.timeout is the short way to give it one. Prepared statement with PDO PHP Placeholders rather than interpolation. This is the whole of SQL injection defence in PHP. Merge dictionaries Python The | operator returns a new dict; |= updates in place. Later keys win in both. Context with a timeout in Go Systems Cancels the request and everything downstream of it after two seconds. The defer is not optional. Stop tracking a file without deleting it Git For the config file that should never have been committed. Add it to .gitignore afterwards.