MIME-Version: 1.0
References: 
 <CA+i5JwbMGFD_Yu93oHgqvq3zmftRp4OsLjkyRUKob4oQDkDe_w@mail.gmail.com>
In-Reply-To: 
 <CA+i5JwbMGFD_Yu93oHgqvq3zmftRp4OsLjkyRUKob4oQDkDe_w@mail.gmail.com>
From: Erik Brandsberg <erik@heimdalldata.com>
Date: Sat, 15 Oct 2022 16:04:41 -0400
Message-ID: 
 <CAFcck8HXvU7XXReM2FA9gMWxehKvw=y92TD0wOiU7Gk5QkXw_Q@mail.gmail.com>
Subject: Re: How to do things like \timing on in a do loop?
To: Shaozhong SHI <shishaozhong@gmail.com>
Cc: pgsql-sql <pgsql-sql@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000713e6e05eb184153"
Archived-At: 
 <https://www.postgresql.org/message-id/CAFcck8HXvU7XXReM2FA9gMWxehKvw%3Dy92TD0wOiU7Gk5QkXw_Q%40mail.gmail.com>
Precedence: bulk

--000000000000713e6e05eb184153
Content-Type: text/plain; charset="UTF-8"

You can't, as \timing is not a postgres command.  It is a psql command, so
is not interpreted by the server itself.

On Sat, Oct 15, 2022, 3:33 PM Shaozhong SHI <shishaozhong@gmail.com> wrote:

> 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
>

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

<div dir=3D"auto">You can&#39;t, as \timing is not a postgres command.=C2=
=A0 It is a psql command, so is not interpreted by the server itself.</div>=
<br><div class=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Sat=
, Oct 15, 2022, 3:33 PM Shaozhong SHI &lt;<a href=3D"mailto:shishaozhong@gm=
ail.com">shishaozhong@gmail.com</a>&gt; wrote:<br></div><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex"><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</div><div><br></div><div>for j in 1..100 loop</div><div><br></d=
iv><div>\timing on</div><div><br></div><div>select * from a_table;</div><di=
v><br></div><div>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 allowe=
d in a do statement.</div><div><br></div><div>Any alternative to do that in=
 a do statement?</div><div><br></div><div>Regards,</div><div><br></div><div=
>David</div></div></div>
</blockquote></div>

--000000000000713e6e05eb184153--