Postgres Pro
Downloads
Home   >   mailing lists

Re: How to do things like \timing on in a do loop? - Mailing list pgsql-sql

From Erik Brandsberg
Subject Re: How to do things like \timing on in a do loop?
Date
Msg-id CAFcck8HXvU7XXReM2FA9gMWxehKvw=y92TD0wOiU7Gk5QkXw_Q@mail.gmail.com
Whole thread Raw
In response to How to do things like \timing on in a do loop?  (Shaozhong SHI <shishaozhong@gmail.com>)
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Shaozhong SHI
Date:
Subject: How to do things like \timing on in a do loop?
Next
From: hubert depesz lubaczewski
Date:
Subject: Re: How to do things like \timing on in a do loop?