| From: | "Arnaud L(dot)" <arnaud(dot)listes(at)codata(dot)eu> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: psql \copy hanging |
| Date: | 2019-10-10 07:00:17 |
| Message-ID: | 189a66a7-5d3e-9603-a3c7-563ddef0c2f4@codata.eu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Le 08/10/2019 à 16:59, Arnaud L. a écrit :
> Yes, I already did that, and unfortunately there's no activy.
> There is absolutely no activity in procmon using psql.exe as a filter.
> process-xp is not giving more information, processor usage is 0%.
My apologies, I obviously did something wrong last time I checked this
process with process-xp and procmon.
Now I see that there IS activity on the problematic process !
100% CPU and some (but not much) disk activity.
I think I'll try to let it run for some time to get the auto_explain do
its work. If I kill the backend now, I won't see anything I believe.
I dont now it it'll ever complete this query though, it usually takes
~100 seconds, and here it has already been running for 9 hours.
Regards
--
Arnaud
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andreas Joseph Krogh | 2019-10-10 07:05:06 | Re: Segmentation fault with PG-12 |
| Previous Message | Michael Paquier | 2019-10-10 05:32:12 | Re: Version 10.7 of postgres |