| From: | "Campbell, Lance" <lance(at)illinois(dot)edu> |
|---|---|
| To: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
| Subject: | Server status SQL highlighted in dark orange |
| Date: | 2013-12-18 19:56:40 |
| Message-ID: | B75CD08C73BD3543B97E4EF3964B7D701F65F68C@CITESMBX1.ad.uillinois.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
pgAdmin 3 1.18.1
PostgreSQL 9.2
I am 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 steps should I take to figure out what is happening?
I have checked the database logs and there does not seem to be an issue. Is there some way I could tell PostgreSQL through pgAdmin to give me more information on why the query is stuck? Is there a way to get more analytic information on the query while it is running?
Thanks,
Lance Campbell<http://illinois.edu/person/lance>
Software Architect
Web Services at Public Affairs
217-333-0382
[University of Illinois at Urbana-Champaign logo]<http://illinois.edu/>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Игорь Титин | 2013-12-19 07:25:23 | |
| Previous Message | Al Chou | 2013-12-15 23:59:54 | feature request: option-left-arrow/option-right-arrow in SQL editor |