longqueries.py
changeset 44 4fe39c59c515
parent 39 0cef3540b69f
child 73 390376b9e70f
--- 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()