Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-14703

Missing stats on Index ( total-index-items, avg item size, scan/requests)

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Critical
    • 4.0.0
    • 4.0.0
    • secondary-index
    • Security Level: Public
    • None
    • 400-1955
      centos
      1 node, 2 indexes gsi
    • Untriaged
    • Unknown

    Description

      0. create bucket default, create index on default(name) where name="mary"
      cbq> select * from system:indexes;
      {
      "requestID": "561a54ce-16f5-47ba-ad8d-3bd47af9227c",
      "signature":

      { "*": "*" }

      ,
      "results": [
      {
      "indexes":

      { "condition": "(`name` = \"mary\")", "datastore_id": "http://127.0.0.1:8091", "id": "828a4aee976b196e", "index_key": [ "`name`" ], "keyspace_id": "default", "name": "name", "namespace_id": "default", "state": "online", "using": "gsi" }

      }
      ],
      "status": "success",
      "metrics":

      { "elapsedTime": "231.369511ms", "executionTime": "230.724424ms", "resultCount": 2, "resultSize": 833 }

      }
      1. load 1M items on a bucket default, note indexes are in "ready state"
      2. NOticed that there are a number of stats on the index-stats which are never updated.

      eg:
      total items
      avg item size
      scans/sec ( not sure if this is relevant, since there are no queries addressed to the index at this point)

      The only stats getting updated are "items remaining", disk-size, data-size and drain rate.

      attached is a screenshot, attaching logs.

      I would expect the above numbers to be reflected on the stats, especially when the index is in a "Built" and ready status.

      Attachments

        Issue Links

          No reviews matched the request. Check your Options in the drop-down menu of this sections header.

          Activity

            People

              sarath Sarath Lakshman
              ketaki Ketaki Gangal (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty