pgtoolkit/pgstats.py
changeset 104 d8ff52a0390f
parent 103 24e94a3da209
child 105 10551741f61f
equal deleted inserted replaced
103:24e94a3da209 104:d8ff52a0390f
     1 # -*- coding: utf-8 -*-
       
     2 #
       
     3 # PgStats - browse database statistics
       
     4 #
       
     5 # Copyright (c) 2011  Radek Brich <radek.brich@devl.cz>
       
     6 #
       
     7 # Permission is hereby granted, free of charge, to any person obtaining a copy
       
     8 # of this software and associated documentation files (the "Software"), to deal
       
     9 # in the Software without restriction, including without limitation the rights
       
    10 # to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
       
    11 # copies of the Software, and to permit persons to whom the Software is
       
    12 # furnished to do so, subject to the following conditions:
       
    13 #
       
    14 # The above copyright notice and this permission notice shall be included in
       
    15 # all copies or substantial portions of the Software.
       
    16 #
       
    17 # THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
       
    18 # IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
       
    19 # FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE
       
    20 # AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER
       
    21 # LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
       
    22 # OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN
       
    23 # THE SOFTWARE.
       
    24 
       
    25 
       
    26 class PgStats:
       
    27     def __init__(self, conn=None):
       
    28         self.conn = conn
       
    29         
       
    30     def setconn(self, conn=None):
       
    31         self.conn = conn
       
    32 
       
    33     def _query(self, query, *args):
       
    34         try:
       
    35             curs = self.conn.cursor()
       
    36             curs.execute(query, args)
       
    37             curs.connection.commit()
       
    38             rows = curs.fetchall()
       
    39             return [dict(zip([desc[0] for desc in curs.description], row)) for row in rows]
       
    40         finally:
       
    41             curs.close()
       
    42 
       
    43     def list_long_queries(self, longer_than='1m'):
       
    44         return self._query('''SELECT
       
    45               datname, procpid, usename, current_query AS query,
       
    46               waiting, xact_start, query_start, backend_start, client_addr
       
    47             FROM pg_stat_activity
       
    48             WHERE current_query <> '<IDLE>' AND query_start < now() - interval %s
       
    49             ORDER BY query_start;''',
       
    50             longer_than)
       
    51