I wanted to write a query using the postgres distinct on language feature. However, when looking through the documentation for this method I can see it's been marked as depreciated as of version 1.4.

#To get blocking SQL statements (these only find row-level locks, not object-level locks). SELECT blocked_locks.pid AS blocked_pid, blocked_activity.usename AS blocked_user, blocking_locks.pid AS ...