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.victor.thomsen@gmail.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