Yes, Expalin without Analyze is taking long. It is weird. In the pg_stat_activity Explain was the only query running. So server was almost idle. Using New relic interface I checked CPU was almost idle - around 10-20%. There were some IO activity - around 40-50%.
I forgot to mention before I could run perf on command line even with root permission. It says command not found. May be utility is not installed or not enabled. I have attached the snapshot of vmstat while explain was running in background. vmstat.txt <http://postgresql.1045698.n5.nabble.com/file/n5775349/vmstat.txt> Do you suggest if I remove all the data files from /data/base folder of standby and again rebuild using rsync from primary ? do you see any issues there.? This is just to rule out any fragmentation on standby side. Our sys admin is planning to run fsck sometime today or tomorrow. Thanks. -- View this message in context: http://postgresql.1045698.n5.nabble.com/Hot-Standby-performance-issue-tp5774673p5775349.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
