Best results in other decks

...connection summary: SELECT COUNT(*) AS cnt, usename FROM pg_stat_activity GROUP BY usename ORDER BY cnt DESC; Open transactions with their minimum needed transaction ID SELECT pid, datname, usename...

...state, backend_xmin FROM pg_stat_activity WHERE backend_xmin IS NOT NULL ORDER BY age(backend_xmin) DESC; Transactions To get the current transaction ID: SELECT * FROM txid_current...

...an SQL query. It simply returns a scope object for further chaining with #where, #order, etc. Scopes will make an SQL query when you use them like an array, e.g...

...an SQL query. It simply returns a scope object for further chaining with #where, #order, etc. It can be confusing that typing a scope into the Rails console will immediately...