Re: Postgres performance issue

You may consider using the Pgbadger tool. This tool extracts data from log
files and generates a comprehensive report.

Besides, a low INSERT rate is often attributed to a number of factors.

- A number of indexes
- A number of foreign keys
- A number of DB triggers
- A number of long-running queries
- Another processes contributing to the load
- Disk utilisation

Hope this helps!

Thanks,
Ninad

On Fri, Jun 17, 2022 at 3:04 PM Bo Victor Thomsen <
bo(dot)victor(dot)thomsen(at)gmail(dot)com> wrote:

>
> https://stackoverflow.com/questions/12206600/how-to-speed-up-insertion-performance-in-postgresql
>
> And You might temporary drop the primary key when bulk loading.
>
> Med venlig hilsen / Kind regards
>
> Bo Victor Thomsen
>
> Den 16-06-2022 kl. 11:43 skrev Nikhil Ingale:
> > Hi All,
> >
> > 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?
> >
> > Regards,
> > Nikhil Ingale
>
>
>