diff -r eaae9539e910 -r efee419b7a2d longqueries.py --- /dev/null Thu Jan 01 00:00:00 1970 +0000 +++ b/longqueries.py Mon Jul 18 17:39:37 2011 +0200 @@ -0,0 +1,22 @@ +#!/usr/bin/env python3.2 + +from pgtools import pgstats +from toolbase import ToolBase + + +class LongQueriesTool(ToolBase): + def __init__(self): + ToolBase.__init__(self, name='longqueries', desc='Lis long queries.') + self.init() + + def main(self): + stats = pgstats.PgStats(self.pgm.get_conn('target')) + + for ln in stats.list_long_queries(): + print(ln['query']) + print(' ', 'query_start:', ln['query_start'].strftime('%F %T')) + + +tool = LongQueriesTool() +tool.main() +