# MySQL: Tracing a single query with PERFORMANCE\_SCHEMA | Percona Community
**URL:** https://forums.percona.com/t/mysql-tracing-a-single-query-with-performance-schema-percona-community/20621
**Category:** Community website
**Created:** [March 16, 2023, 12:29pm UTC](https://forums.percona.com/t/mysql-tracing-a-single-query-with-performance-schema-percona-community/20621 "2023-03-16T12:29:24Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@daniil.bazhenov](https://forums.percona.com/u/daniil.bazhenov)
#### Post date: [March 16, 2023, 12:29pm UTC](https://forums.percona.com/t/mysql-tracing-a-single-query-with-performance-schema-percona-community/20621/1 "2023-03-16T12:29:24Z")
My task is to collect performance data about a single query, using `PERFORMANCE_SCHEMA` (P\_S for short) in MySQL, to ship it elsewhere for integration with other data.
* * *
This is a companion discussion topic for the original entry at [https://percona.community/blog/2022/10/18/mysql-tracing-a-single-query-with-performance\_schema/](https://percona.community/blog/2022/10/18/mysql-tracing-a-single-query-with-performance_schema/)
---
### Author:  [@Aleksandra\_Abramova](https://forums.percona.com/u/Aleksandra_Abramova)
#### Post date: [March 27, 2023, 11:45am UTC](https://forums.percona.com/t/mysql-tracing-a-single-query-with-performance-schema-percona-community/20621/2 "2023-03-27T11:45:25Z")
Comment by @lefred:
Hi Kristian,
Nice post (as usual), just one little comment, on 8.0 itโs advised to use the format\_pico\_time() internal function instead of the sys.format\_time() ๐
Cheers.
---
### Author:  [@daniil.bazhenov](https://forums.percona.com/u/daniil.bazhenov)
#### Post date: [March 27, 2023, 11:45am UTC](https://forums.percona.com/t/mysql-tracing-a-single-query-with-performance-schema-percona-community/20621/3 "2023-03-27T11:45:25Z")