pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
User session information catalog views
3+ messages / 3 participants
[nested] [flat]

* User session information catalog views
@ 2006-09-26 02:18 GURON Rawender <Rawender_GURON@rta.nsw.gov.au>
  2006-09-26 03:00 ` Re: User session information catalog views Marcelo Costa <marcelojscosta@gmail.com>
  2006-09-26 03:14 ` Re: User session information catalog views Michael Fuhr <mike@fuhr.org>
  0 siblings, 2 replies; 3+ messages in thread

From: GURON Rawender @ 2006-09-26 02:18 UTC (permalink / raw)
  To: pgsql-admin

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.
 
Thanks
Rawender Guron

IMPORTANT NOTICE: This e-mail and any attachment to it are intended only to be read or used by the named addressee. It is confidential and may contain legally privileged information. No confidentiality or privilege is waived or lost by any mistaken transmission to you. The RTA is not responsible for any unauthorised alterations to this e-mail or attachment to it. Views expressed in this message are those of the individual sender, and are not necessarily the views of the RTA. If you receive this e-mail in error, please immediately delete it from your system and notify the sender. You must not disclose, copy or use any part of this e-mail if you are not the intended recipient.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: User session information catalog views
  2006-09-26 02:18 User session information catalog views GURON Rawender <Rawender_GURON@rta.nsw.gov.au>
@ 2006-09-26 03:00 ` Marcelo Costa <marcelojscosta@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Marcelo Costa @ 2006-09-26 03:00 UTC (permalink / raw)
  To: GURON Rawender <Rawender_GURON@rta.nsw.gov.au>; +Cc: pgsql-admin

Hi do you can search in:

http://www.postgresql.org/docs/8.1/interactive/catalogs.html

Here you go learning how thats information are stored.

[],s

Marcelo.

2006/9/25, GURON Rawender <Rawender_GURON@rta.nsw.gov.au>:
>
>  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.
>
> Thanks
> Rawender Guron
> IMPORTANT NOTICE: This e-mail and any attachment to it are intended only
> to be read or used by the named addressee. It is confidential and may
> contain legally privileged information. No confidentiality or privilege is
> waived or lost by any mistaken transmission to you. The RTA is not
> responsible for any unauthorised alterations to this e-mail or attachment to
> it. Views expressed in this message are those of the individual sender, and
> are not necessarily the views of the RTA. If you receive this e-mail in
> error, please immediately delete it from your system and notify the sender.
> You must not disclose, copy or use any part of this e-mail if you are not
> the intended recipient.
>



-- 
Marcelo Costa

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: User session information catalog views
  2006-09-26 02:18 User session information catalog views GURON Rawender <Rawender_GURON@rta.nsw.gov.au>
@ 2006-09-26 03:14 ` Michael Fuhr <mike@fuhr.org>
  1 sibling, 0 replies; 3+ messages in thread

From: Michael Fuhr @ 2006-09-26 03:14 UTC (permalink / raw)
  To: GURON Rawender <Rawender_GURON@rta.nsw.gov.au>; +Cc: 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



^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2006-09-26 03:14 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-09-26 02:18 User session information catalog views GURON Rawender <Rawender_GURON@rta.nsw.gov.au>
2006-09-26 03:00 ` Marcelo Costa <marcelojscosta@gmail.com>
2006-09-26 03:14 ` Michael Fuhr <mike@fuhr.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox