| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | Jignesh Shah <jignesh(dot)shah1980(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: What is statement ID of table? |
| Date: | 2009-10-12 06:24:04 |
| Message-ID: | 20091012062404.GA10520@a-kretschmer.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
In response to Jignesh Shah :
> Thanks Andreas. Sorry for confusion here. I mean statement ID that can be
> associated with prepared query(not table) to improve performance of building
> query. I just need to find plan using statement ID and execute it. I don't know
> how to do this.
Please, answer to the list and not to me, and please try to avoid html and
top-posting.
I don't know if i understand you correctly. There isn't such an ID, but
you can look at pg_prepared_statements, this view contains name,
statement and other informations about all (currently) prepared
statements.
Andreas
--
Andreas Kretschmer
Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Martijn van Oosterhout | 2009-10-12 06:25:56 | Re: table full scan or index full scan? |
| Previous Message | Peter Hunsberger | 2009-10-12 03:01:52 | Re: table full scan or index full scan? |