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

Поиск
Список
Период
Сортировка
От Erik Brandsberg
Тема Re: How to do things like \timing on in a do loop?
Дата
Msg-id CAFcck8HXvU7XXReM2FA9gMWxehKvw=y92TD0wOiU7Gk5QkXw_Q@mail.gmail.com
обсуждение исходный текст
Ответ на How to do things like \timing on in a do loop?  (Shaozhong SHI <shishaozhong@gmail.com>)
Список pgsql-sql
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Shaozhong SHI
Дата:
Сообщение: How to do things like \timing on in a do loop?
Следующее
От: hubert depesz lubaczewski
Дата:
Сообщение: Re: How to do things like \timing on in a do loop?