db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Maneesha Jain <maneesha.j...@Sun.COM>
Subject question on SYSCS_SET_STATISTICS_TIMING(1);
Date Fri, 29 Jul 2005 17:13:20 GMT
Hi,

I'm using derby10.0.2.1 and I have set the following to enable the
timing statistics.

CALL SYSCS_UTIL.SYSCS_SET_RUNTIMESTATISTICS(1);
CALL SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1);


I was expecting to see the Optimize, Compile, Execute time in the
derby.log when SYSCS_UTIL.SYSCS_SET_STATISTICS_TIMING(1) is set to 1, as
shown in the example..


Statement Name:
        null
Statement Text:
        select * from countries
Parse Time: 20
Bind Time: 10
Optimize Time: 50
Generate Time: 20
Compile Time: 100
Execute Time: 10
Begin Compilation Timestamp : 2004-05-25 09:16:21.24
End Compilation Timestamp : 2004-05-25 09:16:21.34
Begin Execution Timestamp : 2004-05-25 09:16:21.35
End Execution Timestamp : 2004-05-25 09:16:21.4
Statement Execution Plan Text:
Table Scan ResultSet for COUNTRIES at read committed isolation
..
..

Instead, I only see the plan

SELECT 'com.sun.portal.community.mc.impl.jdo.pc.CommunityDp' AS
JPOXMETADATA,THIS.COMMUNITY_COMMUNITY_NAMEMR,THIS.LAST_MODIFIED,THIS.ROLE_NAME
FROM COMMUNITYDP THIS, communityuser where communityuser.USER_NAME =
'uid=test,ou=people,o=communitysample,dc=red,dc=iplanet,dc=com' AND
communityuser.community_community_namemr =
this.community_community_namemr and communityuser.role_name =
this.role_name ******* Project-Restrict ResultSet (6):
Number of opens = 1
Rows seen = 20
Rows filtered = 0
restriction = false
projection = true
	constructor time (milliseconds) = 0
	open time (milliseconds) = 1
	next time (milliseconds) = 5
	close time (milliseconds) = 0
	restriction time (milliseconds) = 0
	projection time (milliseconds) = 0
	optimizer estimated row count:           18.00
	optimizer estimated cost:          738.65

Source result set:
	Nested Loop Exists Join ResultSet:
	Number of opens = 1
	Rows seen from the left = 20
	Rows seen from the right = 20
	Rows filtered = 0
	Rows returned = 20
		constructor time (milliseconds) = 0
		open time (milliseconds) = 1




What setting am I missing..

Maneesha



Mime
View raw message