Sample Header Ad - 728x90

How to check how many keys stored in Aerospike?

1 vote
1 answer
1008 views
I am new to Aerospike and exploring AQL and ASADM. I Executed command "show sets" and got response -
aql> show sets
+------------------+-------------+---------+-------------------+---------------+-------------------+-------------------+--------------+------------+
| disable-eviction | ns          | objects | stop-writes-count | set           | memory_data_bytes | device_data_bytes | truncate_lut | tombstones |
+------------------+-------------+---------+-------------------+---------------+-------------------+-------------------+--------------+------------+
| "false"          | "tvpreprod" | "35249" | "0"               | "data"        | "1684642852"      | "0"               | "0"          | "0"        |
| "false"          | "tvpreprod" | "12229" | "0"               | "epg"         | "3035957260"      | "0"               | "0"          | "0"        |
| "false"          | "tvpreprod" | "6009"  | "0"               | "account"     | "6288324"         | "0"               | "0"          | "0"        |
| "false"          | "tvpreprod" | "24821" | "0"               | "epg_account" | "59593681"        | "0"               | "0"          | "0"        |
| "false"          | "tvstage"   | "2956"  | "0"               | "data"        | "66573412"        | "0"               | "0"          | "0"        |
| "false"          | "tvstage"   | "1873"  | "0"               | "account"     | "1984140"         | "0"               | "0"          | "0"        |
| "false"          | "tvstage"   | "18060" | "0"               | "epg_account" | "30209254"        | "0"               | "0"          | "0"        |
| "false"          | "tvstage"   | "5197"  | "0"               | "epg"         | "1792880530"      | "0"               | "0"          | "0"        |
+------------------+-------------+---------+-------------------+---------------+-------------------+-------------------+--------------+------------+
[xx.xx.xx.xx:3000] 8 rows in set (0.781 secs)
But on executing : select * from tvstage.data, I got result -
138 rows in set (3.796 secs)
I am not able to understand why there is difference in count? **Show sets** gives 2956 records, but **Select** shows only 138 records. All the keys pushed are having different TTLs and expiry is set to not more than 24 hours
Asked by Vibhav Singh Rohilla (199 rep)
Aug 25, 2022, 01:06 PM
Last activity: Mar 18, 2025, 01:03 AM