current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

Is there any way to know how much CPU particular query is utilizing in PostgreSQL?

share|improve this question
2  
Get the PID from pg_stat_activity and look it up in top. Or just use pg_view, for example. (I work for the company, but the tool is free.) –  dezso Mar 13 at 12:43
    
possible duplicate of Tool to find CPU utilization for a particular query in Postgres –  dezso 20 mins ago

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.