Josef Machytka <josef(dot)machytka(at)gmail(dot)com> writes:
> sorry, here is file with sample - basically several group by aggregations
> over different partitioned tables have been locked in this "drowsy" state
The amount of time being spent in the kernel is strikingly high. I wonder
if you're seeing some variant of the old "context swap storm" problem.
Try watching the output of "vmstat 1" for awhile to see if the cs rate
is high.
regards, tom lane