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?