Re: How to do things like \timing on in a do loop?

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
>