elapsed time executing query

[expired user #9126]'s profile image [expired user #9126] posted 7 years ago in Feature discussion Permalink

Hello! I'm running a lot of long queries (10+ minutes, some also in hours). It would be very helpful if status bar would show elapsed time since start of query execution. It shows and updates server uptime, it shows time when query execution started, ... but how long it is running is more interesting/important. My common use case is for example that I modify query and wait for few minutes for results... but can't know if it is near (usual) completion or was "stuck" and should be rewritten.

Best regards, Boštjan

ansgar's profile image ansgar posted 7 years ago Permalink

I also noticed that the elapsed time would help more than the start time does. So I guess I could change the very right status panel in that way.

[expired user #9126]'s profile image [expired user #9126] posted 7 years ago Permalink

Yes, I believe this would be great. Best regards, Boštjan

apric's profile image apric posted 7 years ago Permalink

A useful feature suggestion!

Code modification/commit 886b002 from Ansgar Becker <anse@heidisql.com>, 7 years ago, revision 9.5.0.5259
While executing a user query, display elapsed execution time in hh:mm:ss format, on status bar. See https://www.heidisql.com/forum.php?t=24763
ansgar's profile image ansgar posted 7 years ago Permalink

Latest HeidiSQL build now show the elapsed time in hh:mm:ss format instead of just the starting time.

Please login to leave a reply, or register at first.