Display Last SQL Run Time

When the \timing meta-command in vsql is set to “on”, Vertica will return how long (in milliseconds) each SQL statement runs.

That’s great! But what if you forgot to turn it on prior to executing a long running query? Instead of turning it on then re-executing that long ruing query, simply check the CURRENT_SESSION system to get the run time of your previous SQL statement!