pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Andreas Kretschmer <akretschmer@despammed.com>
To: pgsql-sql@postgresql.org
Subject: Re: [despammed] Re: 'show full processlist' in postgres?
Date: Fri, 1 Jul 2005 22:19:35 +0200
Message-ID: <20050701201934.GA26290@webserv.wug-glas.de> (raw)
In-Reply-To: <200507011913.36840.erik.wasser@iquer.net>
References: <200507011558.46408.erik.wasser@iquer.net>
	<20050701162340.M94433@contactbda.com>
	<200507011913.36840.erik.wasser@iquer.net>

am  01.07.2005, um 19:13:36 +0200 mailte Erik Wasser folgendes:
> postgres=#  SELECT * from pg_stat_activity ;
>   datid  |  datname  | procpid | usesysid |  usename  | current_query | 
> query_start
> ---------+-----------+---------+----------+-----------+---------------+-------------
>  7349453 | admintool |    5436 |      100 | admintool |               |
>  7349454 | postgres  |    5437 |        1 | postgres  |               |
> (2 rows)
> 
> But 'current_query' is still always empty... B-(

enable stats_command_string in your postgresql.conf


Regards, Andreas
-- 
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    === 



view thread (6+ messages)  latest in thread

Message-ID: <20050701201934.GA26290@webserv.wug-glas.de>
Permalink:  ../20050701201934.GA26290@webserv.wug-glas.de/
Also on:    postgresql.org/message-id/20050701201934.GA26290@webserv.wug-glas.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: akretschmer@despammed.com
  Subject: Re: [despammed] Re: 'show full processlist' in postgres?
  In-Reply-To: <20050701201934.GA26290@webserv.wug-glas.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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