| From: | Julien Rouhaud <rjuju123(at)gmail(dot)com> |
|---|---|
| To: | Nikhil Ingale <niks(dot)bgm(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Postgres performance issue |
| Date: | 2022-06-17 02:00:06 |
| Message-ID: | 20220617020006.wbtzo4xm2qkefzvq@jrouhaud |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Hi,
On Thu, Jun 16, 2022 at 03:13:40PM +0530, Nikhil Ingale wrote:
>
> I'm seeing some performance issue that's bulk inserts are around 15 inserts
> per second which is very low. Do we have a performance mgmt tool in pg like
> AWR in oracle?
I don't know much about oracle or AWR, but you might be interested in
pg_stat_statements extension, or pg_wait_sampling (for wait events) and
pg_stat_kcache (for CPU/disk usage). There are tools that can perform regular
snapshot and display some dashboard based on that, like powa.
If that's not enough or what you need, you can look at
https://wiki.postgresql.org/wiki/Slow_Query_Questions to provide needed
information and get help optimizing your inserts.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kenny Bachman | 2022-06-17 08:48:00 | postrgesql query planner wrong desicion |
| Previous Message | 阿里巴巴开源镜像 | 2022-06-16 10:05:11 | Apply to become an official mirror |