Craig announces a suite of useful queries for Postgres in our command line tool. Quickly find cache hit ratio, table sizes, locks, long running queries, indexes, and more in the new query menu for Crunchy Bridge.
Bob helps you fix some common Kubernetes installation issues. He shows you the right order of things, how to fix a missing image, and some common resource allocation errors.
One process can lock your Postgres database, dominating all will, blocking other processes and queries. Jesse shows you how to find that one process that’s ruling them all. Once you’ve grabbed this lock and held it close to your chest, he’ll help you on your quest to cast it into the depths of Mt Doom.
Did you know you can see all the queries psql uses when running \d+? Yeah, it's called echo, and you can see all queries for all commands. Check out our tutorial.
Postgres data delivered straight into Google Sheets! Walk through using pg_featureserv to create JSON and pg_svg to create accompanying SVG images directly from your database and into spreadsheets.
