diff -r a921669e913a -r 4fe39c59c515 longqueries.py --- a/longqueries.py Wed Sep 26 16:21:59 2012 +0200 +++ b/longqueries.py Wed Sep 26 16:28:28 2012 +0200 @@ -1,7 +1,7 @@ #!/usr/bin/env python3.2 from pgtoolkit import pgstats, toolbase -from pgtoolkit.highlight import highlight +from pgtoolkit.highlight import highlight, YELLOW, BOLD class LongQueriesTool(toolbase.SimpleTool): @@ -13,7 +13,12 @@ stats = pgstats.PgStats(self.pgm.get_conn('target')) for ln in stats.list_long_queries('1m'): - print(highlight(1), 'backend PID: ', ln['procpid'], ', query_start: ', ln['query_start'].strftime('%F %T'), highlight(0), sep='') + print(highlight(1), + 'backend PID: ', ln['procpid'], + ', query_start: ', ln['query_start'].strftime('%F %T'), + ', client IP: ', ln['client_addr'], + ln['waiting'] and ', ' + highlight(1, YELLOW|BOLD) + 'waiting' or '', + highlight(0), sep='') print(ln['query']) print()