Brian Cox <brian.cox@ca.com> writes:
> The application log shows that 99652 rows are being inserted into
> relation ts_stats_transet_user_daily. 5 threads are doing the inserts.
pg_stat_activity says those five threads are doing nothing except
sitting around with open transactions. You sure you don't have a bug on
the application side?
regards, tom lane