Re: Understanding EXPLAIN ANALYZE output

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: Understanding EXPLAIN ANALYZE output
Дата
Msg-id 878y5v8815.fsf@stark.xeocode.com
обсуждение исходный текст
Ответ на Re: Understanding EXPLAIN ANALYZE output  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Well, the point is that there are potentially three types of statements
> involved:
>
>     1. SELECTs
>     2. Utility statements that can return tuples (EXPLAIN, SHOW, etc)
>     3. Utility statements that can't return tuples (ALTER, etc)

I'm not sure this matters, but of course there are other non-utility
statements like UPDATE and DELETE. Does SPI return SPI_OK_SELECT for those?

Because you can definitely do "EXPLAIN ANALYZE UPDATE ..." or "EXPLAIN ANALYZE
DELETE ...".

--
greg

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

Предыдущее
От: Christoph Pingel
Дата:
Сообщение: views don't get 'lost' :-)
Следующее
От: James Thompson
Дата:
Сообщение: Re: Python Driver