| From: | Heikki Linnakangas <hlinnaka(at)iki(dot)fi> |
|---|---|
| To: | Павел Еремин <pverjemin(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: profiling |
| Date: | 2021-01-14 12:55:18 |
| Message-ID: | 0432e701-f83c-f2f8-406b-38bd239c8429@iki.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 14/01/2021 12:14, Павел Еремин wrote:
> Hello. I am interested in the question of profiling. As far as I
> understand, this issue has not been resolved in postgres. And I see
> the urgency of this problem. Are there any postgres development plans
> for this functionality?
What exactly do you mean by profiling? You can profile internal C
functions with 'perf' or 'gprof' or similar. For profiling applications
using PostgreSQL, pg_stat_statement() is very helpful. And there is a
plugin for profiling PL/pgSQL functions, IIRC pgAdmin has a GUI for that.
- Heikki
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tomas Vondra | 2021-01-14 12:57:44 | Re: POC: postgres_fdw insert batching |
| Previous Message | Amit Kapila | 2021-01-14 12:44:43 | Re: Logical Replication - behavior of ALTER PUBLICATION .. DROP TABLE and ALTER SUBSCRIPTION .. REFRESH PUBLICATION |