Changeset 281

Show
Ignore:
Timestamp:
09/01/11 22:00:07 (7 years ago)
Author:
depesz
Message:

show data only about current database

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/curo/s/activity/query.1.sql

    r268 r281  
    2929    current_query <> '<IDLE>' 
    3030    AND procpid <> pg_backend_pid() 
     31    AND datname = current_database() 
    3132ORDER BY 
    3233    xact_start 
  • trunk/curo/s/locks.sql

    r278 r281  
    44FROM 
    55    pg_locks l 
    6     join pg_database d on coalesce(l.database, d.oid) = d.oid 
     6    join pg_stat_activity a on l.pid = a.procpid 
    77WHERE 
    8     d.datname = current_database() 
     8    a.datname = current_database() 
    99;