You can retrieve a JSON representation of an index by using the
DESCRIBE AS JSON INDEX statement:
DESCRIBE AS JSON INDEX index_name ON table_name
where:
index_name is the name of the index you want to describe.
table_name is the name of the table to which the index is applied.