Uploaded image for project: 'Couchbase Documentation'
  1. Couchbase Documentation
  2. DOC-11904

Document system:sequences, all_sequences & vitals keyspaces

    XMLWordPrintable

Details

    • Improvement
    • Resolution: Unresolved
    • Major
    • Trinity.M1
    • Trinity
    • query
    • None
    • 0

    Description

      To https://docs.couchbase.com/server/current/n1ql/n1ql-intro/sysinfo.html add:

       

      Querying Sequences

      You can query sequences using the system:sequences keyspace as follows:

       

      SELECT * FROM system:sequences;

       

      The query returns the following attributes:

      bucket (string) The bucket name.

      cache (integer) The sequence's cache size.

      cycle (boolean) If the sequence is defined to cycle or not.

      increment (integer) The sequence step value.

      min (integer) The minimum value permitted for the sequence.

      max (integer) The maximum value permitted for the sequence.

      name (string) The sequence's name.

      namespace (string) Namespace to which the sequence belongs.

      namespace_id (string) ID of the namespace to which the sequence belongs.

      path (string) The fully qualified sequence name.

      scope_id (string) The scope to which the sequence belongs.

      value (object) The each field in the value is a node UUID reporting the integer sequence value on that node.  In addition the field "~next_block" reports the starting value of the next block of values that can be reserved for the sequence.

      Note: Querying system:sequences only returns sequences that have been loaded (accessed since the last restart) on any node.  To see all defined sequences, use system:all_sequences.

       

      To  https://docs.couchbase.com/server/current/manage/monitor/monitoring-n1ql-query.html#system-keyspaces add:

      system:vitals

      This keyspace reports the same information as the /admin/vitals REST endpoint.

       

       

      Also add the table of contents link back to system:sequences in the "The following diagnostics are provided:" section on the page.

       

      (Would be nice if a search on "system catalog(ue)" returned this list of system keyspaces as an initial result; I find it doesn't return a result for the list itself.)

      Attachments

        Issue Links

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

          Activity

            People

              simon.dew Simon Dew
              Donald.haggart Donald Haggart
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty