rpeort filled with blank character

zubkov-andrei / pg_profile

Postgres historic workload reports

Other

236 stars 33 forks source link

rpeort filled with blank character #83

Closed gael-efluid closed 11 months ago

gael-efluid commented 11 months ago

Hello, I don't get why, but since few days the reports generated are really heavy (> 500Mo) and they are filled with blank character

Any idea on what's is going on ?

pgprofile_TP2_efluid_e2c.zip

zubkov-andrei commented 11 months ago

Maybe it is caused by incorrect command parameters used for report generation causing psql formatting. If psql is used, there should be -Aqt flags. Check the exact command noted in the docs:

psql -Aqtc "SELECT profile.get_report(480,482)" -o report_480_482.html

Just substitute you sample_id numbers there.

gael-efluid commented 11 months ago

Indeed, with the A parameter there is no blank in the report. I never used this parameter before, so I don't get why I faced thi issue just now... Anyway, thanks for the help !