list indices

list indices <filter>  [--file_path] [--base_classes] [--sub_classes] [--options] [--field_indices] [--cache_info] [--block_info] [--properties] [--all]

Lists indices. This command requires connection to a user database.

Arguments

Argument	Explanation
filter	index name regex

Options

Option	Explanation
–file_path, -f	display file path to index
–base_classes, -b	display base classes
–sub_classes, -s	display sub classes
–options, -o	show index options
–field_indices, -fi	show field indices
–cache_info, -ci	show cache info
–block_info, -bi	show block info
–properties, -bi	show configuration options
–all, -a	show all details

Example

Interactive

tomas@tomsmbp:~/ > dboo example_queries -u=example_user -p=password
dboo example_user@example_queries> list indices --all
Customer [hashmap]: 7 objects, 0 bytes (0B): good
  File path: /Users/tomas/.dboo/databases/a81e8a1c79080013/a81f8a1c79080023.tix
  Cache: 7089842494722108783, used: 7089075250099351407 update buffer: 3546691562981651297, used: 3474869486662793317
  Block count: 12115960775254474803, index entries per block: 8372037167470564655, block size (bytes): 3799552920364624
Product [hashmap]: 6 objects, 0 bytes (0B): good
  File path: /Users/tomas/.dboo/databases/a81e8a1c79080013/a81f8a1c7908002f.tix
  Cache: 123145485285969, used: 0 update buffer: 0, used: 0
  Block count: 17293822569102704640, index entries per block: 123145485223297, block size (bytes): 8773638964139
Purchase [hashmap]: 100 objects, 0 bytes (0B): good
  File path: /Users/tomas/.dboo/databases/a81e8a1c79080013/a81f8a1c79080040.tix
  Cache: 123145485285968, used: 0 update buffer: 0, used: 0
  Block count: 4294966302, index entries per block: 123145485285962, block size (bytes): 123145485285961

Non-interactive

tomas@tomsmbp:~/ > dboo example_queries -u=example_user -p=password -- list indices
Customer [hashmap]: 7 objects, 0 bytes (0B): good
Product [hashmap]: 6 objects, 0 bytes (0B): good
Purchase [hashmap]: 100 objects, 0 bytes (0B): good