public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Pecsök Ján <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Reading execution plan - first row time vs last row time
Date: Wed, 2 Oct 2024 11:32:39 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <AS1PR05MB9105F8A79577EC7D8132C6449F702@AS1PR05MB9105.eurprd05.prod.outlook.com>
References: <AS1PR05MB91059DA7056B7C30EAE61AA59F772@AS1PR05MB9105.eurprd05.prod.outlook.com>
<[email protected]>
<AS1PR05MB9105F8A79577EC7D8132C6449F702@AS1PR05MB9105.eurprd05.prod.outlook.com>
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
>> [email protected] <mailto:[email protected]> www.profinit.eu
>> <https://www.profinit.eu/;
>>
>> <https://www.profinit.eu/;
>>
>
> --
> Adrian Klaver
> [email protected]
>
--
Adrian Klaver
[email protected]
view thread (2+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Reading execution plan - first row time vs last row time
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox