Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vyV76-000AN1-1V for pgsql-novice@arkaria.postgresql.org; Fri, 06 Mar 2026 13:21:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vyV74-0059oy-2R for pgsql-novice@arkaria.postgresql.org; Fri, 06 Mar 2026 13:21:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vyV74-0059on-1Y for pgsql-novice@lists.postgresql.org; Fri, 06 Mar 2026 13:21:06 +0000 Received: from mail-wr1-x431.google.com ([2a00:1450:4864:20::431]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vyV6z-00000000mAU-3xfZ for pgsql-novice@lists.postgresql.org; Fri, 06 Mar 2026 13:21:06 +0000 Received: by mail-wr1-x431.google.com with SMTP id ffacd0b85a97d-439a89b6fd0so5892395f8f.2 for ; Fri, 06 Mar 2026 05:21:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1772803260; x=1773408060; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=Rkc09zznZUvOCtL7lqsf+w8JawbR89Mx5ZcjdzQc/70=; b=Dxw+Iu6dUfrJMrDWi8ONBp+MNwRtLRTdZHdlj3EORGmkq4N7co6YUV+Ug9Ab692cR4 VtnSTOVzKWxKYPliVbFxVq63pLoG5yWVFDg7oUzuFmEX0sbGo0hd3mX7nZhTZYgOcS2e 0xqDuAyMwmX/ZA+hKpAuH2lybSiY0OUHUu3HGHa4lgqO/ep+4+nW/LHLt9b6kQBOuxxa txEUv040XeQeal07oMXsHqK1ktYhEOEtupcxcFwjRZlnskB2aV3GoaY8hvsBQ28ZtgAx 1QoXYllZa8k47tM7qvQel3wyJ7o1tW/s0oNX3jVKLSGii7wKTSaZAYIn/jxEEcHu5wmf 2Cqg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772803260; x=1773408060; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=Rkc09zznZUvOCtL7lqsf+w8JawbR89Mx5ZcjdzQc/70=; b=MuXMQhPgDJec+STvPTm+i00HoF/O2ykepFiDIz0qeuO8+PXC0S9u59mMYUcDcSzKty v5G7sWgyIugjdFOzBK3C0rIddQXTJT0bfNTEyBCsPdxL5v3BPszhM/+JEw0Y/gl/P7Wb uteWIWlZvpE97RI4LF3UUQEkbk8OinObMVAjvUFHU07Kor5tg5JKWOzIk4oVepJ3f+yp h4c9xYNLW+Z7t6JkYKseLp+4jieCo7vGWkxo2JRfyfrdzDXcypO/8H8EaoZf6SH4VSL9 RdhMfPbn5/pQpY2cstRck4l3zsw0MyhOr9XMM7MG257CdOvxgnzI2hmQr43b/RNHoDA7 poQw== X-Forwarded-Encrypted: i=1; AJvYcCWW3SXOg/JKUPk+gIZG5QthMzaXtWP4l/g9ahYwYiz4vv7LkqCpYpRvgfUTycitxZYu0YK7yKSlaLlY8q8=@lists.postgresql.org X-Gm-Message-State: AOJu0YyjjVYXTtlVyCVRVpI+LJxD/WD0upDJmHJ9w9tyrJTBZqHw7fYi 1vpc1WPKF5M4hMHBBL3O0x2IGqDvJDs7gymcWM5hsZYR0MejR/L+c8GkdppJ/zhTBeA= X-Gm-Gg: ATEYQzxeQ85LpNANfn5aT4uZczkjyASSgC8YlyYTJPGcU65PPgAdCy15zwW9f+XHzbi Js/s32IN8WCRs+eWquXC5WGnDSfDYt66FqvmGPTQKIEuRK1QkU0uaMDzD1K2bOoLQRBdsyp7Udh zpHNcrxSLwgPMmJI6ejhtr1GiCEMQXCnHMYS+OTdG4iz25OMLa+S8TNyvYdPH45ULNXomCyt04n RB7/jrvmVLPFCwlrYDB2VUp5Et7wAWEwzCMb630YnwlC7wejS9JRanj0W/BOtoFhLHxRADKm94d HfagU0Dtyg8jOpWIAmZLSxDBVrE5X7cmvSEiUaEREBMQj7XsjaP6dTErJbTVA0HPenWjyrf74Eh BCJFVbfoSoUvsIUqzjclc3yC3UYMXajoyovmxtqrM5F8pYDcwm4JgWarPyKWZUzkc1fJ3vCa3SG 3U1u4zhgF+tIjjpIGNnDeCDj5XjMJzoZbg+UAYbV+zPaDX4GnyjZPh X-Received: by 2002:a5d:5c8a:0:b0:439:be82:1fd9 with SMTP id ffacd0b85a97d-439da555622mr3638988f8f.12.1772803260341; Fri, 06 Mar 2026 05:21:00 -0800 (PST) Received: from laurenz.albe-K4N0CV00F97414D ([2001:871:70:cfb9:f5e7:7c91:64ca:8803]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-439dae49177sm3938961f8f.35.2026.03.06.05.20.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 06 Mar 2026 05:21:00 -0800 (PST) Message-ID: <12a672903852221b22d90692c1d8933c054ee7b7.camel@cybertec.at> Subject: Re: SQL - How to iterate with delay in a loop From: Laurenz Albe To: "Subramanian,Ramachandran" , "pgsql-novice@lists.postgresql.org" Date: Fri, 06 Mar 2026 14:20:58 +0100 In-Reply-To: <6c2c6ae6d61a467a91d08414e38b50c5@alte-leipziger.de> References: <6c2c6ae6d61a467a91d08414e38b50c5@alte-leipziger.de> Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2026-03-06 at 12:07 +0000, Subramanian,Ramachandran wrote: > I am trying to insert some rows into a table with a delay between each in= sert. > I have a simple table with a ID column and some Date-Time columns. > =C2=A0 > The first two inserts work as expected and insert two rows, each one seco= nd apart. > =C2=A0 > However the do loop inserts 25 more rows, with the same timestamp. Use clock_timestamp()::time instead of current_time. current_time returns the same value for each call in the same database transaction. Think of it as "transaction start time". Yours, Laurenz Albe