Performance Schema Functions Given a numeric Performance Schema latency or wait time in picoseconds, converts it to human- readable format and returns a string consisting of a value and a units indicator. The string contains the decimal time rounded to 2 decimal places and a minimum of 3 significant digits. Times under 1 nanosecond are represented as whole numbers and are not rounded. The units indicator depends on the size of the time-value argument as shown in the following table. Argument Value Result Units Result Units Indicator Up to 10$^{3}$  −  1 picoseconds ps Up to 10$^{6}$  −  1 nanoseconds ns Up to 10$^{9}$  −  1 microseconds us Up to 10$^{12}$  −  1 milliseconds ms Up to 60×10 $^{12}$  −  1 seconds s Up to 3.6×10 $^{15}$  −  1 minutes min Up to 8.64×10 $^{16}$  −  1 hours h 8.64×10 $^{16}$ and up days d mysql>  SELECT FORMAT_PICO_TIME(3501), FORMAT_PICO_TIME(188732396662000); +------------------------+-----------------------------------+ | FORMAT_PICO_TIME(3501) | FORMAT_PICO_TIME(188732396662000) | +------------------------+-----------------------------------+ | 3.50 ns | 3.15 min | +------------------------+-----------------------------------+ FORMAT_PICO_TIME()  was added in MySQL 8.0.16. It may be used instead of the  sys  schema format_time()  function, keeping in mind these differences: Returns a  BIGINT UNSIGNED  value representing the Performance Schema thread ID assigned to the current connection. The thread ID return value is a value of the type given in the  THREAD_ID  column of Performance Schema tables. Performance Schema configuration affects  PS_CURRENT_THREAD_ID()  the same way as for PS_THREAD_ID() . For details, see the description of that function. 2435 mysql>  SELECT PS_CURRENT_THREAD_ID(); +------------------------+ | PS_CURRENT_THREAD_ID() | +------------------------+ | 52 | +------------------------+ mysql>  SELECT PS_THREAD_ID(CONNECTION_ID()); +-------------------------------+ | PS_THREAD_ID(CONNECTION_ID()) | +-------------------------------+ | 52 | +-------------------------------+ •To indicate minutes,  sys.format_time()  uses the  m  units indicator, whereas FORMAT_PICO_TIME()  uses  min . • sys.format_time()  uses the  w  (weeks) units indicator.  FORMAT_PICO_TIME()  does not. • PS_CURRENT_THREAD_ID()