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

Getting statistic for all indexes used in join cursor

    • Type: Icon: Task Task
    • Resolution: Done
    • Priority: Icon: Major - P3 Major - P3
    • WT2.8.0
    • Affects Version/s: None
    • Component/s: None
    • None

      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?

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

              Created:
              Updated:
              Resolved: