PATCH: pgbench - break out timing data for initialization phases

From: "Rady, Doug" <radydoug(at)amazon(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: PATCH: pgbench - break out timing data for initialization phases
Date: 2018-01-22 23:38:39
Message-ID: 5F53DACE-0708-42CB-89A2-57BE95C9C19D@amazon.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

This patch breaks out the timing info for the individual initialization phases.

Today without the patch:
pgrun pgbench -i -s 2000 -F 90 -q
dropping old tables...
creating tables...
generating data...

200000000 of 200000000 tuples (100%) done (elapsed 171.39 s, remaining 0.00 s)
vacuuming...
creating primary keys...
done.

With patch & default init options:
pgrun pgbench -i -s 2000 -F 90 -q
dropping old tables...
creating tables...
generating data...

200000000 of 200000000 tuples (100%) done (elapsed 166.53 s, remaining 0.00 s)
vacuuming...
creating primary keys...
total time: 312.94 s (drop 0.00 s, tables 0.03 s, insert 166.58 s, commit 0.51 s, primary 92.59 s, foreign 0.00 s, vacuum 53.23 s)
done.

With patch and ‘-I dtgvpf’ options:
pgrun pgbench -i -s 2000 -F 90 -q -I dtgvpf
dropping old tables...
creating tables...
generating data...

200000000 of 200000000 tuples (100%) done (elapsed 168.76 s, remaining 0.00 s)
vacuuming...
creating primary keys...
creating foreign keys...
total time: 353.52 s (drop 1.67 s, tables 0.11 s, insert 168.82 s, commit 0.46 s, primary 92.32 s, foreign 40.11 s, vacuum 50.03 s)
done.

pgbench -i -s 2000 -F 90 -q -I d
dropping old tables...
total time: 1.96 s (drop 1.96 s, tables 0.00 s, insert 0.00 s, commit 0.00 s, primary 0.00 s, foreign 0.00 s, vacuum 0.00 s)
done.

pgrun pgbench -i -s 2000 -F 90 -q -I t
creating tables...
total time: 0.08 s (drop 0.00 s, tables 0.08 s, insert 0.00 s, commit 0.00 s, primary 0.00 s, foreign 0.00 s, vacuum 0.00 s)
done.

pgrun pgbench -i -s 2000 -F 90 -q -I g
creating tables...

200000000 of 200000000 tuples (100%) done (elapsed 165.62 s, remaining 0.00 s)
total time: 166.33 s (drop 0.00 s, tables 0.00 s, insert 165.68 s, commit 0.66 s, primary 0.00 s, foreign 0.00 s, vacuum 0.00 s)
done.

pgrun pgbench -i -s 2000 -F 90 -q -I p
creating primary keys...
total time: 100.93 s (drop 0.00 s, tables 0.00 s, insert 0.00 s, commit 0.00 s, primary 100.93 s, foreign 0.00 s, vacuum 0.00 s)
done.

doug

Attachment Content-Type Size
pgbench11-init-timing-v2.patch application/octet-stream 5.8 KB

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Munro 2018-01-22 23:41:27 Re: [HACKERS] Adding column_constraint description in ALTER TABLE synopsis
Previous Message Stephen Frost 2018-01-22 23:29:58 Re: [HACKERS] INSERT .. ON CONFLICT DO SELECT [FOR ..]