This time i was in need of a mytop program but for postgresql and after some googleing i found pgtop. pgtop is a top like query monitor for postgresql. Installation was really easy i just downloaded the program, installed the needed modules and installed pgtop.