paulr135 wrote:
I'll issue this command over the weekend when I don't have anything planned for this machine.
Here is the output from this command: sql>trace ALTER TABLE table1 ADD CONSTRAINT table1_pkey PRIMARY KEY (opc,session_id,session_start,domain_id); operation successful +---------------+------------------------------------------------------------------------------------------------------------------------------------------+ | ticks | stmt | +===============+==========================================================================================================================================+ | 2 | _2 := sql.mvc(); | | 31639286 | sql.catalog(29,"sys",46912720421368,0); | | 17078 | _50:bat[:oid,:int] <tmp_401>[164680974] := sql.bind(_2=265069960,"sys","table1","session_start",0); | | 7 | _51:bat[:oid,:oid] <tmp_4372>[0] := sql.bind_dbat(_2=265069960,"sys","table1",1); | | 19628 | _57:bat[:oid,:int] <tmp_4063>[164680974] := sql.bind(_2=265069960,"sys","table1","domain_id",0); | | 2 | _40:bat[:oid,:oid] <tmp_4372>[0] := sql.bind_dbat(_2=265069960,"sys","table1",1); | | 23480 | _53<tmpr_4372>[0] := bat.reverse(_51=nil:bat[:oid,:oid]); | | 10 | _37:bat[:oid,:str] <tmp_4064>[164680974] := sql.bind(_2=265069960,"sys","table1","opc",0); | | 2 | _42<tmpr_4372>[0] := bat.reverse(_40=nil:bat[:oid,:oid]); | | 4 | _29:bat[:oid,:int] <tmp_4063>[164680974] := sql.bind(_2=265069960,"sys","table1","domain_id",0); | | 2 | _24:bat[:oid,:int] <tmp_401>[164680974] := sql.bind(_2=265069960,"sys","table1","session_start",0); | | 166240 | _54<tmp_5375>[164680974] := algebra.kdifference(_50=nil:bat[:oid,:int],_53=<tmpr_4372>[0]); | | 9 | _60<tmp_5106>[164680974] := algebra.kdifference(_57=nil:bat[:oid,:int],_53=nil); | | 6 | _10:bat[:oid,:oid] <tmp_4372>[0] := sql.bind_dbat(_2=265069960,"sys","table1",1); | | 3 | _12<tmpr_4372>[0] := bat.reverse(_10=nil:bat[:oid,:oid]); | | 6 | _7:bat[:oid,:str] <tmp_4064>[164680974] := sql.bind(_2=265069960,"sys","table1","opc",0); | | 11 | _13<tmp_5222>[164680974] := algebra.kdifference(_7=nil:bat[:oid,:str],_12=nil); | | 6 | _14<tmp_3001>[164680974] := algebra.markT(_13=<tmp_5222>[164680974],40@0); | | 10 | _43<tmp_4716>[164680974] := algebra.kdifference(_37=nil:bat[:oid,:str],_42=<tmpr_4372>[0]); | | 2 | _19<tmpr_3001>[164680974] := bat.reverse(_14=<tmp_3001>[164680974]); | | 919879 | _27<tmp_2201>[164680974] := algebra.join(_19=<tmpr_3001>[164680974],_24=nil:bat[:oid,:int]); | | 6 | _15<tmpr_5222>[164680974] := bat.reverse(_13=nil); | | 26 | _16<tmp_5407>[164680974] := algebra.markT(_15=nil,40@0); | | 2 | _17<tmpr_5407>[164680974] := bat.reverse(_16=nil); | | 2485261 | _46:bat[:oid,:str] <tmp_3757>[164680974] := sql.bind(_2=265069960,"sys","table1","session_id",0); | | 2400816 | _20:bat[:oid,:str] <tmp_3757>[164680974] := sql.bind(_2=265069960,"sys","table1","session_id",0); | | 433385817 | _18:bat[:oid,:wrd] <tmp_5222>[164680974] := batcalc.hash(_17=nil); | | 694328 | _22<tmp_3401>[164680974] := algebra.join(_19=<tmpr_3001>[164680974],_20=nil:bat[:oid,:str]); | | 124881 | _47<tmp_5407>[164680974] := algebra.kdifference(_46=nil:bat[:oid,:str],_42=nil); | | 342530876 | _23:bat[:oid,:wrd] <tmp_4461>[164680974] := mkey.bulk_rotate_xor_hash(_18=nil:bat[:oid,:wrd],13,_22=nil); | | 69012 | _32<tmp_5222>[164680974] := algebra.join(_19=nil,_29=nil:bat[:oid,:int]); | | 154609537 | _28:bat[:oid,:wrd] <tmp_3401>[164680974] := mkey.bulk_rotate_xor_hash(_23=nil:bat[:oid,:wrd],13,_27=nil); | | 164904736 | _33:bat[:oid,:wrd] <tmp_2201>[164680974] := mkey.bulk_rotate_xor_hash(_28=nil:bat[:oid,:wrd],13,_32=nil); | | 64829749 | _34<tmp_3401>[164680974] := algebra.join(_14=nil,_33=nil:bat[:oid,:wrd]); | | 2076716851584 | (ext50<tmp_5222>[164680974],grp48<tmp_2201>[164680974]) := group.new(_34=<tmp_3401>[164680974]); | | 98080 | (ext60<tmp_5222>[164680974],grp58<tmp_2201>[164680974]) := group.derive(ext50=nil,grp48=nil,_43=nil); | | 31141 | (ext67<tmp_5222>[164680974],grp65<tmp_2201>[164680974]) := group.derive(ext60=nil,grp58=nil,_47=nil); | | 17406 | (ext75<tmp_5222>[164680974],grp73<tmp_2201>[164680974]) := group.derive(ext67=nil,grp65=nil,_54=nil); | | 12755 | (ext84<tmp_5222>[164680974],grp82<tmp_2201>[164680974]) := group.done(ext75=nil,grp73=nil,_60=nil); | | 19898 | _63<tmp_5106>[164680974] := bat.mirror(ext84=nil); | | 441620849 | _64:bat[:oid,:wrd] <tmp_5407>[164680974] := aggr.count(grp82=nil,grp82=nil,_63=nil); | | 34240 | _65 := aggr.count(_64=<tmp_5407>:bat[:oid,:wrd][164680974]); | | 18001302 | return sum := aggr.sum(b=<tmp_5407>[164680974],true); | | 22537773 | _66:wrd := aggr.sum(_64=nil:bat[:oid,:wrd]); | | 39809 | _67 := calc.isnil(_66=164680974:wrd); | | 8 | _68 := calc.ifthenelse(_67=false,0:wrd,_66=164680974:wrd); | | 3 | _69 := calc.!=(_65=164680974:wrd,_68=164680974:wrd); | | 2078347613459 | barrier _92 := language.dataflow(); | | 30002 | sql.assert(_69=false,"UPDATE: PRIMARY KEY constraint 'table1.table1_pkey' violated"); | | 155370749 | sql.update(_2=265069960,"sys","table1","table1_pkey",_34=nil); | | 100795 | sql.exportOperation(""); | | 2078534997850 | user.s2_3(); | +---------------+------------------------------------------------------------------------------------------------------------------------------------------+ 52 tuples Timer 2078538307.087 msec 52 rows Hope this helps. -- View this message in context: http://old.nabble.com/Add-primary-key-performance-tp30397515p30663027.html Sent from the monetdb-users mailing list archive at Nabble.com.