Details

    • 0

    Description

      dear team, 

      we are using EE of couchbase Licensed versions only.
      but we could not dependent on couchbase Professional services all the time.

       

      allow us as well to query on few system data which is useful on day to day tasks. we unable to query it at this moment. 

      we need few specific views to get data in json or table format also fine.
       here is the example: 

      while hitting this api it is giving data in some format , here can see many things but not in formatted. and we can't apply conditions here like where avg_scan_latency is above 10k ,

      we are dependent on other jq and os commands to filter or grep to view the content. 

      can't we get this info like n1ql queries from system datasets. if it is there DBA only can understand few things which is not needed to involve Professional services. any why we can reach them when we need, but not very frequently. 

      SELECT `key` AS indexname,
             items_count,
             data_size,
             disk_size,
             last_known_scan_time,
             memory_used,
             num_docs_indexed,
             num_scan_errors,
             num_scan_timeouts,
             scan_bytes_read,
             total_scan_duration,
             avg_drain_rate,
             avg_item_size,
             avg_scan_latency,
             cache_hit_percent,
             cache_hits,
             cache_misses
      FROM `system`.`indexstats`.`basic_stats`
      WHERE `key` IS NOT MISSING ;

      curl -X GET -u naveen.karanam "http://[localhost]:9102/api/v1/stats/

      Attachments

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

        Activity

          People

            eben Eben Haber
            kanamani92 naveen karanam
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Gerrit Reviews

                There are no open Gerrit changes

                PagerDuty