Search Postgresql Archives

understanding explain data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am looking at the explain data for my query and it mostly understandable thanks to an excellent article by Jim Nasby, http://www.pervasive-postgres.com/instantkb13/article.aspx?id=10120

It is very time consuming and confusing walking through the explain. Is there a possibility (or does it even make sense), to be able to feed the explain into an application that would tell you what you need to do to optimize the query?

Something such as: with this explain data, adding an index on table tbl column A would drastically improve the efficiency. Or at least an application that would say, the least efficient part of your query is on this part of the code so that you could more easily figure out what to do about it.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux