Re: Understanding EXPLAIN ANALYZE output - Mailing list pgsql-general

From Greg Stark
Subject Re: Understanding EXPLAIN ANALYZE output
Date
Msg-id 878y5v8815.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: Understanding EXPLAIN ANALYZE output  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Christoph Pingel
Date:
Subject: views don't get 'lost' :-)
Next
From: James Thompson
Date:
Subject: Re: Python Driver