<div class="WordSection1"><p class="MsoNormal">pgAdmin 3 1.18.1<p class="MsoNormal">PostgreSQL 9.2<p
class="MsoNormal">Iam having issues with a query getting “stuck” while doing updates. So I went to Server Status in
pgAdmin. I found the query was highlighted in dark orange. When a query appears to get hung up and won’t finish what
stepsshould I take to figure out what is happening?<p class="MsoNormal"> <p class="MsoNormal">I have checked the
databaselogs and there does not seem to be an issue. Is there some way I could tell PostgreSQL through pgAdmin to give
memore information on why the query is stuck? Is there a way to get more analytic information on the query while it is
running?<pclass="MsoNormal"> <p class="MsoNormal"> <p class="MsoNormal">Thanks,<p class="MsoNormal"> <p
class="MsoNormal"><ahref="http://illinois.edu/person/lance">Lance Campbell</a><p class="MsoNormal">Software Architect<p
class="MsoNormal">WebServices at Public Affairs<p class="MsoNormal">217-333-0382 <p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto"><ahref="http://illinois.edu/"><span
style="font-size:9.0pt;font-family:"Arial","sans-serif";color:blue;text-decoration:none"><imgalt="University of
Illinoisat Urbana-Champaign logo" border="0" height="33" id="Picture_x0020_1" src="cid:image003.png@01CEFBF8.FA00F130"
width="195"/></span></a><span style="font-size:9.0pt;font-family:"Arial","sans-serif";color:blue"></span><p
class="MsoNormal"> <pclass="MsoNormal"> </div>