Thread: Open system files total

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.

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)
>