Haven't started experimenting with Hibernate Tools yet, as we're just on the cusp of upgrading to 3.X. One of the things I'm curious to learn is whether or not Hibernate Tools' console view gives any information about lazy loading / eager fetching. Since the difference between these, in both directions, can be important from a performance point of view, it would be handy to be able to test queries' response with respect to these.

Is that something you can easily do in the console?

What information do you want ?

Today the only usefull thing you get in this respect is the dynamic query translator view which shows you the sql that will be executed for a given query.

I also want to somehow show what part of the result that is proxied and not yet initialized, but I have not gotten around to implement that yet.

Yes, basically what you said -- the query's a good start, but the other elements you're talking about would also be useful.

I'd like to know what part of the query results is eagerly fetched vs. lazily loaded, and which objects have proxies and which don't.

I'm not sure if it's possible for an object in the query results to be both proxied and loaded (without code outside the query actually doing the loading), but if so, I'd like to be tell that too.

That'd give me a lot of information in terms of tuning a query to achieve desired results in terms of ensuring that the objects I expect to use have been loaded, and that if I expect a lot of object activity, they will or won't have the proxy overhead.

I have information enough to show which objects are full, proxied and proxied+loaded just need to find a way to visualize it.

What I don't have is real information about wether objects were eagerly or lazily fetched.

But you can most likely deduce that from the proxy-state + the sql preview + showing numbers from the statistics generation.