diff -r d3593869d624 -r 0cef3540b69f pgtoolkit/pgstats.py --- a/pgtoolkit/pgstats.py Thu May 31 11:28:41 2012 +0200 +++ b/pgtoolkit/pgstats.py Mon Jul 09 10:29:47 2012 +0200 @@ -44,6 +44,7 @@ return self._query('''SELECT datname, procpid, usename, current_query AS query, waiting, xact_start, query_start, backend_start FROM pg_stat_activity - WHERE current_query <> '' AND query_start < now() - interval %s;''', + WHERE current_query <> '' AND query_start < now() - interval %s + ORDER BY query_start;''', longer_than)