Re: EXPLAIN statement can also apply to SELECT INTO.

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: EXPLAIN statement can also apply to SELECT INTO.
Дата
Msg-id CAKFQuwaUufXMGiT8EikcLVsveWyM=aQjumVNg9D65zDMMMey_w@mail.gmail.com
обсуждение исходный текст
Ответ на EXPLAIN statement can also apply to SELECT INTO.  (jian he <jian.universality@gmail.com>)
Список pgsql-general
On Monday, August 21, 2023, jian he <jian.universality@gmail.com> wrote:
hi.

https://www.postgresql.org/docs/current/sql-explain.html
>>>
Any SELECT, INSERT, UPDATE, DELETE, MERGE, VALUES, EXECUTE, DECLARE,
CREATE TABLE AS, or CREATE MATERIALIZED VIEW AS statement, whose
execution plan you wish to see.
>>>

seems you can use it with SELECT INTO.

explain (ANALYZE, BUFFERS, TIMING, VERBOSE ON, BUFFERS ON, WAL ON,SETTINGS ON)
select count(*) as cnt INTO s from tenk1;


We try not to encourage such things.  And CTAS is listed.

David J.
 

В списке pgsql-general по дате отправления:

Предыдущее
От: jian he
Дата:
Сообщение: EXPLAIN statement can also apply to SELECT INTO.
Следующее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Will PostgreSQL 16 supports native transparent data encryption ?