NikolayS / postgres_dba

The missing set of useful tools for Postgres DBAs and all engineers
BSD 3-Clause "New" or "Revised" License
1.12k stars 115 forks source link

a1: alignment padding report #6

Closed NikolayS closed 6 years ago

NikolayS commented 6 years ago

see #5

Simple example:

create table bad1  as select 2::int2, 8::int8, 4::int4 from generate_series(1, 1000000);
create table good1 as select 2::int2, 4::int4, 8::int8 from generate_series(1, 1000000);

and then use :dba: and select a1 report to see the difference:

screen shot 2018-01-30 at 15 26 55