diff -r 7f219da7ab71 -r 5fb4883604d6 longqueries.py --- a/longqueries.py Fri Jan 13 15:49:24 2012 +0100 +++ b/longqueries.py Tue Feb 07 10:40:35 2012 +0100 @@ -1,6 +1,7 @@ #!/usr/bin/env python3.2 from pgtoolkit import pgstats, toolbase +from pgtoolkit.highlight import highlight class LongQueriesTool(toolbase.SimpleTool): @@ -11,9 +12,9 @@ def main(self): stats = pgstats.PgStats(self.pgm.get_conn('target')) - for ln in stats.list_long_queries(): + for ln in stats.list_long_queries('0m'): + print(highlight(1), 'backend PID: ', ln['procpid'], ', query_start: ', ln['query_start'].strftime('%F %T'), highlight(0), sep='') print(ln['query']) - print(' ', 'query_start:', ln['query_start'].strftime('%F %T')) print()