Postgres using a lot of resources

[jdbruijn]

Lately we notice that one of our production servers has serveral postgres processes almost running with 20-30% cpu for extended periodes (sometimes multiple times per hour).
Is there anyway I can see if it are specific queries that make those processes use that much of the cpu?

[ROCLASI]

Hi Jos,

You can check what connection are open and what queries are running using the following SQL:

Code: Select all

SELECT * FROM pg_stat_activity;

You can also see in the system process list if the process is a background worker process or a connection.
Of course all this means you have to check it the moment you have these loads.
Another way of (continues) tracking is to implement some monitoring using tools like Munin, Cacti, Nagios or Icinga.
I use Munin myself.

Hope this helps.

[jdbruijn]

Thanks for the tip Robert, I will look into those tools.