db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "C.S. Nirmal J. Fernando (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-4587) Add tools for improved analysis and understanding of query plans and execution statistics
Date Sat, 27 Mar 2010 12:54:27 GMT

    [ https://issues.apache.org/jira/browse/DERBY-4587?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12850509#action_12850509
] 

C.S. Nirmal J. Fernando commented on DERBY-4587:
------------------------------------------------

Regarding Postgres and licensing:

Graphical query explainer was implemented by PgAdmin III which is a tool uses PostgreSQL at
the back end as their server (http://www.postgresonline.com/journal/index.php?/archives/27-Reading-PgAdmin-Graphical-Explain-Plans.html).

So, I contacted PgAdmin hackers devs-mailing list to check the possibility of  and following
is the reply I got !!

-----------------------------------------------------------------------------------------------------------------------
Le 27/03/2010 07:14, Nirmal Fernando a écrit :
> [...]
> Is it possible to integrate pgadmin tool with a different DMS rather than
> Postgres? If it possible it would be great help if someone can send some
> helpful links.
>

Nope it's not possible.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com
----------------------------------------------------------------------------------------




> Add tools for improved analysis and understanding of query plans and execution statistics
> -----------------------------------------------------------------------------------------
>
>                 Key: DERBY-4587
>                 URL: https://issues.apache.org/jira/browse/DERBY-4587
>             Project: Derby
>          Issue Type: Improvement
>          Components: SQL, Tools
>            Reporter: Bryan Pendleton
>            Assignee: Bryan Pendleton
>         Attachments: PostgreSQL license.jpg
>
>
> I think it would be great to see some work in the area of tools for helping
> with the analysis of complex query execution. Quite frequently, users of
> Derby have trouble comprehending (a) how their query is being translated
> into a query plan by the optimizer, and (b) what the execution-time resource
> usage of the various parts of the query is.
> There are low-level features in Derby which capture this information and
> record it, such as logQueryPlan, and the XPLAIN tables, but there is a lot
> of opportunity for designing higher-level tools which can process the query
> plan and execution statistics information and present it in a more
> comprehensible fashion. 

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message