Re: how to know cpu utilization using sql command

How to know cpu and memory utilization in postgres.

We require this information to show it on our Application using any postgres command or tool.

the CPU usage would be the total of CPU used by the various postgres server processes.   accurately determining the memory usage is more complex as versions up to 9.2 use shared memory so this same block, often quite large, shows up in each process but its the same block.   if you can use OS API's to determine how much shared memory the postmaster is using, subtract that much from each of the other postgres processes's memory to get an accurate total.

if your application is a monitoring tool, you might look at check_postgresql.pl, this calculates and displays many different sorts of postgres specific values, it was originally intended for use with Nagios, but it can be used with any monitoring system.

-- 
john r pierce                                      37N 122W
somewhere on the middle of the left coast