How to view the precise time of running an SQL statement ？

Question

It's for mysql. In mysql, the default shows in seconds. I want the time unit to be accurated to milliseconds.

mysql does not have this feature. PostgresSql does, [Read More](http://stackoverflow.com/questions/2572209/why-doesnt-mysql-support-millisecond-microsecond-precision) — Ibu, Jun 30 '11 at 07:15

niktrs · Answer 1 · 2011-06-30T07:23:43.763

1

edited Jun 30 '11 at 07:23

answered Jun 30 '11 at 07:18

niktrs

score 1 · Answer 2 · answered Jun 30 '11 at 07:33

Personally I tend to find it a better thing to do at the app level. A query can be slow for a multitude of reasons:

If you log the complete query time as seen by the app, you spot more bottlenecks.

score 0 · Answer 3 · answered Jun 30 '11 at 08:19

0

answered Jun 30 '11 at 08:19

Devart

3 Answers3