Re: Open system files total - Mailing list pgsql-admin

From Rudi Starcevic
Subject Re: Open system files total
Date
Msg-id 3FB43161.7010505@oasis.net.au
Whole thread Raw
In response to Open system files total  (Rudi Starcevic <rudi@oasis.net.au>)
List pgsql-admin
Hi,

I think I found an easier way:
lsof -c postmaster | wc -l
lsof -u postgres | wc -l

Another option is to 'ps wwaux', then grep for postgres PIDS, then use
the 'lsof -p' option and give it a comma-separated list of postgres PIDs.

Cheers
Rudi.

Rudi Starcevic wrote:

> Hi,
>
> I'd like to know how many total system files Postgresql has open at
> any one time.
>
> Is this the easiest way ??
>
> a) Find out how many Postgres process's - `ps aux | grep postgres`
> b) For each Postgres process find out which files it has open - `ls
> /proc/*postgres_process_id*/fd | wc -l`
> c) Add up each Postgres process file open total to work out grand
> total of open files for user Postgres.
>
> I know I can get the total for the whole machine using
> /proc/user_beancounters but I'd like to know
> just for Postgres.
>
> Many thanks
> Best regards
> Rudi.
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>



pgsql-admin by date:

Previous
From: Rudi Starcevic
Date:
Subject: Open system files total
Next
From: "noelvillarama"
Date:
Subject: how can i connect to postgres 7.3 using pgadmin3