On 10/2/24 02:37, Pecsök Ján wrote:
Ok, I replaced names of tables and columns and here is the query
explain (analyze, verbose, settings, format text) create table
dm.v_Table6_T_1 with (fillfactor = 100, parallel_workers = 20,
autovacuum_enabled = false, toast.autovacuum_enabled = fal
Ok, I replaced names of tables and columns and here is the query
explain (analyze, verbose, settings, format text) create table
dm.v_Table6_T_1 with (fillfactor = 100, parallel_workers = 20,
autovacuum_enabled = false, toast.autovacuum_enabled = false) as select
VHS.df_v_Table2_k
Dear community,
We see significant difference in explain analyze Actual time in the first line
of execution plan and Execution time in the last line of execution plan. What
can be the reason?
For example, first line of execution plan:
Gather (cost=1038.49..257627100.42 rows=794326 width=10
=?iso-8859-2?Q?Pecs=F6k_J=E1n?= writes:
> We see significant difference in explain analyze Actual time in the first
> line of execution plan and Execution time in the last line of execution plan.
> What can be the reason?
The time reported for the top query node is just the time taken to
comput
On Tue, Oct 1, 2024 at 9:53 AM Pecsök Ján wrote:
> We see significant difference in explain analyze Actual time in the first
> line of execution plan and Execution time in the last line of execution
> plan. What can be the reason?
>
>
>
> For example, first line of execution plan:
>
> Gather (co
On 10/1/24 06:53, Pecsök Ján wrote:
Dear community,
We see significant difference in explain analyze Actual time in the
first line of execution plan and Execution time in the last line of
execution plan. What can be the reason?
For example, first line of execution plan:
Gather (cost=1038.4
