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@xxxxxxxxx> 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
