# 'show indexes' equivalent of python client?

**URL:** <https://discuss.aerospike.com/t/show-indexes-equivalent-of-python-client/3886>\
**Category:** General Discussion\
**Tags:** python\
**Created:** [February 25, 2017, 1:54pm UTC](https://discuss.aerospike.com/t/show-indexes-equivalent-of-python-client/3886 "2017-02-25T13:54:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Charuvind\_Atre](https://avatars.discourse-cdn.com/v4/letter/c/ac91a4/32.png) [@Charuvind\_Atre](https://discuss.aerospike.com/u/Charuvind_Atre)\
**Post date:** [February 25, 2017, 1:54pm UTC](https://discuss.aerospike.com/t/show-indexes-equivalent-of-python-client/3886/1 "2017-02-25T13:54:08Z")

</div>

in aql, I can type show indexes to get all secondary indexes. is there a way for python client as well?

---

<div class="post-metadata">

**Author:** ![rbotzer](https://sea1.discourse-cdn.com/flex019/user_avatar/discuss.aerospike.com/rbotzer/32/2114_2.png) [@rbotzer](https://discuss.aerospike.com/u/rbotzer)\
**Post date:** [February 26, 2017, 1:15am UTC](https://discuss.aerospike.com/t/show-indexes-equivalent-of-python-client/3886/2 "2017-02-26T01:15:16Z")

</div>

Alright, let’s assume a new numeric index is created over the namespace _test_, set _demo_ and bin _age_:

```sql
aql> CREATE INDEX demo_age_idx ON test.demo(age) NUMERIC
OK, 1 index added.

aql> show indexes
+--------+-------+-----------+--------+-------+----------------+-------+------------+-----------+
| ns | bin | indextype | set | state | indexname | path | sync_state | type |
+--------+-------+-----------+--------+-------+----------------+-------+------------+-----------+
| "test" | "age" | "NONE" | "demo" | "RW" | "demo_age_idx" | "age" | "synced" | "NUMERIC" |
+--------+-------+-----------+--------+-------+----------------+-------+------------+-----------+
1 row in set (0.001 secs)
OK

```

The Python client’s [`Client.info`](http://www.aerospike.com/apidocs/python/client.html#aerospike.Client.info) method can be used to issue the info command [`sindex`](http://www.aerospike.com/docs/reference/info#sindex):

```python
from __future__ import print_function
import aerospike

config = {'hosts': [('33.33.33.91', 3000)] }
client = aerospike.client(config).connect()

response = client.info('sindex/test')
print(response)
client.close()

```

Which returns a `dict` containing a string that you’ll need to parse:

```python
{'BB977293B290C00': (None, 'ns=test:set=demo:indexname=demo_age_idx:bin=age:type=NUMERIC:indextype=NONE:path=age:sync_state=synced:state=RW;\n')}

```

---

<div class="post-metadata">

**Author:** ![Charuvind\_Atre](https://avatars.discourse-cdn.com/v4/letter/c/ac91a4/32.png) [@Charuvind\_Atre](https://discuss.aerospike.com/u/Charuvind_Atre)\
**Post date:** [February 27, 2017, 2:37am UTC](https://discuss.aerospike.com/t/show-indexes-equivalent-of-python-client/3886/3 "2017-02-27T02:37:20Z")

</div>

Thank you @rbotzer for a detailed answer. That surely worked. Can we expect parsed data in future releases?