code: def get_pg_info():
      
      from psycopg2 import connect, OperationalError
      log.debug("entered get_pg_info")
      try:
          conf = settings.DATABASES['default']
          database = conf["NAME"]
          user = conf["USER"]
          host = conf["HOST"]
          port = conf["PORT"]
          password = conf["PASSWORD"]
      except (AttributeError, KeyError):
          log.error("No PostgreSQL connection info found in settings.")
          return {"status": NO_CONFIG}
      except TypeError:
          return {"status": DOWN}
      log.debug("got past getting conf")
      try:
          start = datetime.now()
          connection = connect(
              database=database, user=user, host=host,
              port=port, password=password, connect_timeout=TIMEOUT_SECONDS,
          )
          log.debug("at end of context manager")
          micro = (datetime.now() - start).microseconds
          connection.close()
      except (OperationalError, KeyError) as ex:
          log.error("No PostgreSQL connection info found in settings. %s Error: %s",
                    conf, ex)
          return {"status": DOWN}
      log.debug("got to end of postgres check successfully")
      return {"status": UP, "response_microseconds": micro}
docs: Check PostgreSQL connection.