Re: Q: explain on delete

From: Tilo Schwarz <mail(at)tilo-schwarz(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Q: explain on delete
Date: 2003-02-04 23:09:33
Message-ID: 200302050009.33136.mail@tilo-schwarz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-02-04 23:10:07 Re: UPDATE slow
Previous Message John Smith 2003-02-04 23:07:11 Re: UPDATE slow