I need to update one table in my database with simple code
This is the script
update finarh
set vid = left(nalog,1)
Table has 177714 rows.
First execution time was : 00:02:39 minutes
Repeated execution time: 00:01:03 minutes.
Explain query plan is:
"Update on finarh (cost=0.00..12049.99 rows=177714 width=172)"
" -> Seq Scan on finarh (cost=0.00..12049.99 rows=177714 width=172)"
Why execution time is so loooong ?
Thank's
Ilija Vidoevski