public inbox for [email protected]
help / color / mirror / Atom feedFrom: Laurenz Albe <[email protected]>
To: [email protected] <[email protected]>
To: Pgsql-general <[email protected]>
Subject: Re: Is there any limit on the number of rows to import using copy command
Date: Wed, 23 Jul 2025 16:10:44 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
<[email protected]>
<[email protected]>
<[email protected]>
On Wed, 2025-07-23 at 11:55 +0000, [email protected] wrote:
> 1. I tried running Copy From command from PGAdmin.
> 2. I ran pg_stat_activity also in another tab [ PGAdmin ].
>
> What I observed,
> 1. In about 2 min, in the Dashboard of PGAdmin, the colour changed to Orange for that particular pid.
> 2. After few seconds, the colour again changed to Red.
> 3. The stat column in both Dashboard and pg_stat_activity.state shows 'active'.
> 4. No messages relevant to this pid in postgres' log files
> 5. CPU usage is normal, hovering around 36% overall, 15-18% for postgresql server, from the beginning and even after 3 min.
> 6. We didn't run any other application in that machine.
> 7. Unique Index is there in table2 which will return only one row for that Select Count(*) query.
> 8. No record is there in the target table when transfer started. This transfer is the first batch for that particular table.
> 9. Once color turned into Red, I could cancel the query execuion in PGAdmin, which immediately stops the execution.
> 10. I could not see any locks or blocking pids.
As far as I know, red in pgAdmin (I don't use it) *is* the indication for a wait event.
So look again what the columns "wait_event_type" and "wait_event" in "pg_stat_activity" show.
Yours,
Laurenz Albe
view thread (2+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Is there any limit on the number of rows to import using copy command
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox