Re: how to do profile for pg?
| От | jacktby@gmail.com |
|---|---|
| Тема | Re: how to do profile for pg? |
| Дата | |
| Msg-id | 1695306168433.givp3hqcvsnqevptfpzk1apf@android.mail.163.com обсуждение исходный текст |
| Ответ на | Re: how to do profile for pg? (Aleksander Alekseev <aleksander@timescale.com>) |
| Ответы |
Re: how to do profile for pg?
|
| Список | pgsql-hackers |
but I need a quick demo to see the memory profiling or CPU profiling. I hope a blog or a video which is better for me. Thanks.
---- Replied Message ----
| From | Aleksander Alekseev<aleksander@timescale.com> |
| Date | 09/21/2023 22:02 |
| To | pgsql-hackers<pgsql-hackers@lists.postgresql.org> |
| Cc | jacktby@gmail.com |
| Subject | Re: how to do profile for pg? |
Hi jacktby,
PostgreSQL is literally a large and complicated program in C. Thus it
can be profiled as such. E.g. you can use `perf` and build flamegraphs
using `perf record`. Often pgbench is an adequate tool to compare
before and after results.There are many other tools available
depending on what exactly you want to profile - CPU, lock contention,
disk I/O, etc. People write books (plural) on the subject. Personally
I would recommend "System Performance, Enterprise and the Cloud, 2nd
Edition" and "BPF Performance Tools" by Brendan Gregg.
--
Best regards,
Aleksander Alekseev
PostgreSQL is literally a large and complicated program in C. Thus it
can be profiled as such. E.g. you can use `perf` and build flamegraphs
using `perf record`. Often pgbench is an adequate tool to compare
before and after results.There are many other tools available
depending on what exactly you want to profile - CPU, lock contention,
disk I/O, etc. People write books (plural) on the subject. Personally
I would recommend "System Performance, Enterprise and the Cloud, 2nd
Edition" and "BPF Performance Tools" by Brendan Gregg.
--
Best regards,
Aleksander Alekseev
В списке pgsql-hackers по дате отправления: