Skip site navigation (1) Skip section navigation (2)

Re: User session information catalog views

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: GURON Rawender <Rawender_GURON(at)rta(dot)nsw(dot)gov(dot)au>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: User session information catalog views
Date: 2006-09-26 03:14:57
Message-ID: 20060926031457.GA75229@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-admin
On Tue, Sep 26, 2006 at 12:18:31PM +1000, GURON Rawender wrote:
> I am new to PostgreSQL and have long experience of administering Oracle
> database. I am looking for user sessions information in a PostgreSQL.
> Basically I am after dynamic performance views equivalent to Oracle's
> v$session, v$process, v$session_wait etc. Can someone guide me in right
> direction because I could not find any relevant information in the
> manual.

Sounds like you're looking for the pg_stat_activity view.  See "The
Statistics Collector" in the "Monitoring Database Activity" chapter
of the documentation.

http://www.postgresql.org/docs/8.1/interactive/monitoring-stats.html

To see command strings you'll need to enable stats_command_string
in postgresql.conf.  This setting is off by default in 8.1 and
earlier; enabling it can have a noticeable performance impact.
Performance is improved in 8.2, which will enable stats_command_string
by default.

-- 
Michael Fuhr

In response to

pgsql-admin by date

Next:From: Jeanna GeierDate: 2006-09-26 13:25:18
Subject: Beginner's Question: No pg_hba.conf entry for host...SSL Off
Previous:From: Marcelo CostaDate: 2006-09-26 03:00:21
Subject: Re: User session information catalog views

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group