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

Re: PG 8.3 and server load

From: Guillaume Cottenceau <gc(at)mnc(dot)ch>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: PG 8.3 and server load
Date: 2009-08-19 14:00:34
Message-ID: 87my5vsy2l.fsf@meuh.mnc.lan (view raw or flat)
Thread:
Lists: pgsql-performance
Ivan Voras <ivoras 'at' freebsd.org> writes:

> pgtop (http://pgfoundry.org/projects/pgtop/) might help you see what
> is your database doing.

A simpler (but most probably less powerful) method would be to
activate "stats_command_string = on" in the server configuration,
then issue that query to view the currently running queries:

SELECT procpid, datname, current_query, query_start FROM pg_stat_activity WHERE current_query <> '<IDLE>'

That may also be interesting.

-- 
Guillaume Cottenceau

In response to

pgsql-performance by date

Next:From: Andy ColsonDate: 2009-08-19 14:01:25
Subject: Re: PG 8.3 and server load
Previous:From: Ivan VorasDate: 2009-08-19 13:53:44
Subject: Re: PG 8.3 and server load

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