gvddlZddlZddlZddlZddlZdZdZdZdZe dkreej dSdS)Nc dt|D}tj}||tj}||z }||z }tjd|||fzdS)Ncg|]I}dddtjdtjddddtjdd d d d d d f JS){l# z90900023123.40031z 432.40031usome_óäæ_thingvaryingæi ri)decimalDecimaldatetime).0xs S/granary/edev/quantum/lib/python3.11/site-packages/postgresql/test/perf_query_io.py z!insertSamples..so    sL ?&'' ?; 4 T1b"aF33    zUINSERT Summary, inserted tuples: %d total time: %f average tuples per second: %f )rangetime load_rowssysstderrwrite)countinsert_recordsrecsgenfinxacttimeatss r insertSamplesr! s   <<    y{{$ y{{ #I x& (C(rc6d}d}tj}|D]}|dz }|t|z }tj}||z }||z }tjd||||dS)NrznSELECT Summary, looped: {looped} looptime: {looptime} tuples: {ntuples} average tuples per second: {tps} )loopedlooptimentuplestps)rchunkslenrrrformat)psloopstuplesgenesisrfinalisr%r s r timeTupleReadr0&s   9;; ))++Q1*%CFF&& 9;; g  ()/   )/))     rctdtd}td} t||t|tddS#tdwxYw)NzxCREATE TEMP TABLE samples (i2 int2, i4 int4, i8 int8, n numeric, n2 numeric, t text, v varchar, c char(2), ts timestamp)z?INSERT INTO samples VALUES ($1, $2, $3, $4, $5, $6, $7, $8, $9)zSELECT * FROM sampleszDROP TABLE samples)sqlexecpreparer!r0)rrselect_recordss rmainr5=s cdddC122 ~&&& ' s AA0cRtt|dgzddS)Niar#)r5int)argss rcommandr9Js)c45'>1 r__main__) osrrr rr!r0r5r9__name__argvrrr?s 2.        zr