Lace up your boots and let’s take a hike through your Postgres database internals. We’ll first step off the beaten path of the ORM and start our hike learning commands for interacting with the Postgres command line, psql. We’ll climb through some of Postgres’ system tables and special functions that tell you about your database from the inside. We’ll train your eyes on several important signs for debugging and knowing what’s going on inside your database. I’ll include special stops for looking at activity, queries, locks, and connections.