here is the update section which take very long to run. ==>328001.274
ms
"Index Scan using idx_template_product on template_product
(cost=2729612.82..2729621.18 rows=1 width=87) (actual
time=327643.885..327643.889 rows=1 loops=1)"
" Index Cond: (id = 10566)"
" InitPlan 1 (returns $0)"
" -> Aggregate (cost=2729612.81..2729612.82 rows=1 width=0)
(actual time=327643.769..327643.769 rows=1 loops=1)"
" -> Bitmap Heap Scan on template_all_in_one
(cost=604031.87..2693572.99 rows=14415929 width=0) (actual
time=94229.880..324091.136 rows=14753612 loops=1)"
" Recheck Cond: (template_article_name =
'aname'::text)"
" -> Bitmap Index Scan on
idx_template_article_name_all_in_one (cost=0.00..600427.89
rows=14415929 width=0) (actual time=94209.983..94209.983 rows=14753617
loops=1)"
" Index Cond: (template_article_name =
'aname'::text)"
"Total runtime: 328001.274 ms"