Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nagmH-0004xu-0n for pgsql-sql@arkaria.postgresql.org; Sat, 02 Apr 2022 16:39:05 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1nagmF-0005Ky-R9 for pgsql-sql@arkaria.postgresql.org; Sat, 02 Apr 2022 16:39:03 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nagmF-0005Kp-GP for pgsql-sql@lists.postgresql.org; Sat, 02 Apr 2022 16:39:03 +0000 Received: from premium22-1.web-hosting.com ([68.65.122.103]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1nagmA-0000YJ-O7 for pgsql-sql@lists.postgresql.org; Sat, 02 Apr 2022 16:39:02 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=misuse.org; s=default; h=Content-Type:Cc:To:Subject:Message-ID:Date:From:In-Reply-To: References:MIME-Version:Sender:Reply-To:Content-Transfer-Encoding:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:List-Id:List-Help:List-Unsubscribe:List-Subscribe: List-Post:List-Owner:List-Archive; bh=2qz9A82/bZigmBkf2v436v0kMxMxOTPe6xqc+j/mQa4=; b=OTpunDYBWiHOtGt7DDBZqBYmAW GL9ezTyIDuo//XC8oOmzxV+yVzrSEt/xwCQc8oOhBXONQqUmEmUZ4b9SfGTe5ROhReUEL8u6c23Jc rVxE7Mo/3+NGdkUNKKIrtUybog7e23VujhLRmw/h4+nKj4eK7+NVzooAtuJTUkObHFXBnqQBi2iY7 IYQoSQuo0wZMcq6lz7y4E7KVmwuhdUZoinFlHW6EedD32rKKK0qIww+gqvhKDCVXL6jiVd+8qb05M CphHYcThuRapqhoeZ7+AvV6k4G3CyGAmJKeq0l/mvoTIpiwjslOPORbsXA1jjmq6M/RWI9Dnu/yks Sd3lOCCQ==; Received: from mail-qk1-f182.google.com ([209.85.222.182]:40820) by premium22.web-hosting.com with esmtpsa (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1nagm2-008UXU-SM for pgsql-sql@lists.postgresql.org; Sat, 02 Apr 2022 12:38:55 -0400 Received: by mail-qk1-f182.google.com with SMTP id q200so4452851qke.7 for ; Sat, 02 Apr 2022 09:38:50 -0700 (PDT) X-Gm-Message-State: AOAM532EpEqL+8MKF02PZIq62ewnmnpDhyZboHjCfy3EbpheW4cW+uvA MtXA7UJwGlw/tWgpPhODxWI7GLnv4X0WjC7rCMA= X-Google-Smtp-Source: ABdhPJwRVeqx2V3Zo/o2nqEvVTwv7a9sYRaPPil+O0tEDxJELOrtz/qGkrulFspTzJeZh0hAddA5D3CddLugGz3Rptk= X-Received: by 2002:a05:620a:b82:b0:67e:3a58:6aa9 with SMTP id k2-20020a05620a0b8200b0067e3a586aa9mr9479993qkh.181.1648917529877; Sat, 02 Apr 2022 09:38:49 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Steve Midgley Date: Sat, 2 Apr 2022 09:38:41 -0700 X-Gmail-Original-Message-ID: Message-ID: Subject: Re: How long does iteration over 4-5 million rows usually take? To: Shaozhong SHI Cc: pgsql-sql Content-Type: multipart/alternative; boundary="000000000000a1e03805dbae8733" X-OutGoing-Spam-Status: No, score=2.0 X-AntiAbuse: This header was added to track abuse, please include it with any abuse report X-AntiAbuse: Primary Hostname - premium22.web-hosting.com X-AntiAbuse: Original Domain - lists.postgresql.org X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12] X-AntiAbuse: Sender Address Domain - misuse.org X-Get-Message-Sender-Via: premium22.web-hosting.com: authenticated_id: science@misuse.org X-Authenticated-Sender: premium22.web-hosting.com: science@misuse.org X-Source: X-Source-Args: X-Source-Dir: X-From-Rewrite: unmodified, already matched List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000a1e03805dbae8733 Content-Type: text/plain; charset="UTF-8" On Fri, Apr 1, 2022 at 6:35 PM Shaozhong SHI wrote: > > > I have a script running to iterate over 4-5 million rows. It keeps > showing up in red in PgAdmin. It remains active. > > How long does iteration over 4-5 million rows usually take? > > Please share the SQL query, schema, and sample data. If you are using a third party script with a db connector, then the answer is much harder to answer. --000000000000a1e03805dbae8733 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable


=
On Fri, Apr 1, 2022 at 6:35 PM Shaozh= ong SHI <shishaozhong@gmail.co= m> wrote:


I have a script run= ning to iterate over 4-5 million rows.=C2=A0 It keeps showing up in red in = PgAdmin.=C2=A0 It remains active.

How long does iteratio= n over 4-5 million rows usually take?


Please share the SQL qu= ery, schema, and sample data. If you are using a third party script with a = db connector, then the answer is much harder to answer.=C2=A0
--000000000000a1e03805dbae8733--