search

zubkov-andrei / pg_profile

Postgres historic workload reports
Other
236 stars 33 forks source link

report is empty #76

Closed herwigg closed 1 year ago

herwigg commented 1 year ago

Hi, installation of pg_profile is ok, creating of a local and test server is ok, I scheduled every half hout to take a sample, that is working fine. But when I try to view a report is is almost empty: it just contains a header and a lot of spaces or hyphen or underscore characters. This is a report for the last 24 hours on a Postgres version 15 instance. Postgres profile report (6 -43) pg_profile version 4.2

Server name: PTC13

Monitoring for PTC13

Report interval: 2023-09-26 15:26:04+02 - 2023-09-27 13:30:01+02

Report sections

any ideas what could cause these (empty) reports ?

zubkov-andrei commented 1 year ago

Hi! What exact command did you use to create an .html file of a report?

herwigg commented 1 year ago

Hi, I did psql ... -c "select get_report('PTC13',tstzrange(now() - interval '1 day',now()))" -o last24h_report.html

zubkov-andrei commented 1 year ago

Are there '-Aqt' keys in your command (behind the '...')?

herwigg commented 1 year ago

no, there were not, I added these and now there is something in it. sorry it was stupid.

zubkov-andrei commented 1 year ago

Good!