pg_gather
pg_gather copied to clipboard
jobinau
Rarely users reported that additonal empty column appears along with wait-event data
A few users directly contacted and reported that sometimes they experience data import failures due to an additional empty column appearing data related to wait-events to pg_pid_wait. Even though the issue was reported on a very old version (v7), since it was not reproducible, noone filed a bug yet..
So I am creating this bug report on behalf of all of them.
One possiblity that I could think about is some users accidently runs the gather.sql with -x (expanded formatting), instead of -X (--no-psqlrc). I such cases the output file might contain an extra column related to the pg_sleep which is undesirable.
Commit https://github.com/jobinau/pg_gather/commit/e1114729f40ffc1648c7faed8b84cc17bc209fbc is expected to address this problem also. because there is not separate pg_sleep statement send to server