How Do PostgreSQL Indices Work, Anyways?

You've created hundreds of indexes but do you know what's actually happening underneath? B-tree internals, page splits, MVCC bloat, and the diagnostic queries to see it all for yourself.