In AgensGraph, every node is created as a new table, so automating index creation with scripts is common.
To check index usage effectiveness, use pg_stat_all_indexes to see how often indexes are used. To improve update or insert performance, consider deleting unused indexes.