Uploaded image for project: 'WiredTiger'
  1. WiredTiger
  2. WT-2443

Getting statistic for all indexes used in join cursor

    Details

    • Type: Question
    • Status: Resolved
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: WT2.8.0
    • Labels:
      None

      Description

      Hi!
      In attached example I create join cursor with 3 conditions on "index:main:index1", "index:main:index2" and "table:main", and after getting all results from join cursor, I want to see join statistic for every index and for table. I am trying to get it as follows:

      WT_CURSOR *statcur; 
      WT_CALL(session->open_cursor(session, "statistics:join", jcursor, NULL, &statcur));
      while (statcur->next(statcur) == 0)
      {
          const char *desc, *pvalue;
          uint64_t value;
       
          WT_CALL(statcur->get_value(statcur, &desc, &pvalue, &value));
          printf("%s=%s\n", desc, pvalue);
      }
      

      But i see statistic only for "index:main:index1":

      $ LD_LIBRARY_PATH=wiredtiger-2.7.0_develop ./jcursor_full_stat
      value from jcursor: key = 58, v1 = 58, v2 = 8
      value from jcursor: key = 68, v1 = 68, v2 = 8
      value from jcursor: key = 78, v1 = 78, v2 = 8
      value from jcursor: key = 88, v1 = 88, v2 = 8
      join: index:main:index1: accesses=4
      join: index:main:index1: actual count of items=90
      join: index:main:index1: bloom filter false positives=0
      

      How can I get statistic for others conditions?

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                donald.anderson Donald Anderson
                Reporter:
                Denis Shkirya Denis Shkirya
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: