On Friday 01 July 2005 22:19, Andreas Kretschmer wrote:
enable stats_command_string in your postgresql.conf
That was missing. Thanks.
--
So long... Fuzz
---(end of broadcast)---
TIP 4: Have you searched our list archives?
Hallo pgsql-sql@postgresql.org,
I'm looking for a way to display the active querys of postgres. The
mysql way is a 'show [full] processlist'.
After I've read http://pgsqld.active-venture.com/monitoring-stats.html I
set STATS_COMMAND_STRING, STATS_BLOCK_LEVEL, STATS_ROW_LEVEL and
did you restart postgresql and use the pg_stat_activity view instead (just to
save some typing).
Jim
-- Original Message ---
From: Erik Wasser [EMAIL PROTECTED]
To: pgsql-sql@postgresql.org
Sent: Fri, 1 Jul 2005 15:58:46 +0200
Subject: [SQL] 'show full processlist' in postgres
On Friday 01 July 2005 18:24, Jim Buttafuoco wrote:
did you restart postgresql and use the pg_stat_activity view instead
(just to save some typing).
No. Is a restart necessary or will a 'reload' do also the trick?
I've done the restart:
postgres=# SELECT * from pg_stat_activity ;
datid |
Erik Wasser [EMAIL PROTECTED] writes:
But 'current_query' is still always empty... B-(
The pg_stats views lag reality by a certain amount, so checking for your
own query is generally not gonna work. Try starting a long-running
query in another session.
regards, tom lane
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 |