--- 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()