MIME-Version: 1.0
From: Shaozhong SHI <shishaozhong@gmail.com>
Date: Sat, 15 Oct 2022 20:32:59 +0100
Message-ID: 
 <CA+i5JwbMGFD_Yu93oHgqvq3zmftRp4OsLjkyRUKob4oQDkDe_w@mail.gmail.com>
Subject: How to do things like \timing on in a do loop?
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000143aae05eb17d057"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bi5JwbMGFD_Yu93oHgqvq3zmftRp4OsLjkyRUKob4oQDkDe_w%40mail.gmail.com>
Precedence: bulk

--000000000000143aae05eb17d057
Content-Type: text/plain; charset="UTF-8"

DO
$do$
declare

j int=1;

BEGIN

for j in 1..100 loop

\timing on

select * from a_table;

end loop;

end
$$;


It appears that \timing on is not allowed in a do statement.

Any alternative to do that in a do statement?

Regards,

David

--000000000000143aae05eb17d057
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div>DO</div><div>$do$</div><div>declare<=
/div><div><br></div><div>j int=3D1;</div><div><br></div><div>BEGIN=C2=A0</d=
iv><div><br></div><div>for j in 1..100 loop</div><div><br></div><div>\timin=
g on</div><div><br></div><div>select * from a_table;</div><div><br></div><d=
iv>end loop;</div><div><br></div><div>end</div><div>$$;</div><div><br></div=
><div><br></div><div>It appears that \timing on is not allowed in a do stat=
ement.</div><div><br></div><div>Any alternative to do that in a do statemen=
t?</div><div><br></div><div>Regards,</div><div><br></div><div>David</div></=
div></div>

--000000000000143aae05eb17d057--