Uploaded image for project: 'Red Hat Data Grid'
  1. Red Hat Data Grid
  2. JDG-7304

Hybrid remote queries statistics seem incorrect

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • RHDG 8.5.2 GA
    • None
    • None

      Running a performance benchmark with Keycloak, originated the following statistics for indexed queries.
      The hybrid query max duration is 521'324'713'458'648 nanoseconds, which is way too high. The maximum response time in the benchmark was 58ms.

          "indexed_local" : {
            "count" : 14000,
            "average" : 1461806.270357143,
            "max" : 18572555,
            "slowest" : "DELETE FROM keycloak.RemoteAuthenticatedClientSessionEntity WHERE (userSessionId = :p0)"
          },
          "indexed_distributed" : {
            "count" : 21000,
            "average" : 1160159.8945238094,
            "max" : 38768261,
            "slowest" : "DELETE FROM keycloak.RemoteAuthenticatedClientSessionEntity WHERE (userSessionId = :p0)"
          },
          "hybrid" : {
            "count" : 7000,
            "average" : 5.212894825635777E14,
            "max" : 521324713458648,
            "slowest" : "SELECT __HSearch_This, __ISPN_Version FROM keycloak.RemoteAuthenticatedClientSessionEntity"
          },
      
      

              fercoli@redhat.com Fabio Massimo Ercoli
              pruivo@redhat.com Pedro Ruivo
              Anna Manukyan Anna Manukyan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: