Re: Q: explain on delete - Mailing list pgsql-general

Tom Lane writes:

> As of CVS tip there's finally a real solution: you can PREPARE the
> parameterized query and then EXPLAIN EXECUTE it.  For example,
> given something like
>
>     SELECT * FROM foo WHERE col = $1
>
> you could do
>
>     PREPARE q1(int) AS SELECT * FROM foo WHERE col = $1
>     EXPLAIN EXECUTE q1(42)

Nice, I'll try that...

Regards,

    Tilo