pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Knowing postgres processes..
3+ messages / 3 participants
[nested] [flat]

* Knowing postgres processes..
@ 2004-02-19 05:43 JM <jerome@gmanmi.tv>
  2004-02-19 06:30 ` Re: Knowing postgres processes.. Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: JM @ 2004-02-19 05:43 UTC (permalink / raw)
  To: pgsql-admin

Hi,


	this are processes running on my box.  is it normal to see "idle" processes?  10.10.10.1 holds all of my application the connects
to the db..  and is it possible to see what query is being processed by the [local] UPDATE?


postgres 18826  0.0  0.1 381012 4100 ?       S    Jan16  11:26 postmaster -p 5433
postgres 18828  0.0  0.0 381956 1040 ?       S    Jan16   1:53  \_ postgres: stats buffer process
postgres 18829  0.0  0.0 381044 248 ?        S    Jan16   3:21  |   \_ postgres: stats collector process
postgres 15371 97.6 18.0 382256 371540 ?     R    Feb18 1671:30  \_ postgres: nsadmin nmisub [local] UPDATE
postgres 17323  0.3  8.1 383308 166532 ?     S    Feb18   5:26  \_ postgres: nsadmin nmisub 10.10.10.1 idle
postgres 17937  0.0  0.2 382140 5852 ?       S    Feb18   0:00  \_ postgres: nsadmin nmisub 10.10.10.1 idle
postgres 17975  0.3  7.8 383316 162068 ?     S    Feb18   5:50  \_ postgres: nsadmin nmisub 10.10.10.1 idle
postgres  6084  0.0  0.4 382236 9524 ?       S    Feb18   0:00  \_ postgres: nsadmin nmisub 10.10.10.2 idle
postgres 17028  0.4  4.9 382480 101460 ?     S    Feb18   4:30  \_ postgres: nsadmin nmisub 10.10.10.1 idle
postgres 26537  0.4  5.0 382480 102788 ?     S    00:08   3:22  \_ postgres: nsadmin nmisub 10.10.10.1 idle
postgres 26538  0.0  4.8 382476 99352 ?      S    00:08   0:04  \_ postgres: nsadmin nmisub 10.10.10.1 idle
postgres  3708  0.0  0.4 382204 9868 ?       S    10:55   0:00  \_ postgres: nsadmin nmisub [local] idle



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

* Re: Knowing postgres processes..
  2004-02-19 05:43 Knowing postgres processes.. JM <jerome@gmanmi.tv>
@ 2004-02-19 06:30 ` Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 0 replies; 3+ messages in thread

From: Tom Lane @ 2004-02-19 06:30 UTC (permalink / raw)
  To: jerome@gmanmi.tv; +Cc: pgsql-admin

JM <jerome@gmanmi.tv> writes:
> 	this are processes running on my box.  is it normal to see
> "idle" processes?

That says you've got client processes holding open connections without
doing anything.  You probably want to look at your client-side logic.

			regards, tom lane



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

* Re: Knowing postgres processes..
@ 2004-06-04 13:22 Goulet, Dick <DGoulet@vicr.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Goulet, Dick @ 2004-06-04 13:22 UTC (permalink / raw)
  To: pgsql-admin

Idle processes are not uncommon on a database.  Basically their client applications that don't have anything for the database to do at the present time.  Now if they persist for a long period of time without ever changing state to active, then something is probably wrong.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Thursday, February 19, 2004 1:30 AM
To: jerome@gmanmi.tv
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Knowing postgres processes.. 


JM <jerome@gmanmi.tv> writes:
> 	this are processes running on my box.  is it normal to see
> "idle" processes?

That says you've got client processes holding open connections without
doing anything.  You probably want to look at your client-side logic.

			regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org



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


end of thread, other threads:[~2004-06-04 13:22 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-19 05:43 Knowing postgres processes.. JM <jerome@gmanmi.tv>
2004-02-19 06:30 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-06-04 13:22 Re: Knowing postgres processes.. Goulet, Dick <DGoulet@vicr.com>

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