Is there a Redis command for fetching all keys in the database? I have seen some python-redis libraries fetching them. But was wondering if it is possible from redis-client.
18 Answers
Try to look at KEYS command. KEYS * will list all keys stored in redis.
EDIT: please note the warning at the top of KEYS documentation page:
Time complexity: O(N) with N being the number of keys in the database, under the assumption that the key names in the database and the given pattern have limited length.
UPDATE (V2.8 or greater): SCAN is a superior alternative to KEYS, in the sense that it does not block the server nor does it consume significant resources. Prefer using it.
4 Comments
redis-cli keys "*"KEYS has the potential of blocking the server for longer when querying a large data setKEYS "*" (with quotes) was what I missed, thank you @XåpplI'-I0llwlg'I- ! Good to note: Quotes are needed to run inline (redis-cli KEYS "*"), but inside the cli shell no quotes are needed (KEYS *)Updated for Redis 2.8 and above
As noted in the comments of previous answers to this question, KEYS is a potentially dangerous command since your Redis server will be unavailable to do other operations while it serves it. Another risk with KEYS is that it can consume (dependent on the size of your keyspace) a lot of RAM to prepare the response buffer, thus possibly exhausting your server's memory.
Version 2.8 of Redis had introduced the SCAN family of commands that are much more polite and can be used for the same purpose.
The CLI also provides a nice way to work with it:
$ redis-cli --scan --pattern '*'
2 Comments
redis-cli --scan * does it has some downside?redis-cli --scan should just workIt can happen that using redis-cli, you connect to your remote redis-server, and then the command:
KEYS *
is not showing anything, or better, it shows:
(empty list or set)
If you are absolutely sure that the Redis server you use is the one you have the data, then maybe your redis-cli is not connecting to the Redis correct database instance.
As it is mentioned in the Redis docs, new connections connect as default to the db 0.
In my case KEYS command was not retrieving results because my database was 1. In order to select the db you want, use SELECT.
The db is identified by an integer.
SELECT 1
KEYS *
I post this info because none of the previous answers was solving my issue.
4 Comments
redis-cli keys "*", rather than first connecting to the server.-n option, e.g. redis-cli -n 13 KEYS '*' if you are using database 13SELECT 1 was a super crucial info! Thanks!Get All Keys In Redis
Get all keys using the --scan option:
$ redis-cli --scan --pattern '*'
List all keys using the KEYS command:
$ redis-cli KEYS '*'
1 Comment
keys * command is blocking on large DBs-->Get all keys from redis-cli
-redis 127.0.0.1:6379> keys *
-->Get list of patterns
-redis 127.0.0.1:6379> keys d??
This will produce keys which start by 'd' with three characters.
-redis 127.0.0.1:6379> keys *t*
This wil get keys with matches 't' character in key
-->Count keys from command line by
-redis-cli keys * |wc -l
-->Or you can use dbsize
-redis-cli dbsize
3 Comments
key *t* to keys *t*.Take a look at following Redis Cheat Sheet. To get a subset of redis keys with the redis-cli i use the command
KEYS "prefix:*"
Comments
SCAN doesn't require the client to load all the keys into memory like KEYS does. SCAN gives you an iterator you can use. I had a 1B records in my redis and I could never get enough memory to return all the keys at once.
Here is a python snippet to get all keys from the store matching a pattern and delete them:
import redis
r = redis.StrictRedis(host='localhost', port=6379, db=0)
for key in r.scan_iter("key_pattern*"):
print key
Comments
Yes, you can get all keys by using this
var redis = require('redis');
redisClient = redis.createClient(redis.port, redis.host);
redisClient.keys('*example*', function (err, keys) {
})
1 Comment
redis-cli -h <host> -p <port> keys *
where * is the pattern to list all keys
1 Comment
redis-cli -h <host> -p <port> keys '*'KEYS pattern
Available since 1.0.0.
Time complexity: O(N) with N being the number of keys in the database, under the assumption that the key names in the database and the given pattern have limited length.
Returns all keys matching pattern.
Warning : This command is not recommended to use because it may ruin performance when it is executed against large databases instead of KEYS you can use SCAN or SETS.
Example of KEYS command to use :
redis> MSET firstname Jack lastname Stuntman age 35
"OK"
redis> KEYS *name*
1) "lastname"
2) "firstname"
redis> KEYS a??
1) "age"
redis> KEYS *
1) "lastname"
2) "age"
3) "firstname"
Comments
In order to get all the keys available in redis server, you should open redis-cli and type:
KEYS *
In order to get more help please visit this page:
This Link
Comments
If your redis is a cluster,you can use this script
#!/usr/bin/env bash
redis_list=("172.23.3.19:7001,172.23.3.19:7002,172.23.3.19:7003,172.23.3.19:7004,172.23.3.19:7005,172.23.3.19:7006")
arr=($(echo "$redis_list" | tr ',' '\n'))
for info in ${arr[@]}; do
echo "start :${info}"
redis_info=($(echo "$info" | tr ':' '\n'))
ip=${redis_info[0]}
port=${redis_info[1]}
echo "ip="${ip}",port="${port}
redis-cli -c -h $ip -p $port set laker$port '湖人总冠军'
redis-cli -c -h $ip -p $port keys \*
done
echo "end"
Comments
You can simply connect to your redis server using redis-cli, select your database and type KEYS *, please remember it will give you all the keys present in selected redis database.
2 Comments
Using nodejs client:
command line:
mkdir noderedis; cd noderedis; npm init -y; npm i redis; touch app.js;
app.js
const redis = require('redis');
async function redisClient(){
console.log('initiating redis client');
const client = redis.createClient(
{
socket: {
host: '127.0.0.1',
port: 6379
}
});
client.on('error', (err) => console.error);
console.log('trying to connect');
await client.connect();
console.log('connected');
const keys = await client.sendCommand(["keys","*"]);
if(!keys || keys.length == 0){
console.log('No Keys in Redis');
} else {
console.log('printing all keys:')
console.log(keys);
}
await client.disconnect();
}
redisClient();
execute:
node app.js
Comments
For the ones that want a typescript helper (using ioredis)
import Redis from 'ioredis';
import { from, Observable, of } from 'rxjs';
import { first, mergeMap } from 'rxjs/operators';
export function scanKeysFromRedis(redisStore: Redis.Redis, key: string,
target: number = 0, keys: string[] = []): Observable<string[]> {
return from(redisStore.scan(target, 'MATCH', key)).pipe(
first(),
mergeMap((_keys) => {
const _target = Number(_keys[0]);
if (_target !== 0) {
return scanKeysFromRedis(redisStore, key, _target, [...keys, ..._keys[1]]);
}
return of([...keys, ..._keys[1]]);
}),
);
}
and call it with: scanKeysFromRedis(store, 'hello');
Comments
Using Python3:
mkdir pyredis; cd pyredis; python3 -m venv ./; source ./bin/activate; pip install redis; touch pyredis.py
import redis
print('# connecting to Redis server')
r = redis.Redis(host='localhost', port=6379, db=0)
print('# printing the keys')
for key in r.scan_iter():
print(key)
print('# all keys printed')
python3 pyredis.py
Comments
We should be using --scan --pattern with redis 2.8 and later.
You can try using this wrapper on top of redis-cli. https://github.com/VijayantSoni/redis-helper
KEYSon your production server unless you know what you're doing.