Open system files total
Open system files total
От:
Rudi Starcevic <rudi@oasis.net.au>
Дата:
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.
Re: Open system files total
От:
Rudi Starcevic <rudi@oasis.net.au>
Дата:
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) >