SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-12-2008, 01:59 AM
| ||||
| ||||
 Re: Get explain output of postgresql in Tables -----Original Message----- From: "Tom Lane"<tgl@sss.pgh.pa.us> Sent: 12/04/06 23:03:08 To: "Alvaro Herrera"<alvherre@commandprompt.com> Cc: "Germán Poó Caamaño"<gpoo@ubiobio.cl>, "Jim C. Nasby"<jnasby@pervasive.com>, "mischa@ActiveState.com"<mischa@ActiveState.co m>, "pgsql-hackers@postgresql.org"<pgsql-hackers@postgresql.org> Subject: Re: [HACKERS] Get explain output of postgresql in Tables > Alvaro Herrera <alvherre@commandprompt.com> writes: > > It would be nice to see the "visual explain" tool that Denis wrote -- > > did he finish it? Is it available somewhere? Are there any screenshots? > Red Hat did one of these some years ago: > http://sources.redhat.com/rhdb/visualexplain.html pgAdmin also has visual explain capabilities. /D -----Unmodified Original Message----- Alvaro Herrera <alvherre@commandprompt.com> writes: > It would be nice to see the "visual explain" tool that Denis wrote -- > did he finish it? Is it available somewhere? Are there any screenshots? Red Hat did one of these some years ago: http://sources.redhat.com/rhdb/visualexplain.html I don't see a prebuilt package on that page, but I believe the sources are still available here: http://sources.redhat.com/rhdb/cvs.html regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly      |
|
04-12-2008, 01:59 AM
| |||
| |||
| Re: Get explain output of postgresql in Tables Dave Page escribió: > > Alvaro Herrera <alvherre@commandprompt.com> writes: > > > It would be nice to see the "visual explain" tool that Denis wrote -- > > > did he finish it? Is it available somewhere? Are there any screenshots? > > > Red Hat did one of these some years ago: > > http://sources.redhat.com/rhdb/visualexplain.html > pgAdmin also has visual explain capabilities. How does it work? Does it parse the text representation? I found a screenshot here: http://www.pgadmin.org/images/screen...n3_explain.png Seems nice (but lacking the attributes for each node ...) -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
|
04-12-2008, 01:59 AM
| ||||
| ||||
| Re: Get explain output of postgresql in Tables On Wed, Apr 12, 2006 at 07:28:25PM -0400, Alvaro Herrera wrote: > Dave Page escribi?: > > > > Alvaro Herrera <alvherre@commandprompt.com> writes: > > > > It would be nice to see the "visual explain" tool that Denis wrote -- > > > > did he finish it? Is it available somewhere? Are there any screenshots? > > > > > Red Hat did one of these some years ago: > > > http://sources.redhat.com/rhdb/visualexplain.html > > pgAdmin also has visual explain capabilities. > > How does it work? Does it parse the text representation? > > I found a screenshot here: > http://www.pgadmin.org/images/screen...n3_explain.png > > Seems nice (but lacking the attributes for each node ...) To get the details you hover over each box. It would be nice if you could have it show that info on the main screen though... -- Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend |
Linear Mode
