I want to decrease the number of idle PostgreSQL requests coming in from fast-api calls. I am not able to figure out what exactly is leaving this many idle connections as multiple people are using this DB and APIs associated with it.

Can someone suggest what I might have done wrong to leave this many idle connections or an efficient way to figure out what is causing this so that I can accordingly fix that portion and decrease it somehow.

Not sure if I have provided sufficient information to explain this but if anything else is required, I will be more than happy to provide that information.

postgresql idle connection screenshot

This is how I am creating a PostgreSQL object via fastapi

class postgres:
    def __init__(self, config):
        try:
            SQLALCHEMY_DATABASE_URL = "postgresql://" + \
                config['postgresql']['user']+":"+config['postgresql']['password']+"@" + \
                config['postgresql']['host']+":5432" + \
                "/"+config['postgresql']['database']
            # print(SQLALCHEMY_DATABASE_URL)
            engine = create_engine(SQLALCHEMY_DATABASE_URL, future=True)
            self.SessionLocal = sessionmaker(
                autocommit=False, autoflush=True, bind=engine)
        except Exception as e:
            raise

    def get_db(self):
        """
        Function to return session variable used by ORM
        :return: SessionLocal
        """
        try:
            db = self.SessionLocal()
            yield db
        finally:
            db.close()