Recent Posts

(TIL) PSQL: List Connections To A Database

less than 1 minute read

The pg_stat_activity table can be used to determine what connections there currently are to the PostgreSQL server and to a particular database. To see the pr...

(TIL) PSQL: Sleeping

less than 1 minute read

Generally you want your SQL statements to run against your database as quickly as possible. For those times when you are doing some sort of debugging or just...