can supervisord be used for memory and CPU usage profiling of a program
It can, see Supervisod Event Listeners and Superlance. I've had issues with supervisord leaking memory itself. Monit can easily monitor memory and CPU and doesn't use a lot of resources.