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: