what postgres proces is doing ?

#1

When I execute ps on my linux server I can see:
....
8021 ? S 2:51 \_ postgres: vt tdb 127.0.0.1(51399) idle
8037 ? S 9:35 \_ postgres: vt tdb 127.0.0.1(33643) idle
8038 ? S 9:35 \_ postgres: vt tdb 127.0.0.1(36490) idle
8629 ? S 110:02 \_ postgres: vt tdb 127.0.0.1(48856) idle
8630 ? R 213:59 \_ postgres: vt tdb 127.0.0.1(35397) SELECT
9051 ? S 8:28 \_ postgres: vt tdb 127.0.0.1(56341) idle
....

How can I determine what process 8630 is doing ? what SELECT

I've try loging statements but only finished queries has been loged.

#2

pbr <bez_maila (AT) onet (DOT) pl> wrote:

Quote:

When I execute ps on my linux server I can see:
...
8021 ? S 2:51 \_ postgres: vt tdb 127.0.0.1(51399) idle
8037 ? S 9:35 \_ postgres: vt tdb 127.0.0.1(33643) idle
8038 ? S 9:35 \_ postgres: vt tdb 127.0.0.1(36490) idle
8629 ? S 110:02 \_ postgres: vt tdb 127.0.0.1(48856) idle
8630 ? R 213:59 \_ postgres: vt tdb 127.0.0.1(35397) SELECT
9051 ? S 8:28 \_ postgres: vt tdb 127.0.0.1(56341) idle
...

How can I determine what process 8630 is doing ? what SELECT

I've try loging statements but only finished queries has been loged.

Have you tried:

SELECT current_query FROM pg_catalog.pg_stat_activity
WHERE procpid = 8630

Yours,
Laurenz Albe

#3

Laurenz Albe wrote:

Quote:

Have you tried:

SELECT current_query FROM pg_catalog.pg_stat_activity
WHERE procpid = 8630

THX a lot ... problem solved

I had to set stats_command_string = on in postgresql.conf
and now yours solution works perfect.

PBR

#4

pbr napisa³(a):

Quote:

When I execute ps on my linux server I can see:
...
8021 ? S 2:51 \_ postgres: vt tdb 127.0.0.1(51399) idle
8037 ? S 9:35 \_ postgres: vt tdb 127.0.0.1(33643) idle
8038 ? S 9:35 \_ postgres: vt tdb 127.0.0.1(36490) idle
8629 ? S 110:02 \_ postgres: vt tdb 127.0.0.1(48856) idle
8630 ? R 213:59 \_ postgres: vt tdb 127.0.0.1(35397) SELECT
9051 ? S 8:28 \_ postgres: vt tdb 127.0.0.1(56341) idle
...

How can I determine what process 8630 is doing ? what SELECT

I've try loging statements but only finished queries has been loged.

try pg_top

#5

Quote:

pbr napisaÅ‚(a):
When I execute ps on my linux server I can see:
...
8021 ? S 2:51 \_ postgres: vt tdb 127.0.0.1(51399) idle
8037 ? S 9:35 \_ postgres: vt tdb 127.0.0.1(33643) idle
8038 ? S 9:35 \_ postgres: vt tdb 127.0.0.1(36490) idle
8629 ? S 110:02 \_ postgres: vt tdb 127.0.0.1(48856) idle
8630 ? R 213:59 \_ postgres: vt tdb 127.0.0.1(35397) SELECT
9051 ? S 8:28 \_ postgres: vt tdb 127.0.0.1(56341) idle
...

How can I determine what process 8630 is doing ? what SELECT

cienki_bolek wrote:
try pg_top

Also, ps can be coerced into showing more of the command line:

ps -o "pid,cmd"

- Lew

#6

"Lew" <lew (AT) nowhere (DOT) com> schreef in bericht
news:mZCdnceNi-sIFeDYnZ2dnUVZ_oTinZ2d (AT) comcast (DOT) com...

Quote:

pbr napisal(a):
cienki_bolek wrote:
try pg_top

Also, ps can be coerced into showing more of the command line:
ps -o "pid,cmd"
The query is _not_ part of the command line.

Anyway, problem was already reported solved on 13 nov
Second message in thread gave a magic SQLstatement:
SELECT current_query FROM pg_catalog.pg_stat_activity
WHERE procpid = 8630
to list the longstanding _query_

HansH

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

what postgres proces is doing ?

comp.databases.postgresql comp.databases.postgresql

what postgres proces is doing ? - 11-12-2006 , 12:43 PM

Re: what postgres proces is doing ? - 11-13-2006 , 03:27 AM

SOLVED: what postgres proces is doing ? - 11-13-2006 , 04:42 PM

Re: what postgres proces is doing ? - 12-11-2006 , 09:42 AM

Re: what postgres proces is doing ? - 12-11-2006 , 10:34 AM

Re: what postgres proces is doing ? - 12-11-2006 , 11:30 AM