influx_inspect

Commands
buildtsi Converts in-memory (TSM-based) shards to TSI.
deletetsm Bulk deletes a measurement from a raw TSM file.
dumptsi Dumps low-level details about TSI files.
-series-file  directory under the database data directory. Required.
default:summary statistics are provided for each file.  
[ -series ] [ -measurements ] [ -tag-keys ] [ -tag-values ] [ -tag-value-series ]                       
[ -measurement-filter reg_expr ] [ -tag-key-filter reg_expr ]   [ -tag-value-filter reg_expr ] 

Examples
Specifying paths to the _series and index directories
$ influx_inspect dumptsi -series-file /path/to/db/_series /path/to/index


dumptsm Dumps low-level details about TSM files.
[ -index ] [ -blocks ] [ -all ] all prints a lot of information. Default value is false.  
[ -filter-key key_name ] block data that match this key substring. Default value is "".


./data/ruuvi/autogen/ 5/000000003-000000002.tsm 10/000000003-000000002.tsm 39/000000001-000000002.tsm 47/000000001-000000001.tsm 55/000000001-000000001.tsm 63/000000001-000000001.tsm 71/000000001-000000001.tsm 79/000000004-000000002.tsm 87/000000008-000000002.tsm 95/000000002-000000002.tsm 103/000000003-000000002.tsm 111/000000006-000000002.tsm 119/000000115-000000002.tsm 126/000000003-000000002.tsm 135/000000001-000000001.tsm 143/000000002-000000002.tsm 151/000000001-000000001.tsm 159/000000001-000000001.tsm 167/000000001-000000001.tsm 175/000000001-000000001.tsm 183/000000001-000000001.tsm 191/000000001-000000001.tsm 199/000000007-000000002.tsm 204/000000003-000000002.tsm 212/000000001-000000001.tsm 219/000000001-000000001.tsm 227/000000047-000000002.tsm 230/000000003-000000002.tsm 239/000000002-000000002.tsm 247/000000001-000000001.tsm 255/000000005-000000002.tsm 263/000000001-000000001.tsm 271/000000013-000000002.tsm /var/lib/influxdb > sudo find . -name \*.tsm -ls |sedfind |\ grep ruuvi|cut -c59-|sort -M May 13 2018 47/000000001-000000001.tsm May 20 2018 55/000000001-000000001.tsm May 27 2018 63/000000001-000000001.tsm Jun 3 2018 71/000000001-000000001.tsm Jun 11 00:00 79/000000004-000000002.tsm Jun 17 23:59 87/000000008-000000002.tsm Jun 25 00:00 95/000000002-000000002.tsm Jul 2 00:00 103/000000003-000000002.tsm Jul 9 00:00 111/000000006-000000002.tsm Jul 23 00:00 126/000000003-000000002.tsm Jul 29 20:10 135/000000001-000000001.tsm Aug 5 23:59 143/000000002-000000002.tsm Aug 12 20:10 151/000000001-000000001.tsm Aug 19 20:10 159/000000001-000000001.tsm Aug 26 20:10 167/000000001-000000001.tsm Sep 2 20:10 175/000000001-000000001.tsm Sep 9 20:10 183/000000001-000000001.tsm Sep 16 20:10 191/000000001-000000001.tsm Sep 24 00:10 199/000000007-000000002.tsm Oct 1 00:10 204/000000003-000000002.tsm Oct 7 20:10 212/000000001-000000001.tsm Oct 14 20:10 219/000000001-000000001.tsm Oct 29 00:09 230/000000003-000000002.tsm data2/ruuvi/autogen Nov 4 23:10 239/000000002-000000002.tsm data2/ruuvi/autogen Nov 11 19:10 247/000000001-000000001.tsm data2/ruuvi/autogen Nov 20 16:16 255/000000005-000000002.tsm data2/ruuvi/autogen Nov 25 19:10 263/000000001-000000001.tsm data2/ruuvi/autogen Dec 1 20:01 39/000000001-000000002.tsm Dec 2 17:42 10/000000003-000000002.tsm Dec 2 17:42 119/000000115-000000002.tsm Dec 2 17:42 227/000000047-000000002.tsm Dec 2 17:42 5/000000003-000000002.tsm Dec 2 23:10 271/000000013-000000002.tsm
dumptsmwal Dump all data from a WAL file.
export Exports raw data from a shard in Line Protocol format.
report Displays a shard level report.
reporttsi Reports on cardinality for measurements and shards.
verify Verifies the integrity of TSM files.
verify-seriesfile Verifies the integrity of series files.

influx site