Feedback-ID: i76984098:Fastmail
Message-ID: <2bd8e4fc-62d1-4160-905b-f691c99dcdc0@aklaver.com>
Date: Wed, 2 Oct 2024 11:32:39 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Reading execution plan - first row time vs last row time
To: =?UTF-8?B?UGVjc8O2ayBKw6Fu?= <jan.pecsok@profinit.eu>,
 "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <AS1PR05MB91059DA7056B7C30EAE61AA59F772@AS1PR05MB9105.eurprd05.prod.outlook.com>
 <fe081f9e-6d93-4c4e-8ceb-90f6e81ee8b8@aklaver.com>
 <AS1PR05MB9105F8A79577EC7D8132C6449F702@AS1PR05MB9105.eurprd05.prod.outlook.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <AS1PR05MB9105F8A79577EC7D8132C6449F702@AS1PR05MB9105.eurprd05.prod.outlook.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/2bd8e4fc-62d1-4160-905b-f691c99dcdc0%40aklaver.com>
Precedence: bulk

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_111111111  with (fillfactor = 100, parallel_workers = 20, autovacuum_enabled = false, toast.autovacuum_enabled = false) as select
>        VHS.df_v_Table2_key
>      , df_Table3_key
>      , df_Table4
>      , null::varchar as ID3Table5
>      , EH.IDTable5
>      , EH.ID2Table5
> from dm.v_Table1_KT as VHS
> left outer join dm.v_Table5 as EH using (df_v_Table5_key, df_Table3_key, df_Table4)
> where VHS.df_Table4 = any ('{T}')
>      and VHS.df_Table4 = 'T' and VHS.df_Table3_key = 111111111;

I'm thinking it would be better to do something like:

create table dm.v_Table6_T_111111111 as select ... with no data

to create the table structure.

Then use COPY or batch INSERT to move the data into the table.


>>
>> S pozdravem
>>
>> *Ján Pecsők*
>>
>> Tychonova 2, 160 00 Praha
>> Mobil: +420 775 942 871
>> jan.pecsok@profinit.eu <mailto:jan.pecsok@profinit.eu> www.profinit.eu
>> <https://www.profinit.eu/>
>>
>> <https://www.profinit.eu/>
>>
> 
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com