pgvip is a valuable utility for examining the PostgreSQL internal behavior . Built primarily for identifying system slowdowns , it delivers a rich view into several aspects of the engine. pgvipsdd.com