OS
Your OS:
Ubuntu 24.04

Versions
The db-sync version (eg cardano-db-sync --version): 13.6.0.5, git revision cb61094, while cardano-node is 10.1.4
PostgreSQL version: 17

Build/Install Method
The method you use to build or install cardano-db-sync: prebuilt binaries

Run method
The method you used to run cardano-db-sync (eg Nix/Docker/systemd/none): systemd

Additional context
Seems to be similar to previously opened on sanchonet issue - #1901. Reported by users who were using koios and started getting duplicate entries for pools returned by koios pool_info endpoint that does a join with pool_stat on pool_hash_id and epoch_no assuming uniqueness.

Problem Report
Screenshot of sql query output summaring duplicate entries attached