Issue with query b1 on postgres 12

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 116 forks source link

Issue with query b1 on postgres 12 #43

Closed gowtham500 closed 4 years ago

gowtham500 commented 4 years ago

Hello Nicholas,

Thanks for this awesome tool. This issue is with option b1 – Tables Bloat, rough estimation. I am running on postgres 12.1 and got this error

psql:/var/lib/pgsql/postgres_dba/sql/b1_table_estimation.sql:99: ERROR:  column tbl.relhasoids does not exist
LINE 19:       + case when tbl.relhasoids then 4 else 0 end as tpl_hd...

Can you please include support for postgres 12

NikolayS commented 4 years ago

Thank you @gowtham500 for this bug report.

Fixed this error, as well as the problem with p1 report in Postgres 12: https://github.com/NikolayS/postgres_dba/pull/44

Merged to master, please test.