search

zubkov-andrei / pg_profile

Postgres historic workload reports
Other
228 stars 33 forks source link

400MB html report #101

Closed cwang9208 closed 3 months ago

cwang9208 commented 3 months ago

Hi,

I just found that the generated report can be as large as 400+MB using the latest pg_profile-4.6. It's even difficult to open that html in browser. I guess there should be some bug. It's quite easy to reproduce: on a fresh Ubuntu 22.04 system with PostgreSQL-14 installed using apt-get. Then just install the pg_profile-4.6 and take 2 samples and generate a report.

Could anyone help look into this problem?

cwang9208 commented 3 months ago

Besides, the generated report is not readable. It only has the following content:

Postgres profile report

(1 row)
zubkov-andrei commented 3 months ago

Hi!

Did you use all psql flags noted in docs while building a report? Those '-Aqt' are required to exclude psql output format.

cwang9208 commented 3 months ago

@zubkov-andrei '-Aqt' fixes the problem. Thanks.