PgHero.capture_space_stats fails with "No unique index found for #{name_or_columns}" about pghero

[ankane]

Hi @thisIsLoading, I'm not really sure how to reproduce the error (the method works fine if I remove the id column from pghero_space_stats), but in general, using a hypertable to store space stats isn't supported.

[thisIsLoading]

hi @ankane maybe you misunderstood. i do not store the stats in a hypertable. the rails db just happens to have a hypertable.

i installed it exactly like you pointed out in the readme

[thisIsLoading]

and my thought was about that these OTHER hypertables might cause pghero to error out, but i dont know.

[ankane]

I'm able to reproduce the error if I delete the pghero_space_stats table, so I think that's the actual issue.

[luizkowalski]

I see the same error using the pghero from GitHub/main. The database is Fly.io's Postgres